Teach you how to install mysql database on Mac

Download MySQL for Mac: https://downloads.mysql.com/archives/community/
Note: I downloaded the community version, the mysql version should be consistent with your MAC version. Of course, if you have installed other MYSQL versions before, be sure to uninstall them first.

Double-click mysql-8.0.0-dmr-osx10.11-x86_64.dmg to decompress and install.

Continue -> Continue, Agree -> Install. Write down the password in the pop-up window.

Enter system preferences, find mysql, and start the service

Add mysql commands to the system

(1) Enter /usr/local/mysql/bin and check whether there is mysql in this directory
(2). Execute vim ~/.bash_profile
Add the mysql/bin directory to this file
PATH=$PATH:/usr/local/mysql/bin
After adding, press esc and enter wq to save the changes.
(3). Finally, enter source ~/.bash_profile in the command line.

Log in to mysql through mysql -uroot -p and enter the password you saved previously

Reset the mysql initial password:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');