远程连接 MySQL 失败

问题描述
　　远程连接 mysql 服务器失败
报以下错误
host 192.168.23.1 is not allowed to connect to mysql server
　　
解决方案
在服务器端打开 MySQL 服务器进行权限授权

# 授权
grant all privileges on *.* to 'root'@'192.168.23.1' identified by 'root';

# 刷新
flush privileges;

Navicat远程连接mysql失败

一:修改mysql配置文件,允许远程连接

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

将bind-address=127.0.0.1注释

二:登录mysql,运行命令

grant all privileges on . to ‘用户名’@’%’ identified by ‘密码’ with grant option;;

flush privileges;

三:重启mysql

service mysql restart