MySQL installation problems are summarized below in order to later re-installation may be a reference to similar problems.
Installation into the installation steps in the last two error dialog box will pop up the following:
The above error occurs because the password is wrong, if the password is entered correctly the problem does not occur, and if this step below enter the correct password, you can install correctly.
But when I installed the password is obviously a 123, but now when the input 123 is not installed, how is it?
To solve the problem we must enter the correct password, but how if you do not know the password or the password is not correct, then how to do it?
Then remove the registry, reinstall, but no.
(Reinstall - uninstall - clean up the registry) after the implementation of several not install correctly, so only checked on the net.
About Installing MySQL Server Instance Config Wizard error when, on-line, many say, are as follows:
The first argument:
Because before you had installed mysql, uninstall Shihai retains some configuration files.
Click Retry (retry) to see if you can. Otherwise, click Skip (skip) and then click cancel to exit, and then click on the Start menu MySQL Server Instance Config Wizard to reconfigure mysql.
In Figure 2, there are three places to enter a password, that you have installed mysql, you are in the first text box to enter the original root password, followed by two text box to enter root's new password on it.
If this does not then reload a MySQL.
Heavy Note: All the best to delete the original files, if necessary, can be clear about the registry.
"The original root password?" I entered, but no.
Then I clean up the registry uninstall, reinstall MySQL, but does not work. Why? I then check the Internet.
The second argument:
"Step one: Open the" Start "to run the program in the MYSQL MySQL Command Line Client to enter your password [that is set during installation]
Step Two: mysql> enter: UPDATE mysql.user SET Password = OLD_PASSWORD ('password')
The third step: at the prompt -> enter: WHERE Host = 'localhost' AND User = 'user name';
Enter after the prompt: Query OK, 0 rows affected (0.16 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Do not think that over, there are ~
The fourth step: mysql> enter: FLUSH PRIVILEGES
Enter after the prompt: Query OK, 0 rows affected (0.19 sec)
Start the mysql service, log on to mysql database
Enter the command is:
[Root @ localhost root] # / usr / bin / mysql-u root-p *
(Based on lniux version compatibility issues,-p input after the contents will vary)
-P: root password for the database administrator (typically enter the password)
-P: Specifies the database name to be used then, Enter password: Enter the database password here (redhat 9.0 version)
In the redhat 9.0 version, if the root directly into the database administrator's password, an error will occur 1045.
Methods provided for the A1, in the sense of trouble with the process, so stop the validation.
In fact, or a word, version compatibility issues. 9.0 use and service mysqld start myisamchk can know.
These are two days to play little bit of problems encountered in MySQL
99% online this argument, really do not understand, 163 blog, javaeye, csdn, there are many other technical websites are the articles, with no innovation, just copy to their own blog or website, not to be a real operating instructions, boring.
The above question is: when I installed the password is 123 fill, but can not enter into, the problem of how to enter without a password MySQL Command Line Client, as shown in Figure:
See, first of all is to enter a password, how can this way, no password and can not enter the MySQL client console, so the second method does not work.
These two do not solve my problem, saw nothing but their own, and I remember saying: "There is always a successful way," I think I have to fix it.
Some say that the initial password is 123456, how possible. I tested one by one, finally, I do not enter any password, enter directly in the Figure 2 New root Password and Comfirm, completed the implementation of the correct result.
If the installation several times unsuccessful, it could be passwords, your password is test previously used several times, and if not, would not enter the Current root Password password, the password directly into the following two items can be.