Skip to:
proxysql-admin script is not encrypting application user password in mysql_users table
Add "SAVE MYSQL USERS FROM RUNTIME;" in proxysql-admin script to encrypt password in mysql_users table.
mysql> select username,password from runtime_mysql_users; +-------------+-------------------------------------------+ | username | password | +-------------+-------------------------------------------+ | cluster_one | *74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3 | | cluster_one | *74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3 | +-------------+-------------------------------------------+ 2 rows in set (0.00 sec) mysql> select username,password from mysql_users; +-------------+----------+ | username | password | +-------------+----------+ | cluster_one | passw0rd | +-------------+----------+ 1 row in set (0.01 sec) mysql> mysql> SAVE MYSQL USERS FROM RUNTIME; Query OK, 0 rows affected (0.00 sec)mysql> select username,password from mysql_users; +-------------+-------------------------------------------+ | username | password | +-------------+-------------------------------------------+ | cluster_one | *74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3 | +-------------+-------------------------------------------+ 1 row in set (0.00 sec)mysql>
proxysql-admin script is not encrypting application user password in mysql_users table
Add "SAVE MYSQL USERS FROM RUNTIME;" in proxysql-admin script to encrypt password in mysql_users table.
mysql> select username,password from runtime_mysql_users; +-------------+-------------------------------------------+ | username | password | +-------------+-------------------------------------------+ | cluster_one | *74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3 | | cluster_one | *74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3 | +-------------+-------------------------------------------+ 2 rows in set (0.00 sec) mysql> select username,password from mysql_users; +-------------+----------+ | username | password | +-------------+----------+ | cluster_one | passw0rd | +-------------+----------+ 1 row in set (0.01 sec) mysql> mysql> SAVE MYSQL USERS FROM RUNTIME; Query OK, 0 rows affected (0.00 sec)mysql> select username,password from mysql_users; +-------------+-------------------------------------------+ | username | password | +-------------+-------------------------------------------+ | cluster_one | *74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3 | +-------------+-------------------------------------------+ 1 row in set (0.00 sec)mysql>