Solution to the problem that mysql cannot be installed: First uninstall MySQL; then delete the directory "C:\Documents and Settings\All Users\Application Data\MySQL"; and finally reinstall MySQL.
Mysql database cannot be installed! Mysql cannot be installed in the last step! mysql just can’t be installed! Isn’t it a headache and nerve-wracking? Don’t worry now. The editor has sorted out the reasons for mysql installation failure and the solutions to mysql installation failure. Take a look now!
Difficulty 1: MySQL 5.1 reported an apply security setting error during the installation process
1. Uninstall MySQL.
2. Delete the directory C:\Documents and Settings\All Users\Application Data\MySQL.
3. Reinstall MySQL and it will be OK.
Difficulty 2: MySQL prompt Could not start the service MySQL prompt
Install mysql 5.1.33 and run An error occurred in the third item Start Service in the Execute configuration step of the Server Instance Configuration wizard. The error message was Could not start the service MySQL
Analysis: This kind of The situation is usually caused by mysql being installed and not being uninstalled cleanly. After uninstalling, restart and then reinstall. Pay attention to the service. If it cannot be uninstalled, you can use mysqld-nt -remove to uninstall it.
The specific method is as follows:
1. Check whether there is mysql in the service, and if so, stop the service.
2. Run Add and Remove Programs in the control panel to uninstall mysql.
3. After uninstalling, open the registry (In Start---Run, enter regedit),
Check the key value under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, If there are related mysql key values (mysql, mysqladmin), delete them.
4. Restart and delete the remaining installation directory of mysql (check the service, there is no mysql in the service at this time).
5. Reinstall mysql. Do not run the Server Instance Configuration wizard after installation. Run the wizard in the start menu after restarting.
Difficulty 3: msyql installation to the last step start service error
1. Go to the control panel and install mysql first delete.
2. Go to the C:\Program Files directory on the c drive and delete the mysql directory.
3. If there are settings directories on other disks, delete them as well. Empty directories must also be deleted.
Tips: Use F3 loop to search for "mysql") 5. If the mysql content in the task manager is also deleted.
5. Turn off the firewall. 6. Reinstall mysql (I did not restart the computer here). If necessary during reinstallation, restart the computer, disable IIS, and delete the temporary files in temp. If that doesn't work, change the mysql service name to a different service name when configuring mysql. The above are the errors often encountered when installing mysql. I hope this article will be helpful to everyone's learning.
Mysql installation precautions and analysis of five reasons for installation failure
Error 1: On the last page of wizard installation, the error "cannot create Windows service for mysql.error:0" appears
Solution: Open the command line and enter the sc delete mysql command, which is C:>sc delete mysql [SC] DeleteService SUCCESS Restart the computer, or uninstall, restart and then install it. alright. I uninstalled and restarted.
One thing to note when uninstalling and reinstalling is that after uninstalling in the control panel, delete the Mysql folder in the c:\Documents and Settings\All Users\Application Data directory. It may contain the configuration information you uninstalled, which will affect the next installation.
Error 2: When asking the administrator to enter the 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 in the directory mentioned in Article 1 before installation. I don’t know if it will affect subsequent use, but it may be okay if you remember the password. By the way, the administrator password is set by myself, and the user name is root by default.
After successful installation, you can test as follows: open mysql command line client, enter the password, and Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3# appears. ## Server version: 5.1.33-community MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> The installation is successful!
Error 3: mysql server configuration failed. Check the error message in the configuration wizard and see 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 and you can 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 and cannot recognize the "OK" information returned by netsh.exe, and then runs the netsh.exe advfirewall command that can run on other windows platforms (this command does not It is supported, so an error that the command cannot be found is reported. There are two solutions: ①Set the language of your operating system to English, and then reinstall mysql. For details, you can enter the control panel-> Change the region and language; in addition, check whether the current user has the permission to start the firewall, check the properties of the Application Layer Gateway Service in the computer service, and check whether the user in the login tab is the current user. ② Check the firewall port , if it has been added successfully, it will not be processed. If it is not added successfully, you will manually add the port in the firewall.
Error 4: After the installation is successful, you can only connect to the mysql of localhost through the mysql 5.5 command line client. server, but cannot remotely connect to mysql server through workbench or other client tools. Keywords: cannot remotely connect to mysql server. Possible reasons: ① There is no open port, see the previous solution . ② The user is not authorized to connect remotely 3306. ③ Mysql server does not allow remote connections. For ② the user is not authorized to connect remotely, you can authorize the user, such as the default root user, you can use the mysql 5.5 command line Enter the following command in the client:
//选择数据库
mysql>use mysql;
//给用户授权，yourpassword字段用你的密码代替
mysql>grant all priileges on *.* to identified by 'yourpassword';
//刷新系统权限表
mysql>flush privileges;
//查看是否授权成功
mysql> show grants for roots;
Copy after login
If the authorization just appeared, it means success. If not, try adding 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 above is the detailed content of Why can't the downloaded mysql be installed?. For more information, please follow other related articles on the PHP Chinese website!
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
