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

Editor to share with you how to install the downloaded mysql, I hope you will learn a lot after reading this article. Let's discuss it together.

The solution that mysql cannot install: first uninstall MySQL; and then delete the directory "C:\ Documents and Settings\ All Users\ Application Data\ MySQL"; finally, reinstall MySQL.

The mysql database cannot be installed! The last step of mysql cannot be installed! Mysql just can't be installed! Is not very headache, very nerve-racking, now we do not have to worry, the editor for you to sort out the causes of mysql installation failure and mysql installation failure solutions, take a look at it!

Difficult 1:MySQL 5.1 apply security setting error reported during installation

1. Uninstall MySQL.

two。 Delete the directory C:\ Documents and Settings\ All Users\ Application Data\ MySQL.

3. Reinstall MySQL and OK.

Difficulty 2:MySQL hint Could not start the service MySQL hint

When installing mysql 5.1.33, there was an error in the third Start Service entry in the Execute configurattion step when running Server Instance Configuration wizard, and the error message was Could not start the service MySQL

Analysis: this situation is generally due to the installation of mysql, unloaded is not clean, uninstalled and restarted after reinstallation. Note that if you fail to uninstall the service, you can uninstall it with mysqld-nt-remove.

The specific methods are as follows:

1. Check to see if there is any mysql in the service, and if so, stop the service.

two。 Run add and remove programs in the control panel to uninstall mysql.

3. Open the registry after uninstalling (at start-run, enter regedit)

Check the key values under HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Services, and delete them if there are relevant mysql key values (mysql, mysqladmin).

4. Restart and delete the remaining installation directory of mysql (check the service, there is no mysql in the service).

5. Reinstall mysql. Do not run Server Instance Configuration wizard after installation, restart and run the wizard in the start menu.

Difficult 3:msyql installation to the last step start service error

1. Delete the mysql in the control panel first.

two。 Go to the C:\ Program Files directory and delete the mysql directory.

3. If there are settings on other disks, delete them as well. The empty directory should also be deleted.

4. Go to regedit to change the registry:

HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL

HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/MySQL

If there is, delete it all! (tip: use the F3 loop to find "mysql") 5. If the mysql content in the task manager is also deleted.

5. Turn off the firewall.

