mysql 授予遠端連線直接存取

標籤：

不通過ssh通道，mysql 授予遠端連線直接存取

語句

GRANT ALL PRIVILEGES ON *.* TO [email protected]‘%‘ IDENTIFIED BY ‘!DSJdg!‘ WITH GRANT OPTION; 

 後來revoke 一下，錯誤。

重新grant 出現錯誤。

mysql> GRANT ALL PRIVILEGES ON *.* TO [email protected]‘%‘ IDENTIFIED BY ‘!DSJdg!‘ WITH GRANT OPTION;
ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)

----------------------

解決方案：

刪除一些

delete from user where user="root" and host="%";

重新賦予許可權grant select, insert, update, delete, create,drop on *.* to [email protected]‘%‘ identified by ‘!DSJdg!‘;

 

mysql 授予遠端連線直接存取