mysql连接linux系统提示“登录出现1130 is not allowed to connect to this MySql server”问题,解决方法

运行命令:mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

eg:mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.3' IDENTIFIED BY 'root' WITH GRANT OPTION;

用户名和密码、IP换成自己的

 

posted on 2015-09-29 17:06  ziyi_ang  阅读(1065)  评论(0编辑  收藏  举报

导航