windows install mysql

One 、 Download the installation package on the official website

MySQL :: Download MySQL Community Server

Two 、 Unzip the file

Extract to disk , Go to the decompressed bin Under the table of contents

1. Initialize database command

mysqld --initialize --console

Record temporary password

[email protected]: B9wwfV16w/d>

2. Enter the directory as administrator

3、 ... and 、 take mysql Installed as windows service

./mysqld -install

Four 、 start-up mysql service

net start mysql

5、 ... and 、 Log in to the database and change the password

mysql -u root -p

If an error is reported here, it is not recognized mysql You need to add the path to the environment variable path And reopen the terminal .

Change Password

alter user 'root'@'localhost' identified by '111111';
commit;