4.数据库授权magedu用户，允许192.168.1.0/24网段可以连接mysql

4.数据库授权magedu用户，允许192.168.1.0/24网段可以连接mysql

第一台主机上：
[root@centos8-8 ~]# hostname -I
192.168.1.8

[root@centos8-8 ~]# mysql -uroot -pMmagedu0!

(root@localhost) [(none)]> use mysql;

(root@localhost) [mysql]> show databases;
+--------------------+
| Database |
+--------------------+
| db1 |
| hellodb |
| information_schema |
| mysql |
| performance_schema |
| sys |
| zabbix |
+--------------------+

(root@localhost) [mysql]>create user magedu@'192.168.1.%' identified by 'Mmagedu0!';

(root@localhost) [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

(root@localhost) [mysql]>exit

++++++++++++++++++++

第二台主机上：
[root@centos8-18 ~]# systemctl start mysqld

[root@centos8-18 ~]# hostname -I
192.168.1.18

[root@centos8-18 ~]# mysql -umagedu -pMmagedu0! -h192.168.1.8
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.26 Source distribution

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

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 |
+--------------------+
1 row in set (0.01 sec)

 

 

第一台主机上授权：
[root@centos8-8 ~]# hostname -I
192.168.1.8
[root@centos8-8 ~]# mysql -uroot -pMmagedu0!

(root@localhost) [mysql]> grant all privileges on hellodb.* to 'magedu'@'192.168.1.%';
Query OK, 0 rows affected (0.00 sec)

(root@localhost) [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

 

 

第二台主机上再次登录：

[root@centos8-18 ~]# mysql -umagedu -pMmagedu0! -h192.168.1.8

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| hellodb |
| information_schema |
+--------------------+
2 rows in set (0.01 sec)

mysql> use hellodb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------+
| Tables_in_hellodb |
+-------------------+
| classes |
| coc |
| courses |
| scores |
| students |
| teachers |
| toc |
+-------------------+
7 rows in set (0.00 sec)

mysql> select * from scores;
+----+-------+----------+-------+
| ID | StuID | CourseID | Score |
+----+-------+----------+-------+
| 1 | 1 | 2 | 77 |
| 2 | 1 | 6 | 93 |
| 3 | 2 | 2 | 47 |
| 4 | 2 | 5 | 97 |