Blog for NIX system based administrators

forgotten password

How to change Forgotten Mysql root Password

To reset forgotten root password in Linux(Ubuntu,Kubuntu,debian,redhat,centos,fedora) you need to do the following things: mysqld_safe –skip-grant-tables mysql –user=root mysql update user set Password=PASSWORD(‘new-password’) where user=’root'; flush privileges; exit;

Tags: , , , ,

Posted in Linux Administration | No Comments »