Navicat远程链接Mysql设置

ubuntu16.04系统

如果Navicat要远程链接mysql时需要给予一定权限才能够链接

首先修改mysql的配置文件，

vim /etc/mysql/mysql.conf.d/mysqld.cnf 

找到这一行：
 

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address           = 127.0.0.1    这里！！！！
 

将这一行注释或者改为 bind-address                   = 0.0.0.0

接着给予登录权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

# .代表任何数据库，当然也可以指定特别的目录，root代表远程登入用户，也可以根据需要指定;%代表所有ip,当然也可以根据需要指定自己的ip,这样更安全;BY后接远程登入用户的密码

 flush privileges;

最后刷新一下权限，当然重启数据库也OJBK.

然后就可以用Navicat连接啦