How to install mysql in brew

This article mainly introduces brew how to install mysql, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Brew install mysql method: 1, execute the "brew install mysql@5.7" command; 2, start mysql;3, log in to mysql and change the default password.

This article operating environment: macOS10.15 system, mysql5.7 version, macbook pro 2020 computer.

Mac installs mysql using brew

Execute the following command without considering the version

Brew install mysql

To select a version, simply add the @ version, for example

Brew install mysql@5.7

Start mysql after installation

Mysql.server start

The following error occurs if the service is not started

ERROR 2002 (HY000): Can't connect to local MySQL server through socket'/ tmp/mysql.sock' (2)

To close mysql

Mysql.server stop

When you see the prompt success, it indicates that the startup is successful.

Starting MySQL. SUCCESS!

Log in to mysql now. Login is secret-free by default.

Mysql-u root

Change the root password, which is the modification method of 8.0.

Alter user 'root'@'localhost' identified with mysql_native_password by' root'

If there is a prompt after enter, the modification is successful.

Query OK, 0 rows affected (0.00 sec)

Then exit mysql

Exit

Finally log in again

Mysql-u root-p

Log in successfully after entering the password

Thank you for reading this article carefully. I hope the article "how to install brew mysql" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!