1. mysqld 를 중지시킨다.
2. bin폴더 혹은 실행파일중에서 아래 명령을 실행
/usr/local/mysql/bin/mysqld_safe –user=root –skip-grant-tables &
혹은 safe_mysqld 이다. 실행파일은 확인할것
3. mysql로 접근
mysql
use mysql
mysql> update user set Password=password(‘새비밀번호’) where Host=’localhost’ and User=’root’;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
mysql> quit
4. mysqld 재구동
[root@eshop bin]# killall mysqld_safe
[root@eshop bin]# ps -ax|grep mysqld_safe
Warning: bad syntax, perhaps a bogus ‘-‘? See /usr/share/doc/procps-3.2.3/FAQ
10115 pts/0 S 0:00 /bin/sh ./mysqld_safe –user=root –skip-grant-tables
10161 pts/0 S+ 0:00 grep mysqld_safe
[root@eshop bin]# kill -9 10115
[root@eshop bin]# ps -ax|grep mysqld_safe
Warning: bad syntax, perhaps a bogus ‘-‘? See /usr/share/doc/procps-3.2.3/FAQ
10166 pts/0 S+ 0:00 grep mysqld_safe
[1]+ 죽었음 ./mysqld_safe –user=root –skip-grant-tables
[root@eshop bin]# /etc/rc.d/init.d/mysqld start
ㅡㅡ