MySQL Workbench Cannot Connect to Database Server -'caching_sha2_password' cannot be loaded

36
19



Download the command here

How to install latest MySQL in Windows PC

How to reset MySQL root Password

Open MySQL through Command Prompt CMD

‘mysql’ is not recognized as an internal or external command, operable program or batch file.

How to remove mysql root password

How to install latest MySQL WorkBench in a windows pc

Nguồn:https://dothihoa.com/

36 COMMENTS

  1. Mysql: [warning] c:program filesmysqlmysql server 5.7binmysql.exe : ignoring option '–no-beep' due to invalid value "
    Enter password:

    I entered password than close cmd!

  2. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show databases' at line 2

  3. I ran that command & it returned Query OK. Restarted mySLQ services. Do not get the error in MySQL Workbench, but still get this exact error in my browser using LocalHost:3000. Any suggestions?

  4. hola amigos ami me funciono solo hasta que puse la contraseña en la terminal y despues cerre el mysql y lo volvi abrir y puse la contraseña y ya no me salio ese error que suerte tuve.

  5. Hey, I get a syntax error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified with mysql_native_password BY 'password'' at line 1

    Can you help me out?:(

LEAVE A REPLY

Please enter your comment!
Please enter your name here