Smokes your problems, coughs fresh air.

Tag: password

Changing lost MySQL root password

When you don’t know the current mysql root password and you want to change it, do this:

/etc/init.d/mysql stop
mysqld --skip-grant-tables &
mysql -p
use mysql;
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
flush privileges;
killall mysqld
/etc/init.d/mysql start


© 2024 BigSmoke

Theme by Anders NorenUp ↑