Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost'

[Sakai Noriko]

Hi,
Sorry I have wrote the MySQL version wrong, the version really is 5.7.1.

As mentioned, I can only login by running the 'mysqld_safe -user=root --skip-grant-table'.
Now then when I tried the 'Alter User' from the reference you gave, I keep getting following error:

mysql> ALTER USER 'root'@'localhost'
-> IDENTIFIED BY 'junk1234';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

What should I do to fix this issue?

Thanks