前提:修改
/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