MySQL Green edition installation encountered problems

1.mysql failed to initialize:

Mysqld-initialize is a failure because it was previously installed, removed later, and is now reinstalled.

Workaround:

1) command line execution: mysqld--initialize--user=mysql--console

2) Execute the above command first to generate the library. Note that there is a temporary password to write down.

3) then start the service.

4) then the command line: mysql-uroot-p

5) Enter temporary password login

6) Modify Login password

2. Forgot login Password:

Unable to remember the temporary password, have been unable to login. (The last discovery is actually missing a symbol, Khan.) ）

Workaround:

1) in MySQL root directory, there is a my-default.ini, copy one, rename to My.ini

2) Open My.ini Edit, in [mysqld] next line, add: skip-grant-tables

Note: This is the beginning without password login, after changing the password, comment out.

3) Restart the MySQL server. (cmd:net stop MySQL, then, net start MySQL)

　　　　　　Note: The above steps can simplify the command, Cmd:mysqld_safe--skip-grant-tables

However, you must close MySQL before executing.

4) Cmd:mysql-uroot-p

5) Enter without entering the password directly

6) Cmd:set password for ' root ' @ ' localhost ' = password (' root '); (the last root is the password you want to change)

6.2) can also go into db modification, cmd:update mysql.user set authentication_string = password (' root ') where user = ' root ';

　　　　　　Note: It is important to note that there is no password field in the user table in the new MySQL database.

　　　　　　　　Instead, the encrypted user password is stored in the Authentication_string field

7) Refresh data: Cmd:flush privileges;

MySQL Green edition installation encountered problems