[mySQL] 모든 접근권한이 막혔을때, 접근하는방법

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

mysql root password를 초기화

#killall mysqld
# mysqld_safe --skip-grant &
# mysql

- mysql> use mysql
- mysql> update user set password=password('new password') where user = 'root';
- mysql> flush privileges

flush privileges <-- 권한변경시 적용