1

I have created a MySQL Cluster using the "Scalable MySQL Cluster with Master-Slave Replication, ProxySQL Load Balancing and Orchestrator" installation instructions. This works as expected.

My Java application can connect to the database using the nodeid endpoint of the Proxysql server and the default user/password emailed during setup.

I have since created another user/password in the MySQL master node with the same permissions as the default user created during setup. However, my Java application gets a "Permission denied" error when trying to use that new user.

If I change the Java application to point directly to the master node instead of the Proxysql node, it works.

Is there another step I must take to enable other db users to be accessed through the Proxysql?

Superdroid
  • 25
  • 5
  • Hello Superdroid, you can follow the steps provided by respected sgi to configure new user for connecting via proxysql. Some additional information can be found in this howto https://github.com/sysown/proxysql/wiki/ProxySQL-Configuration#mysql-users. Just, please, do not expose proxysql 6032 port outside the Jelastic platform for security reasons. – Virtuozzo Sep 02 '17 at 23:24

1 Answers1

2

Yes, you should to enable other db user to be accessed through the proxysql. For enabling a new user please connect to the proxysql node via ssh and execute the next steps:

  • mysql -h 127.0.0.1 -P6032 -uadmin -padmin

  • INSERT INTO mysql_users (username, password, active, default_hostgroup, max_connections) VALUES ('new_user, 'new_user_pass', 1, 10, 1000); for adding new user

  • LOAD MYSQL USERS TO RUNTIME; SAVE MYSQL USERS TO DISK; for loading user to runtime
sgi
  • 36
  • 1