In this video I have shown how we can overcome the below error on connecting MySQL work bench.
MySQL WorkBench Cannot Connect to Database Server- Your connection attempt failed for user 'root' from your hest to server at localhcst:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found. Please: 1 Check that mysql is running on server localhost 2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed) 3 Check the root has rights to connect to localhost from your address (mysql rights define what clients can connect to the server and from which machines) 4 Make sure you are both providing a password if needed and using the correct password for localhost connecting from the host address you're connecting from
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';
So as shown in the video as per my PC user name and password is,
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
Hope now you can login in MySQL WorkBench.