Shulou(Shulou.com)06/01 Report--

Xiaobian to share with you how to solve the problem of mysql forgotten password on mac, I believe most people still do not know how to share this article for your reference, I hope you have a lot of harvest after reading this article, let us go to understand it together!

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';".

Mac login mysql forgot password solution

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

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

Error:

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

3. Open terminal input: 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

Open a new terminal, type mysql -u root, and 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 respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>

5. Terminal input use mysql is displayed as follows

Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changed

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 Above is how to solve mysql forgotten password problem on mac all the content, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.