"MySQL" MySQL compression pack installation encountered a problem

The computer added a memory, installed a 64-bit system, and then re-installed a large wave of software, but to the MySQL, I die, because before is loaded with MSI, it is said that there is a kind of compressed file loading method, so I put an installation package, according to the online tutorial began to configure, after the following problem encountered:

Online to find out how to solve, some people say because the data file has a problem, I deleted my data file, and then input mysqld--initialize to initialize, sure enough automatically generated a data file package, and can start the MySQL service:

But not good, I can not log in, I recalled a bit, as if it is not set the password ah, so I went online to check the solution, online said, To add skip-grant-tables under the My.ini file, then you can login without a password, so I modified the My.ini file and then close the current MySQL service, input mysqld--skip-grant-tables, if not return any information, Description Success:

Then open a new cmd, switch to the bin directory, enter MySQL, you can do it:

And then it seems to be able to operate, but I still think there is a good password, after all, it is very troublesome to open two cmd every time, so I found a solution on the Internet, can be changed password: Four steps required:

>use MySQL

>updata Mysql.user Set Authentication_string=password (' 1234 ') where user= ' root ';

? >flush privileges;

>quit;

Then I delete the my.ini added in the sentence skip-grant-tables, re-open cmd, and then plan to start the MySQL service in the original way, and the first picture of the phenomenon .....

Then I repeat the above steps, delete the Data folder, found that because the file is occupied and can not be deleted, open the Explorer Discovery thread has Mysqld.exe ( This is why?). Later found that it seems to change the password process is turned on, but did not turn off ?), can be removed after switching off. Then MySQL--initialize, you can successfully open the MySQL service, but still cannot access, so then no password login, after the MySQL icon does not change the password, and directly enter the SQL operation database, Then you want to quit when you find that the MySQL service is not turned on ...

If this service is not turned on, then how did my previous operations on the database be implemented? Then I just entered MySQL again, found that can open MySQL, after the password modification operation,

I started a series of messy experiments:

Well, I guess, I used to be the kind of way to open the MySQL service is the root user, and now authorized no password login is an ODBC user, I want to ask is: my guess is right? If so, what is the user of the database? How does the MySQL service start?

"MySQL" MySQL compression pack installation encountered a problem