Troubleshoot MySQL ERROR 1045 under Mac (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Source: Internet
Author: User

Maybe updating the package the Updater overwrote the root password.

To restore it:

Stop mysqld deamons.

$ sudo service mysqld stop

Go to Mysql/bin Directory

$ cd /usr/bin

Start a MySQL deamon with this option:

$ sudo mysqld_safe --skip-grant-tables

Open another terminal and open a MySQL session to execute this:

$ mysqlmysql> use mysql;see Note1 below for next line.mysql> UPDATE user SET authentication_string=PASSWORD(‘YOUR_NEW_PASSWORD_HERE‘) WHERE user = ‘root‘;mysql> exit;

Now kill the Mysqld_safe process and restart Mysqld normally:

$ sudo service mysqld start

Note1: password is the column name in table mysql.user prior to version 5.7. After which it became authentication_string . Change your UPDATE statement accordingly.

How you can not understand, give me a message, I teach you.

Troubleshoot MySQL ERROR 1045 under Mac (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.