刚刚安装的数据库是只允许本地连接的,这时候如果想用 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;