MySQL Workbench Connection
Hello, I am following the SQL course, setting up your connection lesson and I can not get passed this error. I've tried a few things found online and in comments here (including refiguring the server, removing and reinstalling the server and deleting/re-creating a new connection).For reference it will not even allow me to enter my password. It just goes straight to this window.
3 answers ( 0 marked as helpful)
Hi Lae!
Thanks for reaching out.
You have to start the server again. You can do that from the Windows services where you will find the MySQL entry (something like MySQL80). You need to start the service and try connecting to it again in the Workbench.
Hope this helps.
Best,
Tsvetelin
Thanks for reaching out.
You have to start the server again. You can do that from the Windows services where you will find the MySQL entry (something like MySQL80). You need to start the service and try connecting to it again in the Workbench.
Hope this helps.
Best,
Tsvetelin
Hi Tsvetelin,
Unfortunately that didn't work for me and I am still getting the same error. Any other ideas? I've tried various things I found online and nothing has worked :/
Hi Lae!
Thanks for reaching out.
If restarting the MySQL service didn’t work, try changing the authentication plugin. This error often occurs if MySQL Workbench is set to use mysql_native_password, but it’s not properly configured.
Here’s what to do:
1. Open the MySQL command line (or any SQL client).
2. Log in as root (or another user with privileges):
mysql -u root -p
3. Run this command to update the root user's plugin:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';
Replace 'your_password' with your actual password.
This should reconfigure the authentication and may resolve the issue.
Hope this helps.
Best,
Tsvetelin
Thanks for reaching out.
If restarting the MySQL service didn’t work, try changing the authentication plugin. This error often occurs if MySQL Workbench is set to use mysql_native_password, but it’s not properly configured.
Here’s what to do:
1. Open the MySQL command line (or any SQL client).
2. Log in as root (or another user with privileges):
mysql -u root -p
3. Run this command to update the root user's plugin:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';
Replace 'your_password' with your actual password.
4. Then, flush privileges:
FLUSH PRIVILEGES;
5. Exit and try connecting again in MySQL Workbench. This should reconfigure the authentication and may resolve the issue.
Hope this helps.
Best,
Tsvetelin