实验环境两台虚拟机
虚拟机slave-01:192.168.174.155虚拟机slave-02:192.168.174.156
虚拟机1和虚拟机2都装有mysql-server;在实验前,先将虚拟机的防火墙关闭service iptables stop;
使用虚拟机1登录虚拟机2的mysql服务器。
[root@slave-01 Desktop]# mysql -h"192.168.174.156" -uany -p123456
ERROR 1130 (HY000): Host 'slave-01' is not allowed to connect to this MySQL server我们需要给mysql设置授权的主机、用户名密码及相关的授权操作。
在slave-02登录到mysql后输入命令mysql>grant all privileges on mydb.* to any@'192.168.174.155' identified by '123456'
mysql>flush privileges;这句话的意思是,将对mydb数据库的所有操作权限授予slave-01的主机,登录用户名为any,密码是123456。
[root@slave-01 Desktop]# mysql -h"192.168.174.156" -uany -p123456
Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 8
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mydb |
| test |
+--------------------+
3 rows in set (0.00 sec)
除了mysql表外我们可以看到如上3个数据库。
对于授权操作
grant select,update o n mydb.* to any@'192.168.174.155' identified by '123456'
我们可以授权某些命令,也可以指定操作那个数据的那些表(替换掉*),也可以取消ip地址,所有host均可以。
也可以回收权限
revoke delete on *.* from 'jack'@'localhost';