How to reset mysql root password in linux centos

ARUN Post in MYSQL
0

/etc/init.d/mysqld stop

[  mysqld_safe --skip-grant-tables &  ]

mysql -u root

use mysql;

update user set password=PASSWORD(“YOUR_ROOT_PW”) where User=’root’;

Above command can be used to reset plesk admin password as well.

flush privileges;

quit

/etc/init.d/mysqld stop

/etc/init.d/mysqld start

mysql -u root -p

« Prev: :Next »

Leave a Reply

You must be logged in to post a comment.