Apache에Php세팅하기 › 보안툴 › 테스트커버리지측정도구 › WordInMind › 마우스오른버튼눌러현재폴더의명령창(cmd)띄우기 › ResetMysqlRootPassword
- always monitor log file
/var/log/mysql/error.log
- always login as a root with sudo
sudo mysql -uroot -p
1.stop server
2.create file. contents are:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
- this can be read by mysql
sudo mysqld --init-file=/home/me/mysql-init &
4.stop server
sudo kill `cat /var/run/mysqld/mysqld.pid`
5.reset in mysql client
$ mysql mysql> FLUSH PRIVILEGES; mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';