Root 패스워드 리셋

루트 패스워드 리셋 (mysql에 접속 에러 Error 1045(28000): Access denied for user root)

# service mysqld stop
# cd /usr/local/mysql/bin
# ./safe_mysqld --skip-grant &
# mysql
# USE mysql;
# Update user SET Password=PASSWORD(‘실제패스워드’) WHERE user =‘root’;
# FLUSH privileges;
# Quit
# Service mysqld start