MYSQL (客户端)远程连接报10038错误的三行代码
文章目录
保证能如命令行进入MYSQL
mysql> use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root'
WITH GRANT OPTION刷新权限
flush privileges;
修改配置文件
/etc/mysql/my.conf或者在/etc/mysql/mysql.conf.d
注释掉此行
#bind-address = 127.0.0.1如果找不到bind-address
root@php56:/etc/mysql# find /etc/mysql/ -name "*.cnf" |xargs grep "bind-address"
./mysql.conf.d/mysqld.cnf:bind-address = 127.0.0.1
root@php56:/etc/mysql#
1045
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'A!abc123456.' WITH GRANT OPTION;

评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论