Detailed explanation of the solution to the problem of being unable to log in when installing MySQL using homebrew on Mac

If your computer is a Mac, using homebrewto installMySQL is a very convenient way, but some problems will still occur. The following article will introduce to you how to solve the problem of being unable to log in when using homebrew to install MySQL on Mac. Friends who need it can refer to

If your computer is a Mac, using homebrew to install MySQL is a very convenient way, but it still occurs. Some questions;

First make sure you have installed mysql. If it is installed through homebrew, enter mysql.server start Start the service

If you enter

mysql -u root

This error ERROR 1045 (28000): Access denied for user 'zhongchengming'@'localhost' (using password: YES), it should be that the initial password was not modified successfully

Solution Steps

(1) Enter mysqld_safe --skip-grant-tables in the terminal and the display will be as follows

2017-03-21T11:44:11.6NZ mysqld_safe Logging to '/usr/local/var/mysql/zhongchengmingdeMacBook-Air.local.err'.
2017-03-21T11:44:11.6NZ mysqld_safe Logging to '/usr/local/var/mysql/zhongchengmingdeMacBook-Air.local.err'.
2017-03-21T11:44:11.6NZ mysqld_safe A mysqld process already exists

(2) Enter mysql -u root again and the display will be as follows

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.7.17 Homebrew
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

(3) The terminal input use mysql displays as follows

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>

(4) Change password UPDATE mysql.user SET authentication_string=PASSWORD('your password') WHERE User='root';

Success Query OK, 1 row affected, 1 warning (0.05 sec)

Rows matched: 1 Changed: 1 Warnings: 1

The above is the detailed content of Detailed explanation of the solution to the problem of being unable to log in when installing MySQL using homebrew on Mac. For more information, please follow other related articles on the PHP Chinese website!