權限 命令設置
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
grant all on *.* to root@'%' identified by 'yourpassword';
結果
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
grant all on *.* to root@'%' identified by 'yourpassword';
Query OK, 0 rows affected
Query OK, 0 rows affected
完成。重啟服務器。