Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to understand the errors encountered in the installation of lithographic MYSQL, it has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

1 installation

Download the extracted version from the MYSQL website and put it in the directory you want.

The contents of the decompression 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 a file: my.ini.

Its contents are as follows:

[client] port=3306 default-character-set=utf8 [mysqld] # set to the installation directory of your MYSQL basedir=D:\ Program Files\ mysql-5.7.24-winx64# to the data directory of MYSQL datadir=D:\ Program Files\ mysql-5.7.24-winx64\ dataport=3306character_set_server=utf8sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER# enable query cache explicit_defaults_for_timestamp=trueskip-grant-tables

The data folder is automatically created with the command mysql.

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

Mysqld-- initialize-insecure (recommended, do not set root password)

Mysqld-- initialize (not recommended, generate a random root password)

If there is no error:

Mysqld-install

If there is a hint:

It indicates that the installation was successful.

Then start the mysql server

If there is no error in net start mysql, it will prompt the mysql server to start successfully. Log in to mysqlmysql-u root-p for the first time without a password, and you can directly enter the MySQL command line.

Common errors encountered in the creation process are:

1 the problem that MySQL cannot start

The MySQL service is starting. The MySQL service could not be started. The service did not report any errors.

The reason for this problem here is that the data folder has been created manually, and after the data folder needs to be deleted, the data folder will be created automatically through the above command.

2 install/remove of the service denied

This error means that the service is refused to install / remove.

According to the understanding, since someone refuses to install, and we need to install, it shows that we do not have enough permissions to run cmd with administrator privileges.

There are only two mistakes for the time being, and some of them will be added later.

Thank you for reading this article carefully. I hope the article "what to do if you encounter errors in the installation of the decompressed version of MYSQL" shared by the editor will be helpful to you. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.