navicat远程连接报 access denied for user'root'@'your mysql server ip'(using pasword:yes" 错误

第二步：执行 GRANT ALL PRIVILEGES ON *.* TO‘root‘@‘%‘ IDENTIFIED BY ‘root‘ WITH GRANT OPTION;

如下图所示：

然后就可以利用navicat访问远程mysql服务器了！

navicat远程连接报 access denied for user'root'@'your mysql server ip'(using pasword:yes" 错误

标签：