reset mysql root password from command line Unix/linux

MySQL is a Relational Database Management System (RDBMS) that runs as a server providing multi-user access to a number of databases.


[root@server ~]# yum install mysql-server mysql php-mysql 
[root@server ~]# rpm -qa|grep mysql 

Steps to reset mysql password:
Step 1: Stop mysql server

[root@server ~]# service mysqld stop
Stopping mysqld:                               [ OK ]
[root@server ~]# /etc/init.d/mysqld stop 
Stopping mysqld:                               [ OK ]

Step 2: Start mysql configuration, Execute the command as mysql safemode:

[root@server ~]# mysqld_safe --skip-grant-tables & 

Step 3: Replace old password with the new one from mysql command prompt.

mysql> update user set password=PASSWORD("newpassword") where User='root'; FLUSH PRIVILEGES; exit;

Step 4: Restart mysql server.

[root@server ~]# service mysqld restart

Step 5: Access mysql by using new password

[root@server ~]# mysql -u root -p
Enter password:

That’s it 🙂

Post navigation

Arunlal A

Senior System Developer at Zeta. Linux lover. Traveller. Let's connect! Whether you're a seasoned DevOps pro or just starting your journey, I'm always eager to engage with like-minded individuals. Follow my blog for regular updates, connect on social media, and let's embark on this DevOps adventure together! Happy coding and deploying!

One thought on “reset mysql root password from command line Unix/linux

Leave a Reply

Your email address will not be published. Required fields are marked *