1. The MySQL service startup error occurred.
MySQL ' localhost ' (10061)
The problems I have encountered here are resolved as follows:
In the My.ini file
#Path to installation directory. All paths is usually resolved relative to this.
Basedir= "D:/TOOLS/MYSQL5.5/"
#Path to the database root
Datadir= "d:/tools/mysql5.5/data/"
The datadir needs to be on the next level of the Basedir directory, as shown above.
At this point, the MySQL service can start up.
Then there is another problem: Access denied for user ' root ' @ ' localhost ' (using Password:yes) ERROR 1045 (28000)
To reset the root user's login password, proceed as follows:
1. First add "Skip-grant-tables" at the end of the My.ini file
2. Restart MySQL Service
3. You can log in to MySQL server via Mysql-u root-p at this time
4, change the password, the steps are as follows:
A. Enter the following statement:
Use MySQL; Update User Set = PASSWORD (' new password 'whereuser='root ' ';
B. Delete or comment out the "skip-grant-tables" of My.ini
C. Restart MySQL Service
Problems with MySQL Installation