MySQL service in the native, need single-machine debug MySQL database occurs do not know hostname ' localhost '

Install MySQL server on this machine today and then open it with Workbench to connect to the native database

Hostname:localhost

port:3306

Eject: localhost cannot connect error-1042

Try a lot of methods, finally seemingly use the following way to solve, first record first, the other first not scrutiny:

1. Open a command prompt in Administrator mode

2. Enter the following code to restart

netsh winsock reset

3. Restart the computer ...

4. Open Mysql Workbench Connection to the localhost database again

If the login occurs with a compatibility_56 error, execute the following statement:

Set global show_compatibility_56=on;

This is typically the case in versions 5.7 and above

MySQL service in the native, need single-machine debug MySQL database occurs do not know hostname ' localhost '