# mysql -u root -proot mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION; 允許地址202.11.10.253上用root用戶,密碼dboomysql來連接mysql的所有數據庫,付給select,insert,update,delete權限。
# mysql -u root -proot grant select,insert,update,delete on *.* to root@"202.11.10.253" Identified by "dboomysql"; 允許地址202.11.10.253上用root用戶,密碼dboomysql來連接mysql的所有數據庫,付給所有權限。
# mysql -u root -proot
grant all on *.* to root@"202.11.10.253" Identified by "dboomysql"