定义用户:create user test identified by 'test';
+------------------+------+
| host | user |
+------------------+------+
| % | test |
| localhost | |
| localhost | root |
| test.saeg.com.cn | |
| test.saeg.com.cn | root |
+------------------+------+
5 rows in set (0.00 sec)
5.参看用户权限
show grants for root@'localhost';
+------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for test@% |
+------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY PASSWORD '*dfg' WITH GRANT OPTION |
+------------------------------------------------------------------------------------------------------------------------------------------------+
因为你的帐号权限问题才导致此错误。。。所以你要把你访问数据库的帐号的权限改一下。。
具体格式如:grant all on mysql.* to 'root'@'localhost' identified by 'password';
1。mysql.* 你访问的数据库名字。
2。root' 你的用户名
3。'password' 需要修改的密码。。
最后问题解决