使用root用戶連接遠程的mysql主機報錯。
打開mysql控制臺
mysql> grant all privileges on *.* to 'root'@'%' identified by '密碼' with grant option;
輸出:
打開mysql控制臺
mysql> grant all privileges on *.* to 'root'@'%' identified by '密碼' with grant option;
輸出:
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
輸出:
輸出:
Query OK, 0 rows affected (0.01 sec)
再次連接mysq服務器,
O了!
去你爹個懶子