mysql 对本地登录和远程登录设置不同的密码

mysql>  select Host,User from mysql.user;
+-----------+------------+
| Host      | User       |
+-----------+------------+
| %         | quartz_app |
| %         | zjzc_app   |
| 127.0.0.1 | root       |
| ::1       | root       |
| localhost | root       |
+-----------+------------+
5 rows in set (0.03 sec)

此时root只能本地登录,远程不行
mysql 相同的用户具有不同的权限设置和密码:


| GRANT USAGE ON *.* TO 'root'@'' IDENTIFIED BY PASSWORD 'newja01';

| GRANT ALL PRIVILEGES ON `zjzc`.* TO 'zjzc_app'@'10.252.148.164' 


mysql>  GRANT USAGE ON *.* TO 'root'@'%'  IDENTIFIED BY  'newja01';
Query OK, 0 rows affected (0.05 sec)

mysql>  select Host,User from mysql.user;
+-----------+------------+
| Host      | User       |
+-----------+------------+
| %         | quartz_app |
| %         | root       |
| %         | zjzc_app   |
| 127.0.0.1 | root       |
| ::1       | root       |
| localhost | root       |
+-----------+------------+
6 rows in set (0.00 sec)



此时本地登录用的是root 密码是1234567


远程登录用的密码是newja01