How to Reset MySQL Root User Password on Ubuntu

Websolutionstuff | Jan-26-2024 | Categories : Other

Hey there! If you've ever found yourself scratching your head over a forgotten MySQL root password on Ubuntu, fear not – I've got your back. In this guide, I'll walk you through the steps to reset that password like a pro.

Now, don't worry if you're not a command-line expert. We're going to take it one step at a time, and by the end of this, you'll be back in control of your MySQL root access.

So, grab your Ubuntu terminal, and let's dive into the world of resetting passwords together. Ready? Let's get started!

So, let's see how to reset the MySQL root user password on Ubuntu, how to change the MySQL root user password in Ubuntu, change the MySQL root password in Ubuntu, and reset the mysql root password on Ubuntu 23.04.

Here's a step-by-step guide on how to reset the MySQL root user password on Ubuntu:

Step 1: Open Terminal

Open a terminal on your Ubuntu system. You can do this by pressing Ctrl + Alt + T or searching for "Terminal" in the application launcher.


Step 2: Stop MySQL Service

Before resetting the password, stop the MySQL service to prevent any potential conflicts. Use the following command:

sudo service mysql stop


Step 3: Start MySQL in Safe Mode

Start MySQL in safe mode, skipping the grant tables to avoid loading user privileges. This allows you to reset the root password without authentication.

sudo mysqld_safe --skip-grant-tables &


Step 4: Connect to MySQL

Open a new terminal window and connect to the MySQL server without entering a password:

mysql -u root


Step 5: Select MySQL Database

Switch to the mysql database, where user information is stored:

use mysql;


Step 6: Update Root Password

Now, update the root user password with the following command. Replace 'new_password' with your desired password

UPDATE user SET authentication_string=PASSWORD('new_password') WHERE User='root';

If you are using MySQL 8.0 and later versions, use the following command:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password';


Step 7: Flush Privileges

Flush the privileges to apply the changes:



Step 8: Exit MySQL

Exit the MySQL shell:



Step 9: Stop and Start MySQL Service

Stop the MySQL service started in safe mode:

sudo service mysql stop

Then, start the MySQL service:

sudo service mysql start


Step 10: Verify the New Password

Try logging into MySQL using the new password to ensure it's working:

mysql -u root -p

Enter the new password when prompted.



You've successfully reset the MySQL root user password on Ubuntu! This can be handy if you ever find yourself locked out or need to update your password for security reasons.


You might also like:

Recommended Post
Featured Post
How To Send Email In Laravel 9 Using Mailgun
How To Send Email In Laravel 9...

In this article, how to send email in laravel 9 using mailgun. we will learn laravel 9 to send emails using mailgun...

Read More


How To Integrate Paypal Payment Gateway In Laravel
How To Integrate Paypal Paymen...

In this tutorial I will teach you the most important topic of how to integrate the PayPal payment gateway in larave...

Read More


How To Convert Laravel Query To SQL Query
How To Convert Laravel Query T...

In this article, we will see how to convert a laravel query to an SQL query. Many times we required laravel query builde...

Read More


How To Get Data Between Two Dates In Laravel 9
How To Get Data Between Two Da...

In this article, we will see how to get data between two dates in laravel 9. Here we will learn how to count d...

Read More