[MySQL] Access denied for user 'root'@'localhost' (using password: YES) 오류해결

MySQL에서 Access denied for user 'root'@'localhost' (using password: YES) 오류해결

# mysql -u root -p

Enter password:

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

이러한 오류의 경우에는 MySQL의 패스워드를 재설정해줘야 한다:

# service mysql stop

# mysqld --skip-grant-tables &

# mysql -u root

mysql> use mysql;

mysql> update user set password=password('password를 입력한다') where user='root';

mysql> flush privileges;

mysql>quit

# service mysql start

[출처] http://blog.naver.com/yoosy0302/130113061219

[출처] [MySQL] Access denied for user 'root'@'localhost' (using password: YES) 오류해결|작성자 주한길