Toad World® Forums

Hello,I am getting error while conencting to MySQL server.


#1

Hello, I installed toad edge v1.2 on my Windows machine.But when i am trying to connect to MySQL server 8.0.11 ,it is showing error as-

"Unable to load authentication plugin ‘caching_sha2_password’.

Also, this connection issue is only with toadedge.If i connect using MySQL workbench, connection is working properly

Please let me know how to resolve it.


#2

MySQL 8 is not supported. Refer

Database requirements

MySQL
5.5, 5.6, 5.7

www.quest.com/…/


#3

Thank you for your response…Then which version of Toad I can use for MySQL 8 ?

On Tue, May 8, 2018, 5:31 PM dvohra10 bounce-dvohra10@toadworld.com wrote:

RE: Hello,I am getting error while conencting to MySQL server.

Reply by dvohra10
MySQL 8 is not supported. Refer

Database requirements

MySQL
5.5, 5.6, 5.7

www.quest.com/…/

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad Edge - Forum notifications altogether.

Flag this post as spam/abuse.


#4

The issue is not with Toad Edge but with MySQL 8.

  1. Change the encryption of the user’s password by altering the user with below Alter command :

ALTER USER ‘username’@‘ip_address’ IDENTIFIED WITH mysql_native_password BY ‘password’;

Or

  1. Change the authentication plugin in my.cnf file for Linux / my.ini file in Windows:

[mysqld]

default_authentication_plugin=mysql_native_password

Restart the mysql server to take the changes in affect and try connecting via mysql with any mysql client.