How to solve the problem of forgetting mysql password on mac?

Solution: First open the terminal and enter the command "mysql -u root"; then enter the command "UPDATE mysql.user SET authentication_string=PASSWORD('new password') WHERE User='root';".

(Recommended tutorial: mysql video tutorial)

Log in mysql on mac and forget your password Solution

1. Open the terminal and enter the command: cd /usr/local/mysql/bin

2 , mysql -uroot -p, use this command to log in and report an error message:

Error message:

Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

3. Open the terminal and enter: sudo mysqld_safe --skip-grant-tables

Output

Password:
Logging to '/usr/local/mysql/data/localhost.err'.2018-10-10T03:21:40.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

4. Open a new terminal and enter: mysql -u root , you will see the following output.

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16Server version: 5.7.23 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

5. Enter use mysql in the terminal and the display will be 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

6. Change password: UPDATE mysql.user SET authentication_string=PASSWORD ('Your password') WHERE User='root';

Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 1

Related recommendations:php training

The above is the detailed content of How to solve the problem of forgetting mysql password on mac?. For more information, please follow other related articles on the PHP Chinese website!