mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.00 sec)
mysql> create database rice;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'rice'
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'rice'
以上问题是由于root用户没有权限访问mysql造成的
解决:
停掉mysql,执行 mysqld_safe --skip-grant-tables &
启动mysql,use mysql,select user表,查看root用户权限。
做相应修改,例 :update `user` set Host='localhost' where User='root' and Host='189.153.136.139';
重启mysql。ok
转载于:https://blog.51cto.com/vavahe/929797