Navicat连接MySQL 出错:1130 host is not allowed to connect to this MySql server

    xiaoxiao2021-03-25  87

    初次安装完MySQL后,用Navicat等工具连接MySQL时会报错10038错误 2003 - Can’t connet to MySQL server on ‘localhost’ (10038) 。其实是因为MySQL权限问题,默认不允许远程连接,修改权限即可。

    步骤如下:

    mysql -uroot -proot //登录mysql

    mysql>GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ WITH GRANT OPTION; //赋予任何主机访问数据的权限

    mysql>FLUSH PRIVILEGES; //修改生效

    mysql>EXIT //退出

    转载请注明原文地址: https://ju.6miu.com/read-16045.html

    最新回复(0)