Thursday 9 July 2020

MySQL Workbench Cannot Connect to Database Server (Solved)

If you are Facing this error

Add caption
then Follow the steps to avoid the errors

1. Login to your MySQL Command line tool,
2. Execute the command in the below format directly in the command line tool.
ALTER USER 'username'@'ip_address' IDENTIFIED WITH mysql_native_password BY 'password';
In my case It it 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

After that Use the Workbench now It will run.

No comments:

Post a Comment