MySQL Connectivity report 2003-10061 and 1045 errors

　　　　　　MySQL connection does not escalate the exception, tuned for several hours, share

2003-10061 Error This situation is not started, I was re-installed after the system appears, I install the MySQL under no My.ini configuration

Windows also does not have, service management above is no more, can only manually to create to start;

1045 Error add a line under new My.ini,[mysqld] by modifying the password skip_grant_tables

Make it log on when you skip permission check mysql-u root-p password randomly switch to database use MySQL

Modify password update user set Password=password (' Password ') where user= ' root ';

Then refresh the permissions flush privileges finally turn off exit;

Copy the following to the newly created My.ini and start the net start MySQL to start successfully.

　　[Mysqld]

Basedir=c:/program Files (x86)/mysql/mysql Server 5.5 MySQL installation path
Datadir=c:/programdata/mysql/mysql Server 5.5/data MySQL Data installation path, this ProgramData file is hidden under C drive
Character_set_server=utf8 Server-side encoding
Collation-server=utf8_general_ci server-side characters
Port = 3306 Port Number Set default 3306

The error can be found under the suffix name under the C:\ProgramData\MySQL\MySQL Server 5.5\data directory. Err Diary

The problem above is because the version reason default-character-set to Character_set_server

Default-collation tune into Collation-server above the exception, because I did not change before the error.

MySQL Connectivity report 2003-10061 and 1045 errors