Mysql Workbench not connecting through Proxysql

[daveallen...@gmail.com]

I have been able to connect directly to a Persona Xtradb Cluster with MySQL Workbench, but when I try to connect through Proxysql it fails and says:

ProxySQL Error: Access denied for user 'developer'@'10.137.160.59' (using password: NO)

But I am using a password.  I can connect using other GUI tools and from the command line.

To be clear:

(host machine) => (Prosysql machine) => (PXC machine) Using port 6033

Mysql workbench = doesn't work

Querious = works

Command line on the hose machine = works

(host machine) => (PXC machine)  Using port 3306

They all work

So I am not sure why this is happening.  Hoping someone has run across this before.

Thanks for any help you can give me!

[Guilherme Almeida Girardi]

Hello guy!

Coincidentally, today I experienced the same problem.

I sincerely gave up MySQL Workbench, it crashes several times, although it is an interesting work tool.

I clicked on "Report Bug" in order to report the problem, but I had to do an extensive registration and other bureaucracies ...

So, I installed DBeaver on my machine, I'm trying to adapt with it, so far so good ...

[]'s

[Nikolaos Vyzas]

Is the user "developer" present in the ProxySQL Admin "mysql_users" table with the correct credentials?

[daveallen...@gmail.com]

Yes, the developer is in the mysql_users.

I can connect using the mysql client through proxysql to the database.  It is just when I am using MySQL Workbench that it doesn't work when connecting to proxysql.

[Nikolaos Vyzas]

Looking at the error message again:

ProxySQL Error: Access denied for user 'developer'@'10.137.160.59' (using password: NO)

It reports "using password: NO" - is this intentional?

[daveallen...@gmail.com]

I have the password set.  Same config works when connecting directly to MySQL.  For some reason proxysql thinks I didn't set a password.

I did find that a certain version of MySQL Workbench is able to connect.  It is version 6.3.9.  All other versions fail with that error.

To be clear, if I change the host and port to the MySQL server in MySQL Workbench, it works.  No other config changes.

[Eric Tan]

I got the same problem here. Ripped my hair out until i tried connecting through Proxysql using cmdline and it works. Definitely something wrong with Mysql workbench.

Thanks also for suggesting DBeaver. It works!

[Jacob Ayres]

The newer versions of MySQL Workbench default to an authentication mechanism that ProxySQL doesn't support yet.  (Proxysql doesn't support sha256_password or caching_sha2_password).

You can use the old method by adding the following lines in the Advanced / Others section of the connection config:

defaultAuth=mysql_native_password

You may also need to add:

OPT_CHARSET_NAME=utf8

[David Anderson]

Thanks Jacob!!

It works!

Any idea when ProxySQL will add those authentication mechanisms?

Thanks again!

Dave

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Evandro Pereira Santiago]

Thank you very much,

Thats works

[john danilson]

I'm trying a slightly different access from workbench to use the proxysql admin interface on port 6032.  My extra admin user is defined in global_variables and can connect without issue from the mysql cli.  But if I try using workbench I get:  

Failed to Connect to MySQL at <proxysql host>:6032 with user <username>  

ProxySQL Admin Error: near "SHOW": syntax error.  

I presume that workbench is issuing some sort of show command which proxysql does not recognize.  Is there any way to disable that so that workbench can connect?

Thanks, 

John

[xinchun shi]

if you MySQL Workbench version >8.0, when you create connection in MySQL Workbench, in tab "Advanced", input "defaultAuth=mysql_native_password" in the "others".

8.0 use caching_sha2_password replace mysql_native_password, but Proxysql still not support it.

john danilson <jdan...@gmail.com> 于2020年4月21日周二 上午4:13写道：

--

You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/proxysql/9bbb2c66-5fa9-4bed-9e5b-3105c3f41a0e%40googlegroups.com.