Mysql 5.7.13 installation and configuration notes (Mac OS), mysql5.7.13

Mysql 5.7.13 installation and configuration notes (Mac OS), mysql5.7.13

1. Install MySQL5.7.13
Go to the MySQL official website at http://dev.mysql.com/downloads/mysql/, and download mysqlinstallable dmgversion
Mysql-5.7.13-osx10.11-x86_64. dmg
The downloaded file is: mysql-5.7.13-osx10.11-x86_64. dmg
Click the installation package to install it step by step.
Click the "mysql" icon in the other settings of the system preference.
Click Start MySQL Server to Start mysql

2. Open the terminal and define the MySQL alias
Enter the alias command
Alias mysql =/usr/local/mysql/bin/mysql
Press enter.
Alias mysqladmin =/usr/local/mysql/bin/mysqladmin

3. Set the password of the mysql root Account
(Note that a random password will be generated after the initial password system is installed, and you will be notified in a prompt box)
Mysqladmin-u root password initial password
// If you need to modify the settings, run the following command:
Mysqladmin-u root-p password new latest password
Enter the password. Enter the old password and press Enter.

4. Connect to the database
Mysql-u root-p
Then you are prompted to enter the password and the password you just set.
Log on to the mysql database on the remote host
Mysql-h host address-u user name-p User Password
Then there will be a long-overdue mysql>
Success.

The above is the installation tutorial of Mysql 5.7.13 in Mac OS environment. I hope it will be helpful to you.