【MySQL】【ProxySQL】浅析mysql_users表
ProxySQL> select * from global_variables where variable_name like "%passwords%"; +----------------------+----------------+| variable_name | variable_value |
+----------------------+----------------+
| admin-hash_passwords | true | #确认开启admin-hash_passwords特性
+----------------------+----------------+
1 row in set (0.00 sec)
# 插入新的用户（明文密码）
ProxySQL> insert into mysql_users(username,password,active,default_hostgroup) values ('predecessor_beast','114514',1,69);
Query OK, 1 row affected (0.00 sec)
# 查看明文密码的用户表
ProxySQL> SELECT username,password FROM mysql_users;
+------------------+-------------------------------------------+
| username | password |
+------------------+-------------------------------------------+
| proxysql | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |#之前已经加密过了
| proxysql_web | 123456 |#未加密
| mgr33061 | 123456 |#未加密
| mgr33061_backend | 123456 |#未加密
| predecessor_beast| 114514 |#新插入的未加密用户
+------------------+-------------------------------------------+
# 查看运行环境中的用户表
ProxySQL> select username,password fromruntime_mysql_users;
+------------------+-------------------------------------------+
| username | password |
+------------------+-------------------------------------------+
| proxysql | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | #由于前后端账户的原因
| proxysql_web | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | #原先单个账户成对出现
| mgr33061 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| proxysql | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | #运行环境中的都是已经加密的
| proxysql_web | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| mgr33061_backend | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | #不存在新用户
+------------------+-------------------------------------------+
# 加载到运行环境中
mysql> load mysql users to runtime;
Query OK, 0 rows affected (0.00 sec)
# 从运行环境中下载出来
mysql> save mysql users to memory;
Query OK, 0 rows affected (0.00 sec)
mysql> save mysql users to disk;
Query OK, 0 rows affected (0.00 sec)
# 检查下载出来的用户表
mysql> SELECT username,password FROM mysql_users;
+-------------------+-------------------------------------------+
| username | password |
+-------------------+-------------------------------------------+
| mgr33061 | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| proxysql | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| proxysql_web | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| mgr33061_backend| *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| predecessor_beast | *D9050F2D99C3DDD8138912B7BDF8F4BACBE3A8E7 |
+-------------------+-------------------------------------------+
# 所有明文密码已经被加密，已经加密过的，不会再次加密
页:
[1]