Installing MySQL 5.7 under Mac OS

Mac OS X under TAR. GZ mode installing MySQL 5.7 compared to MySQL 5.6, the 5.7 version was installed in two different places:

1: Initialization mode change, from scripts/mysql_install_db--user=mysql initialization mode to bin/mysqld--initialize--user=mysql mode;

2: Initial password generation change, 5.6 version after the tar gz mode is initialized, the default root password is empty, and the 5.7 version will generate a temporary root password after initialization is completed;

Download the latest MySQL compression version, the official website to find http://dev.mysql.com/downloads/

Take 5.7.16 as an example Mysql-5.7.16-osx10.11-x86_64.tar

First double-click Unzip, extract a folder into the folder there are still 2 compressed packets, one for Mysql-5.7.16-osx10.11-x86_64.tar another for mysql-test-5.7.16-osx10.11-x86_ 64.tar

After extracting the Mysql-5.7.16-osx10.11-x86_64.tar, omit the file containing test

After unpacking, open the command line

# Move the unpacked binary package to the installation directory sudo mv Mysql-5.7.16-osx10.11-x86_64/usr/local/mysql

# change the MySQL installation directory to the user and user group cd/usr/local sudo chown-r root:wheel mysql

# switch to the MySQL installation directory and execute the init command and log the generated temporary root password cd/usr/local/mysql sudo bin/mysqld--initialize--user=mysql

Note: You need to record the temporary root password that appears in the Command line window after initialization is complete.

Test start, restart, and stop: cd/usr/local/mysql

# start sudo support-files/mysql.server start

# Restart sudo support-files/mysql.server restart

# Stop sudo support-files/mysql.server stop

# check MySQL running status sudo support-files/mysql.server status

(Warm reminder: There are two ways to operate the MySQL command, one is to set the MySQL environment variable, so you can use the MySQL command directly without the need to enter mysql/.) Executed under the/bin directory.

The other is to go directly into the/usr/local/mysql/bin/to execute the script, where the first method is used)?

In terminal, add MySQL Bin directory for path path: path= "$PATH":/usr/local/mysql/bin

Then log in to MySQL with the following command (the password is the temporary password that was automatically generated earlier) Mysql-u root-p

Enter the temporary password to log in successfully.

Recommended password change after successful login

Mysql> set PASSWORD =password (' 123456 ');

After the modification is successful, exit

Mysql> exit;

Re-connect

Mysql> Mysql-u Root-p

Enter the new password and the connection is successful.

View Database

mysql> show databases;

Installing MySQL 5.7 under Mac OS