'
WHERE variable\_name='mysql-monitor\_password';
6)
mysql@proxysql\> LOAD MYSQL VARIABLES TO RUNTIME;
mysql@proxysql\> SAVE MYSQL VARIABLES TO DISK;
7) however when doing this to ensure that monitoring is enabled,:
mysql@proxysql\> SELECT \* FROM monitor.mysql\_server\_connect\_log ORDER BY time\_start\_us
˓→DESC LIMIT 6;
it say monitor.mysql\_server\_connect\_log doesn't exists ! why ?
7) to enabled mnnitorings of these nodes, load them at runtime:
mysql@proxysql\> LOAD MYSQL SERVERS TO RUNTIME;
8) Creating ProxySQL Monitoring User
mysql@pxc2\> CREATE USER 'proxysql'@'%' IDENTIFIED WITH mysql\_native\_password by '$3Kr
˓→$t';
mysql@pxc2\> GRANT USAGE ON \*.\* TO 'proxysql'@'%';
9) Creating ProxySQL Client User
is this one create in proxySQL level or database level? which user account has to be create on both proxySQL side and DB size?
is this one user connect to DB back bone via proxySQL ?
so this one must both in proxysql and DB level ? both must use the SAME password?
Is this one the application account application use to connect to DB via proxy ?
question:
1) once I connect using client user, it will be timeout message when connect to the proxySQL!
and what is the mapping so that proxySQL know which account used to connect to backed DB ? it is not the monitor account which we have to create in dB side, right?
2) what is missing in the above steps ?
---
### Author:  [@Guru](https://forums.percona.com/u/Guru)
#### Post date: [August 7, 2020, 3:26am UTC](https://forums.percona.com/t/when-work-with-latest-edition-of-proxysql/7848/2 "2020-08-07T03:26:47Z")
you must have on ProxySQL all the same User like in DB with the same Passwords
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 7, 2020, 3:57am UTC](https://forums.percona.com/t/when-work-with-latest-edition-of-proxysql/7848/3 "2020-08-07T03:57:42Z")
wait, this mean in proxySQL I have to create the same user in Percona DB as well and their passwrod the same ?
---
### Author:  [@Guru](https://forums.percona.com/u/Guru)
#### Post date: [August 7, 2020, 8:21am UTC](https://forums.percona.com/t/when-work-with-latest-edition-of-proxysql/7848/4 "2020-08-07T08:21:18Z")
Yes!But you dont neet to use the same Password in plain text, you kann take the hash from user table.
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 7, 2020, 8:26am UTC](https://forums.percona.com/t/when-work-with-latest-edition-of-proxysql/7848/5 "2020-08-07T08:26:36Z")
“But you dont neet to use the same Password in plain text,”
both password save in the database right? I am not sure what you mean plain text ! as long as the same user with same password, user connected to the proxySQL will AUTOMATICALLY route to the backend percona cluster node?
how about the user account permission of that user account? must be the same again ?
---
### Author:  [@Guru](https://forums.percona.com/u/Guru)
#### Post date: [August 7, 2020, 9:45am UTC](https://forums.percona.com/t/when-work-with-latest-edition-of-proxysql/7848/6 "2020-08-07T09:45:21Z")
> DBA100 said: "But you dont neet to use the same Password in plain text,"
>
> both password save in the database right? I am not sure what you mean plain text ! as long as the same user with same
> password, user connected to the proxySQL will AUTOMATICALLY route to the backend percona cluster node?
>
> how about the user account permission of that user account? must be the same again ?
for example:
plain text password: geheimhash in user table: \*EC575F87BA2EC345EAE587C23C33B0353D4DBA59You are free to use in ProxySQL one of them.I recommend using the hash, then you can simplify the synchronization of the users between the DB and the ProxySQL with a script.
Yes, ProxySQL will automatically route to the DB.
---
### Author:  [@Guru](https://forums.percona.com/u/Guru)
#### Post date: [August 7, 2020, 9:50am UTC](https://forums.percona.com/t/when-work-with-latest-edition-of-proxysql/7848/7 "2020-08-07T09:50:03Z")
please read this:[http://blog.muhrizal.com/2017/12/13/Configure-ProxySQL-on-Ubuntu-16-04/](http://blog.muhrizal.com/2017/12/13/Configure-ProxySQL-on-Ubuntu-16-04/)
[https://www.digitalocean.com/community/tutorials/how-to-use-proxysql-as-a-load-balancer-for-mysql-on-ubuntu-16-04](https://www.digitalocean.com/community/tutorials/how-to-use-proxysql-as-a-load-balancer-for-mysql-on-ubuntu-16-04 "Link: https://www.digitalocean.com/community/tutorials/how-to-use-proxysql-as-a-load-balancer-for-mysql-on-ubuntu-16-04")
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 8, 2020, 6:22am UTC](https://forums.percona.com/t/when-work-with-latest-edition-of-proxysql/7848/8 "2020-08-08T06:22:12Z")
let me check and come back later if I need.
---
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 24, 2020, 1:06am UTC](https://forums.percona.com/t/when-work-with-latest-edition-of-proxysql/7848/9 "2020-08-24T01:06:10Z")
when I follow this to setup ProxySQL V2:
[http://blog.muhrizal.com/2017/12/13/Configure-ProxySQL-on-Ubuntu-16-04/](http://blog.muhrizal.com/2017/12/13/Configure-ProxySQL-on-Ubuntu-16-04/)
in this steps:
Add a monitoring user on ProxySQL:
|
```auto
1
2
```
| ``` mysql\> CREATE USER 'proxysql'@'%' IDENTIFIED BY 'ProxySQLPassword';
mysql\> GRANT USAGE ON \*.\* TO 'proxysql'@'%'; ``` |
it seems proxysQL admin console do not allow me to do this and it say:
ERROR 1045 (28000): ProxySQL Admin Error: near "USER": syntax error.
when you login to the ProxySQL admin console by this:
``` mysql -u admin -padmin -h 127.0.0.1 -P6032 --prompt='Admin\> ' ```
the prompt is always:
Admin\>
instead of
MySQL\>
is it a mistake ? that's why I can't use this command to create a user in ProxySQL;
``` CREATE USER 'proxysql'@'%' IDENTIFIED BY 'ProxySQLPassword'; ``` ?
or actually I need this to add a proxySQL users?
INSERT INTO mysql\_users (username,password) VALUES (' \ ',' \
### Author:  [@DBA100](https://forums.percona.com/u/DBA100)
#### Post date: [August 24, 2020, 9:14am UTC](https://forums.percona.com/t/when-work-with-latest-edition-of-proxysql/7848/10 "2020-08-24T09:14:47Z")
I checked and it seems that manual is wrong and we should follow the offical proxySQL guide:
[https://proxysql.com/documentation/ProxySQL-Configuration/](https://proxysql.com/documentation/ProxySQL-Configuration/ "Link: https://proxysql.com/documentation/ProxySQL-Configuration/")
and I found sth wong in other page, it said:
Admin\> INSERT INTO mysql\_servers(hostgroup\_id,hostname,port) VALUES (1,‘127.0.0.1’,21891);
Query OK, 1 row affected (0.01 sec)
Admin\> INSERT INTO mysql\_servers(hostgroup\_id,hostname,port) VALUES (1,‘127.0.0.1’,21892);
Query OK, 1 row affected (0.01 sec)
Admin\> INSERT INTO mysql\_servers(hostgroup\_id,hostname,port) VALUES (1,‘127.0.0.1’,21893);
Query OK, 1 row affected (0.00 sec)
but in section;
Admin\> SHOW CREATE TABLE mysql\_replication\_hostgroups\G
```auto
table: mysql_replication_hostgroups
Create Table: CREATE TABLE mysql_replication_hostgroups (
writer_hostgroup INT CHECK (writer_hostgroup>=0) NOT NULL PRIMARY KEY,
reader_hostgroup INT NOT NULL CHECK (reader_hostgroup<>writer_hostgroup AND reader_hostgroup>0),
comment VARCHAR,
UNIQUE (reader_hostgroup))
1 row in set (0.00 sec)
Admin> INSERT INTO mysql_replication_hostgroups VALUES (1,2,'cluster1');
Query OK, 1 row affected (0.00 sec)
```
but on my end the SHOW CREATE TABLE mysql\_replication\_hostgroups\G shows:
[](https://filedb.experts-exchange.com/incoming/2020/08_w35/1495957/1598280060300.png)
check my output (the schema) is not the same so when I do:
```auto
INSERT INTO mysql_replication_hostgroups VALUES (1,2,'cluster1');
```
it shown:
[](https://filedb.experts-exchange.com/incoming/2020/08_w35/1495960/1598280190600.png)
as the schema is not the same! what should I input?