授權(quán)的權(quán)限沒(méi)有打開(kāi)
... ...
mysql> UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@localhost root]# systemctl restart mysql # 切記需要重啟mysql服務(wù)
聯(lián)系客服