setup_root_user_permissions.sql
· 234 B · MySQL
Raw
CREATE USER 'root'@'%' IDENTIFIED BY 'my_root_pwd';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES; -- 重新整理權限表
ALTER USER 'root'@'%' IDENTIFIED BY 'my_root_pwd';
FLUSH PRIVILEGES; -- 重新整理權限表
| 1 | CREATE USER 'root'@'%' IDENTIFIED BY 'my_root_pwd'; |
| 2 | GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; |
| 3 | FLUSH PRIVILEGES; -- 重新整理權限表 |
| 4 | |
| 5 | ALTER USER 'root'@'%' IDENTIFIED BY 'my_root_pwd'; |
| 6 | FLUSH PRIVILEGES; -- 重新整理權限表 |