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连接啦