WINDOWS10 under Installation MySQL8.0

1: First go to the official website to download the installation package

: https://dev.mysql.com/downloads/mysql/

This is my download version

2: Extract the extracted files to your installed directory: E:\mysql-8.0.11-winx64 (I put it in the E-packing directory, do not put in Chinese names and spaces in the directory.)

3: Create a new My.ini file and a data folder under the Mysql-8.0.11-winx64 folder

4: Configure the system environment

Add%mysql_home%\bin in Path

5: Open cmd window as administrator jump path to E:\mysql-8.0.11-winx64\bin

• Initialize command mysqld--initialize--user=mysql--console

  (Remember to initialize, a lot of people do not initialize, there are 1067 errors, how can not be confused)

  After initialization is complete, a temporary password will be generated here to remember the temporary password (in)

  Then save the directory in your database to generate some files, no tube

• Then the input mysqld-install to add the service

• Input net start MySQL start service

• Enter Mysql-u root-p to log in the database, when prompted to require a password, and then use your password above to log in

• Modify Password statement: ALTER USER [email protected] identified by ' 123456 '; Change Password to: 123456

WINDOWS10 under Installation MySQL8.0