# Connectivity for MySQL user list **URL:** \ **Category:** Ignition\ **Created:** [February 6, 2022, 12:35am UTC](https://forum.inductiveautomation.com/t/connectivity-for-mysql-user-list/55795 "2022-02-06T00:35:04Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Post date:** [February 6, 2022, 12:35am UTC](https://forum.inductiveautomation.com/t/connectivity-for-mysql-user-list/55795/1 "2022-02-06T00:35:04Z")
I have a user list and role list in MySQL. I have a valid database connection in the gateway to MySQL. The user source is configured for the tables in MySQL and used to work. Now, it looks like only the roles are connected. In the gateway I see all the roles that are in my MySQL table, and if I add a role it updates in the gateway. The list of users on the gateway does not match the table in MySQL. If I add a user to the table, it does not show up in the gateway ---
**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\ **Post date:** [February 7, 2022, 8:15pm UTC](https://forum.inductiveautomation.com/t/connectivity-for-mysql-user-list/55795/2 "2022-02-07T20:15:50Z")
Hello, This issue likely warrants a conversation with our Support Department. If you have not done so already you can contact our Support Department here: [Support Home Page | Inductive Automation](https://inductiveautomation.com/support/home/) ---
**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Post date:** [February 9, 2022, 8:13pm UTC](https://forum.inductiveautomation.com/t/connectivity-for-mysql-user-list/55795/3 "2022-02-09T20:13:55Z")
I found that my issue was not the connection. I thought the connection was the problem because my login didn’t work and I thought it couldn’t find the account/password. The problem was the password is a string in MySQL and I was using MD5() in the Authentication Query. When I changed the script to look at the unencrypted string it works. Now I would like to know how to set encrypted passwords in MySQL so that MD5() works ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [February 9, 2022, 8:29pm UTC](https://forum.inductiveautomation.com/t/connectivity-for-mysql-user-list/55795/4 "2022-02-09T20:29:19Z")
MySQL’s JDBC driver handles the encryption for you. ---
**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\ **Post date:** [February 9, 2022, 8:44pm UTC](https://forum.inductiveautomation.com/t/connectivity-for-mysql-user-list/55795/5 "2022-02-09T20:44:31Z")
With a Database User Source, set to Automatic mode, the JDBC driver should encrypt the passwords that are entered when new users are added from the Gateway Webpage. Did you enter the passwords yourself by manually inserting strings into the database? I assume that if you are operating the User Source in Manual mode you would have to hash the passwords yourself and store the hash in the table. The [MySQL Encryption functions](https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html) are a good place to start. ---
**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\ **Post date:** [February 9, 2022, 9:09pm UTC](https://forum.inductiveautomation.com/t/connectivity-for-mysql-user-list/55795/6 "2022-02-09T21:09:51Z")
My user source is Manual, not Automatic