Mysql拒绝远程访问
8.0版本更换了权限设置和密码加密协议,因此:
mysql> grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
会报出42000错误:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'password' WITH GRANT OPTION' at line 1
</