mysql:password_recovery
This is an old revision of the document!
MySQL - Password Recovery
- /var/lib/mysql/mysql-pass-recover
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES;
Restart mysql with new init file
chown mysql:mysql /var/lib/mysql/mysql-pass-recover /etc/rc.d/rc.mysqld stop sleep 5 killall mysqld; killall mysqld; killall mysqld; killall mysqld; sleep 5 mysqld_safe --init-file=/var/lib/mysql/mysql-pass-recover & sleep 5 killall mysqld; killall mysqld; killall mysqld; killall mysqld; sleep 5 /etc/rc.d/rc.mysqld start
mysql/password_recovery.1467418200.txt.gz · Last modified: 2020/07/15 09:30 (external edit)