How to deal with the error report of ERROR 1045 (28000) when mac builds mysql

Next, let's learn how to deal with mac building mysql ERROR 1045 (28000) error report. I believe you will benefit a lot after reading it. The text is not much in essence. I hope that mac building mysql will appear ERROR 1045 (28000) error report how to deal with this short article is what you want.

After installation, mysql-h localhost-u root-p reported an error

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

Step 1: delete the ib_logfile0 and ib_logfile1 files under / usr/local/mysql/data/.

Step 2: stop the Mysql service in the system preferences

Step 3: cd / usr/local/mysql/bin/

Execute. / mysqld_safe-- skip-grant-tables &

(mysql will restart automatically, and the status of mysql in the system preferences will change to running)

Step 4: execute. / mysql

After entering enter, enter the command FLUSH PRIVILEGES

After entering enter, enter the command ALTER USER 'root'@'localhost' IDENTIFIED BY' your new password

After reading this article about how to deal with mac mysql and ERROR 1045 (28000) error report, many readers will want to know more about it. If you need more industry information, you can follow our industry information section.