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 )
MAC
MySQL Server:mysql-5.7.19-macos10.12-x86_64.dmg
MySQL Workbench:mysql-workbench-community-6.3.9-osx-x86_64.dmg
MicroSoft Windows
windows The installation package here is Server+workbench All have
MySQL Server + Workbench:mysql-installer-community-5.7.19.0.msi
Download Interface
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 .
Be careful
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 [email protected]:ENd)fo--D8hP
If you lose the password , see also MySQL Refer to the manual on how to reset root The code section .
start-up
Mac start-up
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 )
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin
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 !
Windows start-up
- Search service
- find MySQL57(57 Version number )
- Right click properties to view the running status , start-up