缺省状态下,mysql的用户没有远程访问的权限。
有以下二种方法可以设置
一、修改管理员表
c:\mysql\bin\mysql -u root -p
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
二、进行授权
c:\mysql\bin\mysql -h localhost -u root
(1)对所有主权进行授权
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
(2)只针对特定IP进行授权
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.1' IDENTIFIED BY '123456' WITH GRANT OPTION;
最行设置修改生效
mysql>FLUSH PRIVILEGES;
退出
mysql>exit