Installation process of MySQL5.7.22 on Mac

1. Use the installation package to install MySQL (online download is too slow, if you need the installation package, you can leave a message at the bottom of the article and I will send it to you) Double-click to open the installation file

Double-click the pkg file to install all the way down. Remember to save the password in the last pop-up box (it is the password of your mysql root account). Under normal circumstances, the installation is successful. At this point, the installation is successful, but additional configuration is required:

(1) Enter System Preferences

(2) Click mysql

(3) Start the MySQL service

Add mysql to the system environment variables

Enter /usr/local/mysql/bin and check whether there is mysql in this directory

Execute vim ~/.bash_profile
Add the mysql/bin directory to the file, see pic7:
PATH=$PATH:/usr/local/mysql/bin
After adding, press esc and enter wq to save the changes.
Finally, enter source ~/.bash_profile in the command line

pass

mysql -u root -p

Log in to mysql, you will be asked to enter the password

Apple->System Preferences->Click MySQL at the bottom. In the pop-up page, turn off the MySQL service (click Stop MySQL Server).

step2:

Enter the terminal and enter: cd /usr/local/mysql/bin/

After pressing Enter, log in with administrator privileges sudo su

After pressing Enter, enter the following command to disable the mysql authentication function./mysqld_safe --skip-grant-tables &

After pressing Enter, MySQL will automatically restart (the status of MySQL in the preferences will become running)

step3.

Enter the command ./mysql

After pressing Enter, enter the command FLUSH PRIVILEGES;

After pressing Enter, enter the command

MySQL 5.7.6 and later: ALTER USER 'root'@'localhost' IDENTIFIED BY 'your new password';

MySQL 5.7.5 and earlier: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('your new password');

At this point, the password change is complete and you can log in successfully.

Summarize

The above is the installation process of MySQL5.7.22 on Mac introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!