search

Reset Mysql 5.5 Password


MYSQL 5.5

Stop Mysql Service

systemctl stop mysqld

or

service mysqld stop

or

ps -ef | grep mysqld | awk -F" " '{print $2}'| xargs kill -9

Start mysql service without grant tables

mysqld_safe  --skip-grant-tables

Login to mysql :

mysql -uroot mysql

mysql console

mysql > update user set Password=PASSWORD(‘new-password’) where user='root’;mysql > flush privileges;
close
Visit Us On TwitterVisit Us On GooglePlusVisit Us On Linkedin

Hi, guest!

settings

menu