There are two files in the data file: IB_ Logfile0 and IB_ logfile1。 Delete them.Įnter the terminal input: CD / usr / local / MySQL / bin/Įnter the following command to disable the MySQL verification function. If you do not have permission, you can modify the readable and writable permission of the file. If you also encounter this problem, please first find the directory / usr / local / MySQL / data /, and find the data folder. It’s just strange that I can’t log in (all modes are invalid), and it’s almost impossible to change the password! In the final analysis, this problem is still the problem of wrong password. Many netizens said to modify / etc / my.conf , I didn’t look for the document. I just can’t log in normally and report the same error. I’ve tried all kinds of methods, but I can’t solve my problem. I’ve read a lot of answers from netizens to this question. bash_ pro file # Open the environment variable settings fileĮnter in the file: export PATH=$:/usr/local/mysql/binĪfter the installation is completed, this error will appear when starting and entering:ĮRROR 1045 (28000): Access denied for user (using password: YES) SQLSTATEHY000 1045 Access denied for user ‘root’’localhost’ (using password: YES) (SQL: select count() as aggregate from users where email ) Step 1: I have changed. at localhost failed error: Access denied for user rootlocalhost. Pay attention to the setting of environment variables Unable to log in to phpMyAdmin with MySQL root password (on Mac OS X lion).