PAM and SingleStoreDB (connection with MySQL Client)
On this page
Typically, SingleStoreDB users (those users created and managed with GRANT … IDENTIFIED BY) are managed by the database internally, and do not exist anywhere else on the Linux/Unix system.
When connecting, the MySQL client normally sends a hashed password to the server.
/etc/shadow) uses a different hash, which can only be calculated from the cleartext password.
mysql -u steve -h 0 --enable-cleartext-plugin -p
Note that since the password is sent in cleartext, SSL is strongly recommended.
Last modified: April 6, 2023