This process is installed in 2017 year 08 month 07 Japan 10:46:30. edition ：5.7.19.
Download from the official website
Use MySQL Two things are needed , One MySQL Server The server , One more MySQL Workbench( Graphical management tools )
windows The installation package here is Server+workbench All have
MySQL Server + Workbench：mysql-installer-community-22.214.171.124.msi
After you click in , You'll see two big buttons , Sign in and sign up . If you don't want to do these tedious moves , Don't worry. , Look at the text in the red circle below , Click to download directly .
After installation, a window will pop up , The above is a root The default password of the account should be noted down . The general meaning is ：
2017-08-07t02:15: 23.908963Z 1 [ notes ] The temporary password is root@localhost：ENd)fo--D8hP
If you lose the password , see also MySQL Refer to the manual on how to reset root The code section .
Starting mode 1 -- Enter system preferences , The bottom line , find mysql open , Click on "Start MySQL Server", start-up mysql
Starting mode 2 -- Command line run
Find... In the application iTerm open , First run the following two commands ：( These two commands are for easy direct opening iTerm Can run mysql command , Instead of having to enter mysql Install directory to run )
Next , All you have to do is reset the password
mysqladmin -u root -p password newpass newpass It's your new password
After running the reset password command , The system prompts for the old password . Installed mysql5.6 Or previous versions of the students know ,mysql The first run will give root The user assigns a default password ：root, The old code is root. But now if you type in root, System prompt password error , What's going on ？
original 5.7 The version of will not be given to root User assigned default password , It's a temporary password The default password is the temporary password saved above . If you're careful , install mysql After success, a temporary password will pop up for you to save . If you don't save , No problem , There will be... In the notice bar on the right , Pictured ：
Enter the temporary password , Password changed successfully , Then log in with your new password ：
mysql -u root -p
enter , New password , enter , Login successful ！
Now you can write your sql The command ！
- Search service
- find MySQL57(57 Version number )
- Right click properties to view the running status , start-up