# ProxySQL2 user error **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Created:** [February 20, 2023, 1:08pm UTC](https://forums.percona.com/t/proxysql2-user-error/20193 "2023-02-20T13:08:36Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![A.Wormuth](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@A.Wormuth](https://forums.percona.com/u/A.Wormuth)\ **Post date:** [February 20, 2023, 1:08pm UTC](https://forums.percona.com/t/proxysql2-user-error/20193/1 "2023-02-20T13:08:36Z")
Hi, I’ve done all steps exacly as described in this documentation: [Load balancing with ProxySQL - Percona XtraDB Cluster](https://docs.percona.com/percona-xtradb-cluster/8.0/howtos/proxysql.html) Created the user _sbuser_ on proxysql as well as at the MySQL host. Logging in into the all three mysql hosts directly with _sbuser_ and eg. _show databases_ works well and shows all databases on the MySQL hosts. **But** , logging in into _proxysql_ and _show databases;_ gives an error: _Access denied for user ‘sbuser’@‘192.168.1.25’ (using password: YES)_ Output from _SELECT \* FROM mysql\_servers;_ shows that all three nodes are in status _ONLINE_ Did i do anything wrong or what causes this kind of issue? ---
**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\ **Post date:** [February 20, 2023, 1:45pm UTC](https://forums.percona.com/t/proxysql2-user-error/20193/2 "2023-02-20T13:45:03Z")
Check the mysql\_users tables. Make sure you user ID is setup correctly in that table. Once you are happy with the mysql\_users table, run this command. load mysql users to runtime. Do a quick select \* from runtime\_mysql\_users. You will see your ID in there 2 times. Don’t worry that’s normal. 1 ID is for the front end, other is for back end. Now test your connection to proxysql again. ---
**Author:** ![A.Wormuth](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@A.Wormuth](https://forums.percona.com/u/A.Wormuth)\ **Post date:** [February 20, 2023, 1:51pm UTC](https://forums.percona.com/t/proxysql2-user-error/20193/3 "2023-02-20T13:51:48Z")
Hi, after that _runtime\_mysql\_users_ contains users as you mentioned two times. Sadly, still the same issue _Access denied for user…_ when trying to do someting like showing tables, … with Proxysql. Same issue also when trying this with mysql’s root user. ---
**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\ **Post date:** [February 20, 2023, 2:03pm UTC](https://forums.percona.com/t/proxysql2-user-error/20193/4 "2023-02-20T14:03:53Z")
Verify that the user sbuser is using mysql\_native\_password as it plugin. Example: plugin: mysql\_native\_password authentication\_string: \*RANDOMSTRINGOFTEXT You can get this by select \* from mysql.user where user=‘sbuser’\G ---
**Author:** ![A.Wormuth](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@A.Wormuth](https://forums.percona.com/u/A.Wormuth)\ **Post date:** [February 20, 2023, 2:12pm UTC](https://forums.percona.com/t/proxysql2-user-error/20193/5 "2023-02-20T14:12:50Z")
Perfect, that did it. ---
**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\ **Post date:** [February 20, 2023, 2:43pm UTC](https://forums.percona.com/t/proxysql2-user-error/20193/6 "2023-02-20T14:43:20Z")
Awesome. So happy I could assist. ---
**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\ **Post date:** [February 21, 2023, 3:11pm UTC](https://forums.percona.com/t/proxysql2-user-error/20193/7 "2023-02-21T15:11:00Z")