본문 바로가기
Research/Linux

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

by sunnyan 2009. 3. 3.
728x90
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


728x90