MySQL database green version installation tutorial to solve system error 1067

What is the difference between the green version and the installation version of the software?

Generally, the installation version of the file will be written into the system registry, so there will be uninstall information of the file in the system.
For the green version, there will be no uninstall information in the system.

Plug-in installation: Some software has plug-ins in the installation version. The green version does not have any plug-ins.

The installation version has been installed and needs to be uninstalled;

Just delete the green version directly, no need to uninstall.

Is there any difference in functionality?

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: Enter the mysqld install mysql command in the decompressed directory to install the service. You can see the mysql service in the service.

4. Start the service net start mysql

5. Connect: 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 service mysqld remove

System error 1067 was encountered during testing

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

mysqlmysql;

Solution:

Option 1:

Solution 2: Delete the installation package and unzip it again

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.6 installation tutorials for various versions

MySQL 5.7 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.