Mysql Installation notes installation failure of the five reasons analysis

Error 1: wizard Installation last page, cannot create Windows service mysql mysql.error:0 error

Solution: open the command line and type the sc delete mysql command
C: > sc delete mysql
[SC] DeleteService SUCCESS
Just restart your computer, or uninstall and restart before installing, and you'll be fine. I rebooted after uninstalling.

After uninstalling in the control panel, go to c:\Documents and Settings\All Users\Application Data and delete the Mysql folder. It may contain the configuration information you uninstalled, which will be affected the next time you install it.

Error 2: There is 1 line current password in addition to password and confirm password when asking the administrator to enter the password.

This means that you did not delete the Mysql folder from the directory mentioned in my article 1 before installation. I do not know whether it will affect the subsequent use, it may not matter if I remember the password. The administrator password is set by yourself, and the user name is the default root.

After successful installation, you can test as follows: open mysql command line client, enter the password, it appears
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 fails.

View the error message in the configuration wizard as follows:
mysql-server-5.5-win32:60 - Adding firewall rule for MySQL55 on port 3306.
mysql-server-5.5-win32:66 - Adding firewall rule failed.
Firewall installation failed.

Check the installation log to find the following statements:
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: Yes.
mysql-installer Information: 10 : Attempting to create firewall rule with command: netsh advfirewall firewall rule name= "Port 3306" protocol=TCP =3306 dir=in =allow
mysql Information: 10: Unexpected response ES1123en = "Port 3306" protocol= "Port 3306" localport=3306 in action=allow.

This situation indicates that the mysql installation does not support The Chinese system well. It cannot recognize the "OK" information returned by ES135en.exe and then run the ES138en.exe advfirewall command which can run on other windows platforms. (This command xp is not supported, so the error of this command cannot be found.

There are two solutions:
Set your own operating system language to English, and then reinstall mysql. The details can be entered into the control panel - > Change in area and language; Also, check that the current user has permission to start the firewall, view the properties of Application Layer Gateway Service in computer Services, and see if the user in the login TAB is the current user.
(2) check the firewall port, if it has been added successfully, do not deal with, if it has not been added successfully, then manually add the port in the firewall.

Error 4: After successful installation, you can only connect to mysql server of localhost via mysql 5.5 command line client, but not remotely via workbench or other client tools.

Key words: Cannot connect to mysql server remotely.

Possible reasons:
There is no opening, see the first item to solve.
The user is not authorized to connect to 3306 remotely.
mysql server does not allow remote connections.

For the user does not authorize the remote connection, the user can be authorized. 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, the yourpassword field is replaced by your password
mysql > grant all priileges on *.* to identified by 'yourpassword';
// Refresh the system permission table
mysql > flush privileges;

// Check to see if authorization was successful
mysql > show grants for roots;

If the right authorization appears, it is a success. If you don't succeed, try adding a new user by yourself. 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 mysql server which does not allow remote connections is to find your own ES212en.ini and add 1 line under [mysqld] :
bind-address=0.0.0.0
Means to unbind IP and restart your Mysql service.


Error 5: Location of configuration file ES223en.ini

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

Edit ES254en. ini text: You can use a text editor to open the file and make the necessary edits and changes. You can also modify the server configuration with the MySQL Administrator application. The MySQL client and application, such as the mysql command line client and mysqldump, do not determine the location of the ES261en.ini file in the server installation directory. To configure the client and application, generate the new my.ini file under C:\Windows or under the C:\WINNT directory, depending on your VERSION of Windows

If your MySQL configuration wizard finds an existing ES273en.ini file, you can reconfigure the existing server or remove the server instance by deleting the ES275en.ini file, stopping and removing the MySQL service. To reconfigure an existing server, select the Reconfigure Instance option and select the Next Step button. The existing ES278en.ini file has been renamed to ES280en.ini.bak and the timestamp is the date and time when the existing ES283en.ini was created. To remove an existing database instance, select the Remove Instance option and select the Next Step button. If you select the "Remove Instance" option, go to the confirmation screen. Click the Run button: The MySQL configuration wizard stops and starts removing the MySQL service and deleting the ES287en.ini file. But the server installation directory was not removed. If you select the Reconfigure Instance option, go to the Configuration Types screen and select the type of installation you want to configure.