MySQL数据库配置远程连接 / 只允许SSH连接

刚刚安装的数据库是只允许本地连接的，这时候如果想用 navicat 连接数据库的话就得用 SSH 连接模式

如果需要给mysql开启远程连接的权限

mysql> use mysql;
mysql> grant all privileges on “*（所有权限）” to “root（登录名）”@”%（%表示任何电脑，也可以指定ip，指定ip不用写%）” identified by “（登录密码）” with grant option;

flush privileges;

如果开启权限之后又想取消权限

mysql>  use mysql;
mysql>  select host,user from user;

+-----------+---------------+
| host      | user          |
+-----------+---------------+
| %         | root          |
| localhost | mysql.session |
| localhost | mysql.sys     |
| localhost | root          |
+-----------+---------------+

mysql> delete from user where host='%';
mysql> flush priviledges;

OK 解决