mysql> GRANT ALL ON *.* TO 'root'@'%';
Query OK, 0 rows affected
mysql> flush privileges;
Query OK, 0 rows affected
mysql>
GRANT ALL PRIVILEGES ON *.* TO 'mysqlroot'@'%' with grant option;
Query OK, 0 rows affected
本文介绍如何在MySQL中使用SQL命令授予用户全部权限,并刷新权限以确保更改生效。
mysql> GRANT ALL ON *.* TO 'root'@'%';
Query OK, 0 rows affected
mysql> flush privileges;
Query OK, 0 rows affected
mysql>
GRANT ALL PRIVILEGES ON *.* TO 'mysqlroot'@'%' with grant option;
Query OK, 0 rows affected

被折叠的 条评论
为什么被折叠?