sqlalchemy - MySQL 1042, "Can't get hostname for your address"

Answer 1

解决办法

After two days of tossing around, modifying configuration files, uninstalling and reinstalling, I finally switched to Ubuntu and couldn’t bear the slowness and lag of the virtual machine. Finally:

Complete uninstall

• 命令行还能用的话，备份数据库
• Control panel related to uninstalling MySQL, delete installation-related folders, similar to C:Program FilesMySQL, C:ProgramDataMySQL (ProgramData is a hidden folder), C:UsersSkyAppDataRoamingMySQL or Oracle

• Delete registry-related directories
  HKEY_LOCAL_MACHINESYSTEMControlSet001ServicesEventlogApplicationMySQ
  HKEY_LOCAL_MACHINESYSTEMControlSet002ServicesEventlogApplicationMySQL
  HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesEventlogApplicationMySQL (if you are not worried, you can also search and delete related ones)

• In short, all relevant ones have been deleted and restarted

InstallationMySQL5.5

Yes, MySQL5.5.10, the installation is complete and the MySQL-Front link is successful. I have wanted to install newer versions (5.6.22, 5.6.24, 5.7.7, etc.) countless times before, and I have completely uninstalled and reinstalled countless times, but I still get the same error and have the urge to smash the computer.

Answer 2

This is a magical problem. Change the login identity of the MySQL service to the local system account. It works in personal testing

Answer 3

Could it be that SQLAlchemy is written incorrectly? Can you please post your SQLAlchemy connection code?

Answer 4

But the above error is prompted in CMD

Write 127.0.0.1 as localhost and try it and see what happens

Answer 5

@RACION Very good, it works