MySQL: Reset root and debian-sys-maint passwords

vim /home/me/mysql-init
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');
SET PASSWORD FOR 'debian-sys-maint'@'localhost' = PASSWORD('newpassword');

kill `cat /var/run/mysqld/mysql.pid`

mysqld_safe –init-file=/home/me/mysql-init &

vim /etc/mysql/debian.cnf

service mysql restart

rm /home/me/mysql-init

Leave a Reply