这是我再6.0 试的结果
(root@192.168.135.148) [(none)] 17:26:53> create user jian@‘192.168.%’ identified by ‘123456’;
Query OK, 0 rows affected (0.13 sec)
(root@192.168.135.148) [(none)] 17:27:10> create user jian@‘192.168.135.%’ identified by ‘123123’;
Query OK, 0 rows affected (0.13 sec)
(root@192.168.135.148) [(none)] 17:28:41> create user jian@‘192.168.%.%’ identified by ‘111111’;
Query OK, 0 rows affected (0.02 sec)
[mysql@jian ~]$ mysql -ujian -p123456 -h192.168.135.148 -P4000
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user ‘jian’@‘192.168.135.149’ (using password: YES)
[mysql@jian ~]$ mysql -ujian -p111111 -h192.168.135.148 -P4000
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user ‘jian’@‘192.168.135.149’ (using password: YES)
[mysql@jian ~]$ mysql -ujian -p123123 -h192.168.135.148 -P4000
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 417
Server version: 5.7.25-TiDB-v6.0.0 TiDB Server (Apache License 2.0) Community Edition, MySQL 5.7 compatible