How to install the green version of Mysql database and solve the 1067 error graphic tutorial

This article mainly introduces the MySql database green version installation tutorial and the solution to system error 1067 in detail. It has certain reference value. Interested friends can refer to

Software Green What is the difference between the installed version and the installed version?

Generally, the installation version of the file will be written to the system registry, so there will be uninstallation information for the file in the system.
The green version will not have uninstall information in the system.

Installation of plug-ins: Some software in the installation version has plug-ins. The green version does not contain any plug-ins.

The installation version has to be uninstalled;

Just delete the green version without uninstalling it.

Are there any differences in functions?

This is the difference in the plug-in functions just mentioned.

Installation steps

1. Unzip the mysql file package

2. Modify the my-default.ini file

3. Install the service: From the command line, go to the decompression directory and enter the mysqld install mysql command to install the service. You can see the mysql service in the service

4. Start the service net start mysql

5. Connection: mysql – uroot (no password required)

mysql –uroot –p (initial password is empty) change password

a) show databases;
b) use mysql;
c) update user set password=password(”123456”) where user=”root”;
d) flush privileges;
e) quit

6. Stop the service net stop mysql

7. Remove the service mysqld remove

System error 1067 was encountered during the test

Cause of the problem:A service has been started before, and starting the service again causes a system error

                                                                                                           

Solution:

Option One:

Option 2: Delete the installation package and re-unzip it

The above is the detailed content of How to install the green version of Mysql database and solve the 1067 error graphic tutorial. For more information, please follow other related articles on the PHP Chinese website!