1. mysql -u root -p
2. 授权用户root使用密码123456从指定ip为218.12.50.77的主机连接到mysql服务器:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'218.12.50.77' IDENTIFIED BY '123456' WITH GRANT OPTION;
3. 任意IP主机连接到mysql 服务器:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
4. flush privileges;
5. quit
举例: