你用的是什么版本的MySQL?在新的版本中MySQL的密码长度加长了,你试过在Linux下面可以登录MySQL吗?
解决方案 »
- 什么样的技术能实现这个功能
- 请大神帮忙看一下这个正则表达式该怎么写~~
- echo()简化语法?
- 有谁知道.. 当我点机按关闭的时候执行一些PHP代码比如说更新数据库里头的资料什么的.....
- test
- 关于php编程风格的问题
- 有高人知道ADODB中的RecordCount问题吗?
- php与sql server安装问题,急急!!!!
- 怎么现在 都用PHP+MYSQL不用PHP+SQL2000 呢?
- $query="select * from table where name='$_SESSION["name"]'";$_SESSION["name"]中的双引号该怎么打才不会报错??
- 如何自动跳转到已经打开的页面?
- 这样的效果如何实现的?
update user set host='%' where user='root' and host <>'localhost';
flush privileges;
update user set host='%' where user='root' and host <>'localhost';
flush privileges;
------------------------------------------------
这里不是说了吗
has only the SELECT privilege on the mysql.user (all columns
except "Password"), mysql.db (all columns), mysql.host (all
columns) and mysql.tables_priv (all columns except "Grantor" &
"Timestamp") tables.
You must specify the details for the controluser in the
config.inc.php file under the $cfg['Servers'][$i]['controluser']&
$cfg['Servers'][$i]['controlpass'] settings.
The following example assumes you want to use pma as the
controluser and pmapass as the controlpass, but this is only an
example: use something else in your file!
Of course you have to replace localhost by the webserver's host if
it's not the same as the MySQL server's one.
1、建立了任意用户登录
2、为用户分配权限不正确
下面可以作为参考,谢谢楼上各位
GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';
GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
Execute_priv, Repl_slave_priv, Repl_client_priv
) ON mysql.user TO 'pma'@'localhost';
GRANT SELECT ON mysql.db TO 'pma'@'localhost';
GRANT SELECT ON mysql.host TO 'pma'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql.tables_priv TO 'pma'@'localhost';