Latest News: Linux shell script to change you ssh port

Reset MariaDB Root Password in CentOS 6.4

Tutorial willing 333View(s) 0Comment

I have forgot my MariaDB root password and when trying to reset the root password I was thinking, “Let Unixmen readers know how I have solved my issue”.

First, stop running MySQL daemon:

Start MySQL Daemon in Safe Mode:

Login to MariaDb server without a password:

Set the  new password in the line below:

Flush privileges on exit:

Restart  MySQL daemon:

Login now  to  check the new password:

Show the tables or databases:

Done!

 

 

Souce:https://www.unixmen.com/reset-mariadb-root-password/

Please give credit to the original author when you use it elsewhere: VPS List Agent » Reset MariaDB Root Password in CentOS 6.4

Login to post a comment!