设置mysql远程连接/读写

前提：修改/etc/mysql/mysql.conf.d/mysqld.conf中的bind参数为：0.0.0.0或者192.168.70.40。

###1. 进入表mysql

mysql> use mysql;

###2. 查看主机和用户信息

mysql> select host,user from user;
+----------------+------------------+
| host           | user             |
+----------------+------------------+
| 127.0.0.1      | root             |
| 192.168.1.5    | root             |
| localhost      | debian-sys-maint |
| localhost      | mysql.session    |
| localhost      | mysql.sys        |
| localhost      | root             |
+----------------+------------------+

###3. 创建新的可登录主机

CREATE USER 'root'@'192.168.1.6' IDENTIFIED BY 'password'; 

###4. 赋予可操作权限
赋予所有权限

GRANT ALL PRIVILEGES ON  *.* TO 'root'@'192.168.1.6' IDEN