(之前在网上搜了很多资料,如:
1、修改mysql db下的user表,update user set host = '%' where user = 'root';
2、修改root用户的权限
等等,都不能解决)
最终解决方法为:
修改文件:/etc/my.cnf
[mysqld]
bind-address = 127.0.0.1
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
将红色部分注释掉,如下
[mysqld]
#bind-address = 127.0.0.1
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
修改后重启即可~~`