Mysql installation considerations, five reasons for installation failure

Error 1: wizard install last page, can not create Windows
service for mysql.error:0 error

Workaround : Open the command line and type sc delete mysql command C:>sc delete mysql[SC] DeleteService SUCCESS restart computer
, or uninstall and then restart and install, so that's fine. I restarted after uninstalling.

Uninstall and reinstall to pay attention to a problem, after uninstalling in the control panel, go to the c:\\Documents and Settings\\All Users\\Application Data directory to delete the Mysql folder. There may be a description of the configuration information you uninstalled, which will have an impact on the next installation.

Error 2: There is a line of current password in addition to password and confirm password when the input administrator enters the password.

This means that you did not delete the Mysql folder in the directory that I mentioned in the first article before installation. I don't know if it affects subsequent use. It may be okay to remember the password. In addition, the administrator password is set by itself, and the username is the default root.

After the installation is successful, you can test it as follows: Open mysql command line client, enter the password, and then Welcome to the MySQL monitor. Commands end with ; or \\g.Your MySQL connection id is 3Server version: 5.1.33-community MySQL Community Server (GPL)Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the buffer.mysql>

Error 3: mysql server configuration failed.

View 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 The 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=ALLmysql-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=allowmysql-installer Information: 10 : Unexpected response from Netsh: The following command was not found: advfirewall firewall add rule name=”Port 3306<quo; protocol=TCP localport=3306 dir=in action=allow.

This situation shows that the mysql installation does not support the Chinese system well. It does not recognize the netsh.exe returned by netsh.exe, and then runs the netsh.exe advfirewall command that can run on other windows platforms. (The command xp does not support, so the report can not find the error of the command.

There are two solutions: 1 Set the language of your operating system
to English, then reinstall Mysql. Specific can be changed in the Control Panel -> area and language; in addition, check whether the current user has permission to start the firewall, view the properties of the Application Layer Gateway Service in the computer service, check whether the user in the login tab is It is the current user. 2 Check the firewall port. If it has been added successfully, it will not be processed. If it is not successfully added, manually add the port to the firewall.

Error 4: After the installation is successful, only through mysql 5.5 command line client Connect to the localhost mysql server, but not remotely connect to the mysql server through the workbench or other client tools. >

Keyword: Cannot connect mysql server remotely.

Possible cause: 1There is no open port, see the previous one. 2Users do not authorize remote connection. 3mysql server does not allow remote connection.

For 2 users without authorization for remote connection, you can authorize the user, for example, the default root user, you can enter the following command in the mysql 5.5 command line client: select database mysql> use mysql; //give the user authorization, yourpassword field Use your password instead of mysql>grant all priileges on *.* to identified by ‘yourpassword’;//refresh system permission table mysql>flush privileges;

//check whether authorization is successful mysql> show grants for Roots;

If the authorization just appears, it means success. If it is unsuccessful, try adding a new user yourself, add the user's command: insert into mysql.user(Host, User, Password, ssl_cipher, X509_issuer,x509_subject) values(“%”,”newuser”,password(“newpassword”),”,”,”)

Not allowed for 3mysql server Remote connectivity solution is to find their own my.ini, add a line statement in the [mysqld] under: bind-address = 0.0.0.0 means no binding IP, restart your Mysql service.

Error 5: Location of the configuration file my.ini

The MySQL Configuration Wizard places the my.ini file in the MySQL server installation directory. This will help to associate the profile with a specific server instance. To ensure that the MySQL server knows where to look for 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: You can use a text editor to open the file and make the necessary edits and modifications. You can also modify the server configuration with the MySQL Administrator application. 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. In order to configure the client and application, depending on your version of Windows, generate a new file my.ini file under C:\\Windows or in the C:\\WINNT directory

If your MySQL Configuration Wizard Found an existing my.ini file, you can reconfigure the existing server, or remove the server instance by deleting the my.ini file, stopping and removing the MySQL service. Reconfigure the existing server, select the “Reconfigure Instance” option and select the “Next” button. The existing my.ini file is renamed to 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 Instances option and select the & Nextquo;Next” button. If you selected the “Remove Instances option, go to the confirmation screen. Click the “Run” button: The MySQL Configuration Wizard stops and begins removing the MySQL service and deleting the my.ini file. However, the server installation directory has not been removed. If you selected the “Reconfigure Instance” option, go to the “Configuration Type” interface and choose to install the type of installation you want to configure.