mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
//本地操作的权限
mysql> GRANT ALL PRIVILEGES ON *.* TO ' root '@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
//本地操作的权限
mysql> GRANT ALL PRIVILEGES ON *.* TO ' root '@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
转载于:https://my.oschina.net/u/228832/blog/801001