Detailed steps to install mysql5.7.18 on Mac

1. Tools

We need two tools now: MySQL server (mysql-5.7.18), MySQL GUI (mysql-workbench)

The MySQL server contains the entire operating environment of MySQL. After installing it, you can run MySQL well through the command line.

Of course, if you don't like the command line, you can download a GUI tool to manage MySQL. The GUI has rich functions, including permission settings, database creation, table creation, etc.

2. Installation

1.MySQL Server

Download address: https://dev.mysql.com/downloads/mysql/ . I downloaded mysql-5.7.18-macos10.12-x86_64.dmg

After downloading, install it directly without any trouble.

It is worth noting that after the installation, a pop-up window will be prompted for the root account password. Please write it down as we will use it later.

After installation, the mysql command cannot be recognized in the terminal, so it needs to be configured

$ cd /usr/local/bin/
$ sudo ln -fs /usr/local/mysql/bin/mysql mysql
$ mysql --version 

#Can display mysql version description mysql installed successfully

Change the password of the root account:

$ sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
$ mysql -u root
#Will enter mysql command mode, enter the following commands line by line

UPDATE mysql.user SET authentication_string=PASSWORD('*****') WHERE User='root';
FLUSH PRIVILEGES;
\q

#Verify password after modification

# mysql -u root -p

2. Install GUI

Download address: https://dev.mysql.com/downloads/workbench/ . I downloaded mysql-workbench-community-6.3.9-osx-x86_64.dmg

Download and install, no chatter along the way.

After installation, open Workbench and the interface is as follows:

Click to enter

root

localhost:3306

The first time you log in, you will be prompted to change your password, so just change it.

Enter the Workbench

The installation is now complete!

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.