Failed to connect to mysql at 127.0.0.1:3306 with user root
Hello!
i have a problem with connecting to mySQL Server. I have already uninstalled the server and the workbench. During the reinstallation i can't specify the configuration regarding mySQL Server (Type and Networking, Authentification method, Accounts and Roles, Windows Service, Plugins and extensions, Aplly configurations). These fields do not appear and the installation will automatically proceed. And after lunching the workbench the same problem appear (Failed to connect to mysql at 127.0.0.1:3306 with user root). I also can't see the default established connection that normally was before (Local instance MySQL57). I have now no connection to the server available.
would please help in solving this problem!
Thank you!
1 answers ( 0 marked as helpful)
Hi Zakaria!
Thanks for reaching out.
Installing Workbench and the SQL Server is to a very great extent a case-specific issue.
Thank you very much for the detailed information. To me, it points out that there may have been a problem when uninstalling the software, i.e. you may have not managed to completely remove it from your device. This poses problems for future installations and particularly when trying to use a different password.
I know this entire process is hard to be solved for just a few minutes but I am sure that after only exchanging a few lines of code the problems can be solved.
The quickest solution is supposed to be completely removing the software from your computer by considering all of the following four steps:
To remove MySQL Workbench and Server from your Windows computer, you need to go through the following 4 steps (with no exception). Make sure you complete all of them to finish the operation successfully:
1) Uninstall MySQL from Control Panel/Programs and Features
2) Uninstall MySQL from the start menu/Firewall/Allow an App through Windows Firewall (if found there)
3) Remove all files from drive C:/ProgramData/MySQL (if this folder is hidden on your computer, you could search for %programdata% in the start menu)
4) Remove all files from the Windows registry. To complete this step, you need to search for regedit in the start menu. Then, remove all files from the MySQL folder in the regedit editor.
You must complete all steps from 1) to 4) before you can restart your computer and retry installing the MySQL Workbench and Server again. After you've completed these steps, restart your computer, and then retry installing MySQL in the way we have suggested in the course. Hope this helps but please feel free to get back to us should you need further assistance. Thank you.
Best,
Martin
1) Uninstall MySQL from Control Panel/Programs and Features
2) Uninstall MySQL from the start menu/Firewall/Allow an App through Windows Firewall (if found there)
3) Remove all files from drive C:/ProgramData/MySQL (if this folder is hidden on your computer, you could search for %programdata% in the start menu)
4) Remove all files from the Windows registry. To complete this step, you need to search for regedit in the start menu. Then, remove all files from the MySQL folder in the regedit editor.
You must complete all steps from 1) to 4) before you can restart your computer and retry installing the MySQL Workbench and Server again. After you've completed these steps, restart your computer, and then retry installing MySQL in the way we have suggested in the course. Hope this helps but please feel free to get back to us should you need further assistance. Thank you.
Best,
Martin