2. ASPRunnerPro General questions
  3. Cannot connect to mySQL80
This topic is locked

Cannot connect to mySQL80

 		8/3/2018 1:03:05 PM
ASPRunnerPro General questions
E
 ebolisa author

Hi,
My DB server (mySQL57) got corrupted on my win10 laptop and, to make to story short, I upgraded it to mySQL80 and configured my tables.
Now, I cannot connect to the new server with ASPRunner, I get this msg: "Error connecting to the database. Authentication plugin 'caching_sha2_password' cannot be loaded: Cannot find the specified module".
What can I do to regain control of my APSRunner?
Thank you,
EDIT: ASPRunner Professional 9.8 (build 29139 x86)
Admin 8/6/2018

We do not support connections to MySQL 8 yet. This will be added soon in ASPRunnerPro 10.
P
 		pmorenoc07 8/6/2018



Hi,
My DB server (mySQL57) got corrupted on my win10 laptop and, to make to story short, I upgraded it to mySQL80 and configured my tables.
Now, I cannot connect to the new server with ASPRunner, I get this msg: "Error connecting to the database. Authentication plugin 'caching_sha2_password' cannot be loaded: Cannot find the specified module".
What can I do to regain control of my APSRunner?
Thank you,
EDIT: ASPRunner Professional 9.8 (build 29139 x86)


This happen to me and the issue is that MySQL 8 changed the default authentication method and mysql client doesn't understand it.
The solution is to change to native password authentication method.
Open the MySQL 8.0 Command Line client and run this:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your password here';


Thanks