1.进入MySQL服务器
d:\mysql\bin\> mysql -h localhost -u root;
2.赋予任何主机访问数据的权限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
或: 允许任何主机使用myuser/mypassword连接到mysql服务器
mysl> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
或: 允许主机-192.168.1.3使用myuser/mypassword连接到mysql服务器
mysq> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
3.mysql> FLUSH PRIVILEGES;
4.mysql> EXIT
;