6. Reinstall mysql (I didn't restart the computer here).

If necessary to reinstall, restart the computer, deactivate IIS, and delete temporary files in temp.

If it really doesn't work, change the name of the mysql service to another service when configuring mysql.

The above are the mistakes often encountered when installing MySQL. I hope this article will be helpful to your study.

Analysis of matters needing attention in Mysql installation and five reasons for installation failure

Error last page of 1:wizard installation, cannot create Windows service for mysql.error:0 error occurred

Solution: open the command line and enter the sc delete mysql command that is

C: > sc delete mysql

[SC] DeleteService SUCCESS

Restart your computer, or uninstall it and restart it before installing it. That's fine. I rebooted after uninstalling it.

One problem to pay attention to when uninstalling and reinstalling is to delete the Mysql folder in the c:\ Documents and Settings\ All Users\ Application Data directory after uninstalling it in the control panel. It may record the configuration information you uninstalled, which will be affected the next time you install it.

Error 2: when asking the entry administrator to enter a password, there is a line of current password in addition to password and confirm password.

This means that you did not delete the Mysql folder under the directory mentioned in my article 1 before installing it. I don't know if it will affect the follow-up use, but it doesn't matter if I remember the password. In addition, the administrator password is set by yourself, and the user name is the default root.

After the installation is successful, you can test as follows: open mysql command line client, enter the password, and appear

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 3

Server version: 5.1.33-community MySQL Community Server (GPL)

Type 'help;' or'\ h' for help. Type'\ c'to clear the buffer.

Mysql >

Then the installation is successful!

Error 3:mysql server configuration failed.

Check the error message in the configuration wizard with the following statement:

Mysql-server-5.5-win32:60-Adding firewall rule for MySQL55 on port 3306.

Mysql-server-5.5-win32:66-Adding firewall rule failed.

Indicates that the firewall installation failed.

Check the installation log to find the following statement:

Mysql-installer Information: 10: Attempting to create firewall rule with command: netsh.exe firewall add portopening protocol=TCP port=3306 profile=ALL name=MySQL55 mode=ENABLE scope=ALL

Mysql-installer Information: 10: Unexpected response from netsh: OK.

Mysql-installer Information: 10: Attempting to create firewall rule with command: netsh.exe advfirewall firewall add rule name= "Port 3306" protocol=TCP localport=3306 dir=in action=allow

Mysql-installer Information: 10: Unexpected response from netsh: the following command was not found: advfirewall firewall add rule name= "Port 3306" protocol=TCP localport=3306 dir=in action=allow.

This situation shows that the installation of mysql does not support the Chinese system well, does not recognize the "OK" information returned by netsh.exe, and then runs the netsh.exe advfirewall command that can be run on other windows platforms (the command xp does not support it, so the error of the command cannot be reported.

There are two solutions:

① sets the language of its operating system to English and then reinstalls mysql. Specifically, you can go to the Control Panel-> area and language to change it; in addition, check whether the current user has the permission to start the firewall, check the properties of Application Layer Gateway Service in the computer service, and check whether the user in the login tab is the current user.

② checks the firewall port. If it has been successfully added, it will not handle it. If it has not been added successfully, it will manually add the port in the firewall.

Error 4: after successful installation, you can only connect to localhost's mysql server through mysql 5.5command line client, not remotely connect to mysql server through workbench or other client tools.

Keyword: mysql server cannot be connected remotely.

Possible reasons:

① does not open a port, see the previous solution.

The ② user is not authorized to connect remotely 3306.

③ mysql server does not allow remote connections.

If the ② user is not authorized to connect remotely, you can authorize the user. For example, the default root user can enter the following command in mysql 5.5 command line client:

/ / Select database mysql > use mysql;// to authorize the user. In the yourpassword field, use your password instead of mysql > grant all priileges on *. * to identified by 'yourpassword';// to refresh the system permission table mysql > flush privileges;// to check whether the authorization is successful mysql > show grants for roots.

If the authorization just appeared, it is successful. If it is not successful, try to add a new user yourself and add the user's command:

Insert into mysql.user (Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values ("%", "newuser", password ("newpassword"),'')

The solution to disallowing remote connections for ③ mysql server is to find your own my.ini and add a line under [mysqld]:

Bind-address=0.0.0.0

Means to unbind IP and restart your Mysql service.

Error 5: location of configuration file my.ini

The MySQL configuration wizard places the my.ini file in the installation directory of the MySQL server. This will help to associate the configuration file with a specific server instance. To ensure that the MySQL server knows where to find the my.ini file, parameters similar to the following will be passed to the MySQL server as part of the service installation:-- defaults-file= "C:\ Program Files\ MySQL\ MySQL Server 5.5\ my.ini C:\ Program Files\ MySQL\ MySQL Server 5.5 can be replaced by the installation path to the MySQL server.

Edit my.ini text: you can use a text editor to open the file and make the necessary edits and modifications. You can also use the MySQL Administrator application to modify the server configuration. MySQL clients and applications, such as the mysql command line client and mysqldump, cannot determine the location of the my.ini file located in the server installation directory. To configure the client and application, create a new file my.ini file under C:\ Windows or C:\ WINNT directory, depending on your version of Windows

If your MySQL configuration wizard finds an existing my.ini file, you can reconfigure the existing server or remove the server instance by deleting the my.ini file and stopping and removing the MySQL service. Reconfigure an existing server, select the reconfigure instance option and select the next button. The existing my.ini file is renamed mytimestamp.ini.bak, and the timestamp is the date and time when the existing my.ini was created. Remove the existing database instance, select the remove instance option and select the next button. If the "remove instance" option is selected, go to the confirmation interface. Click the run button: the MySQL configuration wizard stops and starts removing MySQL services and deletes the my.ini file. However, the server installation directory has not been removed. If you select the reconfigure instance option and go to the configuration Type interface, you can select the type of installation you want to configure.

After reading this article, I believe you have a certain understanding of the download mysql can not install how to solve, want to know more related knowledge, welcome to follow the industry information channel, thank you for reading!

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.