'MySQL Workbench host mismatch

I already installed MySql Workbench 6.3 in my laptop with an operating system of windows 10, but when I created a connection and open it there is an error which is

Could not acquire management access for administration ''RuntimeError: Target host is configured as windows, but seems to be a different OS. Please review the connection settings.

Whenever I click the Server Status under the MANAGEMENT tab that error is pop up and after that there is a next error which is

Unhandled exception: Current profile has no WMI enabled.

mysqlmysql-workbench


Solution 1:[1]

Change the configuration, edit the mySQL connections: configuration-> system type. I use linux(THERE ARE OTHER O.S). enter image description here

Solution 2:[2]

I was having the same issue but it was not related to any configuration, the MySQL service was not running at all.

For anyone which this problem go to services and search for MySQL and start the MySQL service manually and configured for start on boot so you won't have to repeat these steps later.

enter image description here

Solution 3:[3]

I solved this same problem by installing MySQL Server and MySQL Workbench 8.0.22

Solution 4:[4]

I got this message using MySql 8.0.27 (both server and Workbench) on Windows machine and solved this way:

  • Control Panel >
  • Region >
  • Administrative Tab >
  • Change regional system configuration
  • Checked "Beta version: Use UTF-8 Unicode for world compatibility.."
  • Restart

Credits: third option explained here: https://www.youtube.com/watch?v=fD9JG_lfnzs

Solution 5:[5]

Go to the search bar on your Windows and search for Services. Launch Services and look for MySQLxx (xx depends on your MySQL version) in the long list of services. Right-click on MySQLxx and hit Start. MySQL should work fine now.

Solution 6:[6]

Open MySQL Workbench click on “Manage Server Instances” under “Server Administration” column close the screen again. Now click on the instance again, the issue should be fixed. Another post makes this recommendation:

Open MySQL Workbench Click Manage Server Instances Select System Profile tab Check box(es) to acquire Admin privileges Try one or both of these and see if it helps.

Solution 7:[7]

You have to go to the control panel, then region, then clic in the administrative tab and click on "change system regional settings" and as a final step check the box: Beta: Use Unicode UTF-8 for worldwide language support, restart your PC and try to access MySQL Workbench.

Check this box

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 BlaShadow
Solution 3 Machavity
Solution 4 JMart
Solution 5 juan damian osornio gutierrez
Solution 6 Jonas Aeschlimann
Solution 7 Fernando Valderrama Guayán

Related Questions