Forums: Cannot connect to mySQL80 - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

Cannot connect to mySQL80 Rate Topic: -----

#1 User is offline   ebolisa 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 37
  • Joined: 30-November 05
  • Gender:Male
  • Location:Madrid, Spain

Posted 03 August 2018 - 05:03 PM

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)


0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 16112
  • Joined: 03-February 03
  • Gender:Male

Posted 06 August 2018 - 02:36 PM

We do not support connections to MySQL 8 yet. This will be added soon in ASPRunnerPro 10.
Best regards,
Sergey Kornilov
0

#3 User is offline   pmorenoc07 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 34
  • Joined: 27-February 14

Posted 06 August 2018 - 11:53 PM

View Postebolisa, on 03 August 2018 - 12:03 PM, said:

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
0

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users