The last post described the procedure of creating a user in MariaDB on Ubuntu 22.04. In today’s post, we will be covering the method of changing a user’s password in MariaDB.

Setting a password for a user in MariaDB on Ubuntu is necessary for user authentication and data protection. It is a crucial security measure to prevent unauthorized access to the database and ensure accountability for user activities. Additionally, you can change this password whenever you want.

In this post, we are about to learn the method of updating or changing a user’s password in MariaDB on Ubuntu 22.04.

Changing User’s Password in MariaDB on Ubuntu 22.04

Changing a user’s password in MariaDB on Ubuntu is necessary for security, compliance, and best practices. It can maintain accountability and prevent unauthorized access to the database. Password changes may be required periodically or in case of employee turnover or shared accounts.

Here is the method of updating the user’s password in MariaDB on Ubuntu 22.04.

Step 1: Open Ubuntu’s terminal

Press “CTRL+ALT+T” to launch the Ubuntu terminal:

Step 2: Open MariaDB Shell

Utilize this command to open the MariaDB shell:

sudo mysql -u root -p

Step 3: Selecting Database

After that, select a specific database by utilizing the command below:

USE mysql;

Step 4: Create a User

If there is no existing user, then, create a new one:

CREATE USER 'sharqa'@'localhost' IDENTIFIED BY 'author';

Step 5: Change the password

To change the password, use this command:

SET PASSWORD FOR 'sharqa'@'localhost' = PASSWORD('[email protected]');

Note: “[email protected]” is our new password.

Step 6: Flush Privileges

Next, type the command below in the MariaDB shell to make the changes take effect:

FLUSH PRIVILEGES;

That was all about changing a user’s password in MariaDB on Ubuntu 22.04.

Conclusion

To change the user password in MariaDB on Ubuntu 22.04, open the terminal first. After that, use the “sudo mysql -u root -p” command to open the MariaDB shell. Then, select a specific database. Next, if there is no existing user, create a new one “CREATE USER ‘sharqa’@’localhost’ IDENTIFIED BY ‘author’;”. Utilize the “SET PASSWORD FOR ‘sharqa’@’localhost’ = PASSWORD(‘[email protected]’);” command for changing the password. Now, make the changes take effect by using the “FLUSH PRIVILEGES;” command. That’s how you can update the user’s password in MariaDB on Ubuntu 22.04.