How to Change MySQL Root Password in Ubuntu 22.04?

mysql  Ver 8.0.31-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

mysql  Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1

Restart the MYSQL server and continue installing Ezeelogin

Note: Empty/blank password means there is no password; hence anyone can log in as long as MySQL privileges have been granted.

To log in as a root user in Linux

If the password is not set up or you forgot or need to change your MySQL password, below is a guide on how to do set up/recover the password.

MySQL is a standard query language for managing relational databases. If you forgot the MySQL root password, don’t worry; there is a method to reset it. The MySQL root password can be changed, and the server can be accessed with sudo privileges.

In this guide, we will elaborate on changing the root password for MySQL in Ubuntu 22.04.

Step 1: Check MySQL Version

First, Check the installed version of MySQL server in our system using the below command:

MySQL version 8.0.30 is installed in the system.

Step 2: Stop MySQL service

Now, to change the MySQL root password; first, you need to stop the MySQL service using this command:

$ sudo systemctl stop mysql.service

You can verify the MySQL server service status if it’s running or stooped by executing provided command:

$ sudo systemctl status mysql.service

Output shows the system is “inactive”, verifying the MySQL service is stopped.

Step 3: Skip Grant Tables and Networking

$ sudo systemctl set-environment MYSQLD_OPTS=»—skip-networking —skip-grant-tables»

The MySQL environment is set up. We can log in to the MySQL server without using a password.

Step 4: Start MySQL Service

After setting the MySQL environment, run this command to start the server:

$ sudo systemctl start mysql.service

The service for MySQL has started.

The current state of MySQL is active (running).

You will be directed to the MYSQL prompt.

Step 6: Change MySQL root password

The new MySQL root password is set up in Ubuntu 22.04.

Step 7: Quit MySQL Prompt

To log out, type “quit” in MySQL prompt:

Step 8: Restore Database Normal Settings

In the previous steps, we changed the environment variable by skipping networking and grant tables. Now, it’s time to restore the MySQL database’s normal setting for a secure configuration. For unsetting the environment variable:

$ sudo systemctl unset-environment MYSQLD_OPTS

Next, we need to remove the modified system configuration by reverting the MySQL using this command:

$ sudo systemctl revert mysql

Step 9: Kill All MySQL Services

Now, use the “killall” command to end all MySQL server’s processes:

MySQL is completely closed.

Step 10: Restart MySQL service

Restart the MySQL service after closing all the previous processes using:

$ sudo systemctl restart mysql.service

MySQL has been activated again.

Step 11: Log in to MySQL With New Password

So, we have successfully changed the MySQL root password in Ubuntu.

Setting, Changing and Resetting MySQL and MariaDB Root Passwords

The word ‘password’ in the above example is part of the command, do not replace that with your password. The word ‘newpass’ is the new password.

Here is how to use that command:

Answer the questions as shown below:

<— Enter a new MySQL root passwordRe-enter new password: <— Repeat the MySQL root password

Change MySQL password for other users

The variables in this example are:

The word ‘password’ is not a variable, so do not replace it. The command will ask for the old password.

Method 2 — Update or change password

mysql -u root -p

2) Use the database (type commands at the prompt):

MySQL 5.7.5 and earlier

MySQL 5.7.6 and newer

4) Reload privileges:

This method you need to use while using PHP or Perl scripting.

Recover lost MySQL root password

Step # 1: Stop the MySQL server process.

Step # 2: Start the MySQL (mysqld) server/daemon process with the option so that it will not prompt for a password.

Step # 4: Set a new root password.

Step # 5: Exit and restart the MySQL server.

Step # 1: Stop the MySQL service:

service mysql stop

Stopping MySQL database server: mysqld.

Step # 2: Start the MySQL server w/o password:

mysqld_safe —skip-grant-tables &

Step # 3: Connect to the MySQL server using the MySQL client:

Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 56299Server version: 5.6.34-1 (Debian)

Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.

Step # 5: Stop the MySQL server:

Or use this command to stop MySQL if the command above fails to stop it (which command works depends on the MySQL version):

The output might differ based on the Linux distribution. Don’t worry unless it reports an error. Start the MySQL server and test it:

service mysql startmysql -u root -p

SET MYSQL ROOT PASSWORD

What is Mysql default  Password?

How to set Mysql root Password?

1. Stop Mysql Service.

2. Ensure mysqld dir exists and set the owner.

3. Start MySQL with —skip grant-tables& option

When the —skip-grant-tables option is used, anyone can connect to the database server without a password d with all privileges granted.

4. Login without a Password.

5. Reset the Root Password

6. After Resetting make sure all MYSQL processes are stopped before starting the service again.

7. Start Mysql service

This feature is only available to subscribers. Get your subscription here.

Recover your MySQL password

1. Stop the MySQL server process using the command:

sudo service mysql stop

service stop MySQL

sudo mysqld_safe —skip-grant-tables —skip-networking &

Once you are done running all the commands mentioned above, proceed and restart the MySQL daemon using this command:

sudo service mysql restart

By now, you should be able to log into MySQL using the newly set password.

That’s all. We believe you are now in a position to set, reset, and recover your MySQL root password.

Then, input your passcode at the prompt. A MySQL shell will load.

For the sake of the tutorial, I will change the password to ‘Fosslinux as shown in the command line and output below:

open MySQL shell

After running the commands listed above, exit the MySQL shell by clicking CTRL + D on your keyboard or key in “exit” on the MySQL shell and click enter. You do not have to restart the MySQL service for you to log in using the command below:

At this point, you can now attempt to access MySQL with root again. In the terminal, key in:

login to MySQL as root

How to set up, change, and recover a MySQL root password

Please note: there have been many attacks across the IT landscape, thus necessitating very strong passwords, which I highly recommend for your databases. You can try out an unsystematic password generator, then save the password via the aid of a password manager.

Let’s carry on.

Setting the password for the first time

Typically, during the installation of MySQL, you are required to set an initial password. However, if this was not done while installing and setting up MySQL, you will first have to set up a password. Here is how to do that:

Where Fosslinux is the password that you will be using from now on, this means that every time you log into MySQL using the command mysql -u root -p, you will have to key in the password we have just configured.

MySQL secure installation

After setting up the MySQL root password for the first time, it is time to learn how to change it.

Changing the MySQL root user password

create new password

Where Fosslinux$11 is the new password that will be used.  Remember to satisfy the current password policy by combining uppercase, lowercase, numeric and special characters.

Save the file as ~/mysql-pwd

sudo mysqld -init-file=~/mysql-pwd

save MySQL password

Now that we have fruitfully learned how to change the newly created MySQL root password, it is time to learn how to recover a forgotten or lost MySQL root password.

Conclusion

The article further breaks down the steps to set up, change and recover a MySQL root password and set up the root password for the first time. Ensure to stick to all the processes provided in this article to avoid security breaches by using strong password combinations. We hope the article will be helpful. If yes, give a thumbs up via the comments section.