Shulou(Shulou.com)06/01 Report--

Let me tell you a little bit about how to deal with the failure to start when you install the mysql service. Have you known about similar topics before? If you are interested, let's take a look at this article. I believe it will be of some help to you after reading how to deal with the failure to start up the mysql service.

MySQL is a very powerful relational database. However, some beginners encounter all kinds of difficulties when installing the configuration, so let's not talk about the installation process here, but talk about the configuration process. When downloading mysql on the official website, there are msi format and zip format. Msi can run the installation directly, and zip can extract it to the directory address you like. When installing both, configuration is required to use them. The following description is mainly the default address in msi format: C:\ Program Files\ mysql-5.7.18-win32.

One. After installation or decompression, you need to configure environment variables. The process is as follows: my computer-> Properties-> Advanced system Settings-> Advanced-> Environment variables. Click path in the system variable and select Edit. Append "C:\ ProgramFiles\ mysql-5.7.18-win32\ bin;". What needs to be meant here is, not coverage! And it's best to add it at the front. The English semicolon ";" cannot be omitted. (it can also be inserted in the middle, but be sure to add it after ";". )

Click the start menu, search for cmd.exe, and left-click to run as an administrator. Be sure to run as an administrator!

If you run cmd directly, there will be an error due to insufficient permissions when typing mysqld-install: Install/Remove of theService Denied!

When you enter mysqld-install correctly and press enter, The service already exists will be displayed!

3. Then enter net start mysql to start the CVM, and if it shows that it failed to start the CVM, as shown below.

This is because there is no data folder in C:\ Program Files\ mysql-5.7+ directory above version 5.7. here, remember not to copy the data folder of other versions of mysql, but type mysqld--initialize-insecure-- user=mysql in the window, note that there is a space before "-" and then enter. (it takes half a minute to wait to see how fast the computer is)

(in the C:\ ProgramFiles\ mysql-5.7.18-win32 directory, there is no data folder. The following figure)

Note: in version 5.7 below, you need to modify the my-default.ini in the C:\ ProgramFiles\ mysql-5.* directory, right-click to edit it, and set the

Basedir=...

Datadir=... ..

Modify to

Basedir= C:\ Program Files\ mysql-5.*

Datadir= C:\ Program Files\ mysql-5.*\ data

OK, where "C:\ Program Files\ mysql-5.*" is determined by the actual installation location

IV. In the C:\ ProgramFiles\ mysql-5.7.18-win32 directory, show that the data folder was created successfully.

After you have created the data, type mysqld-install, and then press enter (if it is successful at step 3, you do not have to type it again)

five。 After the service starts successfully, you can log in. Enter mysql-u root-p and press enter, and Enter password appears. Because no login password is set, you don't need to enter anything, just press enter.

After entering directly, as shown in the following figure, the mysql configuration has been successful!

What do you think of how to deal with the failure to install the mysql service? what do you think of this article? has it gained anything? If you want to know more about it, you can continue to follow our industry information section.

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.