How to install mysql with brew: 1. Execute the "brew install mysql@5.7" command; 2. Start mysql; 3. Log in to mysql and change the default password.
The operating environment of this article: macOS10.15 system, mysql5.7 version, macbook pro 2020 computer.
How to install mysql with brew?
Mac uses brew to install mysql
If you do not consider the version, directly execute the following command
brew install mysql
If you want to select a version, just add @version, for example
brew install mysql@5.7
Start mysql after installation
mysql.server start
If the service is not started, the following error will occur
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
To close mysql
mysql.server stop
If you see the success prompt, it means the startup is successful
Starting MySQL . SUCCESS!
Now log in to mysql, which is password-free by default
mysql -u root
Change the root password, This is the modification method for 8.0
alter user 'root'@'localhost' identified with mysql_native_password by 'root';
If there is a prompt after pressing Enter, it means the modification is successful
Query OK, 0 rows affected (0.00 sec)
Then exit mysql
exit;
Finally log in again
mysql -u root -p
If you enter the password, you will be logged in successfully
[Related recommendations: mysql video tutorial]
The above is the detailed content of How to install mysql with brew. For more information, please follow other related articles on the PHP Chinese website!