Unzipped version of MYSQL installation and encountered errors and solutions

1 Installation

Download the corresponding unzipped version from the MYSQL official website and put it in the directory you want.
The decompressed contents are as follows:

Then we need to create a file called my.ini. Note that the file suffix must end with .ini. If the file suffix is ​​hidden, you can check it, as shown in the figure:

Create file: my.ini.

Its contents are as follows:

[client]
port=3306 default-character-set=utf8 [mysqld]
# Set to your own MYSQL installation directory basedir=D:\Program Files\mysql-5.7.24-winx64
# Set to MYSQL data directory datadir=D:\Program Files\mysql-5.7.24-winx64\data
port=3306
character_set_server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
# Enable query cache explicit_defaults_for_timestamp=true
skip-grant-tables

The mysql command will automatically create a data folder.

Run cmd with administrator privileges, enter the mysql bin directory, and run:

mysqld --initialize-insecure (recommended, do not set a root password)
mysqld --initialize (not recommended, generates a random root password)

If no error is reported:

mysqld -install
If there is a prompt:

This indicates that the installation was successful.

Then start the mysql server

If there is no error in net start mysql, it will prompt that the MySQL server has been started successfully. Log in to mysql -u root -p. No password is required for the first login. Just enter to access the MySQL command line.

Common errors encountered during the creation process are:

1 MySQL cannot start

 The MySQL service is starting. The MySQL service failed to start. The service did not report any errors.

The reason why this problem occurred to me was that the data folder was created manually. I needed to delete the data folder and then automatically create the data folder through the command mentioned above.

2 install/remove of the service denied

This error means that the service was refused to install/remove.
According to my understanding, since they refuse to install and we need to install it, it means that we do not have enough permissions and need to run cmd with administrator privileges.

For now, there are only two errors, and more will be added later.

Summarize

The above is the installation of the unzipped version of MYSQL and the errors and solutions encountered by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!