1. 授权用户root使用密码jb51从任意主机连接到
mysql服务器：
代码如下:
GRANT ALL PRIVILEGES ON *.*
TO 'root'@'%' IDENTIFIED
BY 'jb51'
WITH
GRANT
OPTION;
flush privileges;
2.授权用户root使用密码jb51从指定
ip为218.12.50.60的主机连接到
mysql服务器：
代码如下:
GRANT ALL PRIVILEGES ON *.*
TO 'root'@'218.12.50.60' IDENTIFIED
BY 'jb51'
WITH
GRANT
OPTION;
flush privileges;