MySQL Workbench will not connect to localhost. "Database server instance unknown"

Question

My MySQL Workbench doesn’t connect to the local host, and I can’t understand why exactly it reacts like this. He just started doing it one day, and randomly he will give me access, although he says that he is still “unknown”, but I'm tired of it and would like to fix it.

Since this site requires me to have a "10" reputation for posting images, I will have to describe it.

On the "Start / End" tab on the administration page it says:

Database server instance unknown. - The Start Server button has disappeared, so I can’t click it.

Start-up message log 2013-07-11 08:57:51 - Workbench will use cmd shell commands to start / stop this instance

2013-07-11 08:57:51 - Checking the status of the MySQL service returned an error: not found

2013-07-11 08:57:51 - Checking the status of the MySQL service returned an error: not found

2013-07-11 09:00:55 - Checking the status of the MySQL service returned an error: not found

2013-07-11 09:00:55 - Checking the status of the MySQL service returned an error: not found

2013-07-11 09:02:01 - Checking the status of the MySQL service returned an error: not found

Then on the server status tab on the administration page it says:

Name: mysqld @localhost host: localhost Server: unknown status: unknown

Connection There is no connection to the MySQL server. This function requires an established connection with a running MySQL server.

If someone can help, it will be great!

thanks

Answer 1

I had this problem on my windows 8.1 machine and it turned out to be a file permissions problem.

To restore it, I went to the "C: \ Program Files \ MySQL \ MySQL Server 5.6" folder and right-click on the "data" folder and the selected properties. By clicking on the security tab, click the "Edit" button. From there, press the ADD button, then the ADVANCED button, and finally the FIND NOW button. In my I added users, administrators and "ALL APPLICATION PACKAGES". I gave full control to users who have already been specified for the data folder, as well as users, administrators, and ALL PACKAGES FOR USE.

After the permissions were fixed, I opened the command line as an administrator and was changed to the directory "C: \ Program Files \ MySQL \ MySQL Server 5.6 \ bin" cd "C:\Program Files\MySQL\MySQL Server 5.6\bin" . From there, you can run mysqld --install , which installs the MySQL service.

More information on installing mysql service for Windows can be found at http://dev.mysql.com/doc/refman/5.0/en/windows-start-service.html

[edit] Note that if you are using a different version of MySQL than the path to the MySQL data directory, the bin directory may be different on your Windows machine.

Answer 2

The error message says: a service named MySQL could not be found. Maybe your MySQL service has a different name? Do you have a service at all? Starting mysql manually from the bin folder is simple: manual. There is no service involved, so WB cannot manipulate the launch state.

When you install MySQL with the MySQL installer, you have everything in place for a couple of minutes and it works from the very beginning.

So, first check to see if you have a service running on your MySQL server and stop it from starting manually. If the service will enter its name and enter it in the Windows service name field of the configuration manager:

Please note that MySQL Workbench can only manage your server if it is installed as a Windows service.

Answer 3

I had this problem on my Windows 8.1 and I decided that I updated my workbench to version 6 using "mysql-installer-web-community-5.6.16.0.msi" from the mysql official page

Answer 4

I found reinstalling all MySQL products a better alternative, because some of the solutions on the Internet will make another instance of your mysql server along with mysql56, which can ruin for beginners.

Remember to save the database files and restore the configuration during reinstallation.