'I get this message in MYSQL in Windows: Target host is configured as Windows, but seems to be a different OS. Please review the connection settings

I'm trying to set a MySQL Database in my pc for development.

error Message

Of course I've tried to change the OS

OS configuration

None of this options made it work.

Although when I hit the testconnection button it shows success, the OS message error keeps being shown and I cannot use my database.

Connection Success

Any help will be appreciated. Thanks in advance!



Solution 1:[1]

It's a bug in MySQL Workbench 8.0.28 Using MySQL Installer, you can uninstall the workbench then install the MySQL Workbench 8.0.16. It will work well.

Solution 2:[2]

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 Changao Liu
Solution 2 Fernando Valderrama Guayán