Home > HOWTOs > mysql ‘root’ password reset in CentOS

mysql ‘root’ password reset in CentOS

If you are using CentOS 6.6. To reset the root password use the following steps:-
[ahmed@server ~] sudo service mysqld stop
[ahmed@server ~] sudo service mysqld startsos
[ahmed@server ~] mysql -u root
Now you will be at mysql prompt. Here type:-
mysql> UPDATE mysql.user SET Password=PASSWORD('NewPassHere') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> quit;
Now restart Mysqld.
sudo service mysqld restart
Advertisements
Categories: HOWTOs
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: