Installation and error of MySQL service under Windows

MySQL Add service: Mysqld-install MySQL

MySQL removal service: mysqld-remove MySQL

MySQL Startup service: net start MySQL

MySQL Stop service: net stop MySQL

Problem 1:mysql installation was successful, but failed to start, the server did not error

Workaround: Mysqld--initialize initialize the data directory

Problem 2:mysql started successfully and the client is not logged on as root

Cause: During MySQL installation, the root user's random password is generated and the password is stored in the User-*.err file in the data directory.

Workaround: Locate the root user's random password in the User-*.err file in the data directory to login to Mysql,set password=password (' New password ');

Installation and error of MySQL service under Windows