linux下安装mysql的步骤可参照:
环境:
window作为MySQL的服务端,linux作为MySQL的客户端。
window:192.168.1.27
linux:192.168.190.129
步骤:
- 由于linux只作为客户端,只要安装 mysql-community-client即可。
yum install mysql-community-client
- 客户端尝试连接远程数据库,发现报错了。
[root@node1 ~]# mysql -h 192.168.1.27 -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.27' (111)
报这个错的原因是window上的mysql服务没有启动。在服务中启动以下MySQL服务即可。再尝试连接,报如下的错误。
[root@node1 soft]# mysql -h192.168.1.27 -p
Enter password:
ERROR 1130 (HY000): Host 'DESKTOP-99U2NLS' is not allowed to connect to this MySQL server
在mysql服务器段做如下的修改即可:
mysql> use mysql;
Database changed
mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.50 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.20 sec)
mysql> select host,user from user;
+-----------+------------------+
| host | user |
+-----------+------------------+
| % | root |
| localhost | mysql.infoschema |
| localhost | mysql.session |
| localhost | mysql.sys |
+-----------+------------------+
4 rows in set (0.01 sec)
- 接下来就可以远程连接了。