Description of the phenomenon
today with Heidisql login virtual machine MySQL, landing does not go up. Wait about a two-minute error prompt: As SQL Error (2013): Lost connection to MySQL server at 'waiting for initial communication packet', system error: 0
shown in the following illustration:
Beginning to think that remote TCP/IP root can only be accessed through the localhost, then the new user, after the% or no results. The problem disappears after attempting to modify the My.ini configuration problem.
Solutions
in My.ini or MY.CNF.
[MYSQLD] Item, add
In the process of resolving this problem, another startup parameter was found:
MySQL Startup parameters:
As the name suggests, is to start MySQL does not start grant-tables, authorization table. What's the use? Of course, it is useful to forget the administrator password and the user table in the MySQL database is wrong. With this parameter, any account with any password (including, of course, empty) can log in to the MySQL database.