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

38
3



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://keralafolkloreakademy.com/

Xem thêm bài viết khác: https://keralafolkloreakademy.com/giai-tri/

38 COMMENTS

  1. This was straight to the point. Thank you.

    If any of you are getting a problem where your command line crashes after you enter your password..
    use this link: https://mccshreyas.wordpress.com/2018/01/07/how-to-fix-mysql-command-line-crashing-problem/
    It helped me before i was able to solve my problem with this video.

  2. even if i remember my password root .I typed in sql command line .It suddenly got closed what should i do replay it to me please .

  3. Thank you very helpful, the only other thing I noticed is that it helps prevent the same problem happening in the future if you change the MYSQL service to automatic

  4. For those struggling because you who are receiving the error "Unable to connect to root: localhost 3306" or something like that. Boot up the MySQL Installer again. Select "Reconfigure" on the "MySQL Server" line and go through the normal process of installing the server you used the first time to create the Server (default selections are generally fine)… I used the same password. Once you click "Finish" on the installer, try connecting to your server again or entering your password in the MySQL Command Line. It worked for me (twice now) when I encountered this error. Hope this helps if you havent solved it yet.

  5. there is error init.

    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 'USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234'' at line 1
    plz reply as soon as posible

  6. 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!

  7. Big Thx man! It was very useful for me. I had this error too int my ubuntu 18.04. It's worked for me. God Bless You!

  8. Hello, unfortunately, my command line crashes after I press enter right after typing my password. Please help,

  9. 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

  10. 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?

LEAVE A REPLY

Please enter your comment!
Please enter your name here