\u00a0<\/p>\n<\/p>\n
MySQL and MariaDB are popular open-source relational database management systems used by many websites and applications. Managing the root password is critical for securing your database. This guide will walk you through the steps to set, change, and reset the root password for both MySQL and MariaDB on a Linux server. This is especially useful in environments like or other Windows VPSVirtual Private Servers<\/a>.<\/p>\n Before starting, ensure you have the following:<\/p>\n If you are setting up MySQL or MariaDB for the first time, you will need to set the root password. You can do this during the initial installation or later. If you have not set the password yet, follow these steps:<\/p>\n During the If you already have a root password but want to change it, you can do so by logging into the MySQL\/MariaDB shell with your current root credentials:<\/p>\n Once logged in, you can change the root password by executing the following command:<\/p>\n Make sure to replace Finally, exit the MySQL shell:<\/p>\n If you have forgotten your MySQL or MariaDB root password, you can reset it by following these steps:<\/p>\n First, stop the MySQL\/MariaDB service to start the server in a safe mode:<\/p>\n Next, start the server without password validation:<\/p>\n This will start the MySQL\/MariaDB server without loading the grant tables, allowing you to log in without a password.<\/p>\n Once the server is running in safe mode, log in as root without a password:<\/p>\n Then, reset the root password using the following command:<\/p>\n Afterward, flush the privileges and exit the MySQL shell:<\/p>\n Finally, stop the safe mode server and restart the MySQL\/MariaDB service normally:<\/p>\n To verify that the new root password works, log in again using the updated password:<\/p>\n Enter your new password when prompted, and you should be logged in successfully.<\/p>\n By following these steps, you can easily set, change, or reset the MySQL or MariaDB root password. Proper management of your root password ensures the security of your databases, which is crucial for your server environment, whether hosted on a , Windows VPS<\/a>, or other platforms.<\/p>\nPrerequisites<\/h2>\n
\n
Step 1: Setting the MySQL\/MariaDB Root Password<\/h2>\n
sudo mysql_secure_installation<\/code><\/pre>\nmysql_secure_installation<\/code> process, you will be prompted to set the root password. Follow the prompts to create a secure password. Once completed, your root password will be set.<\/p>\nStep 2: Changing the MySQL\/MariaDB Root Password<\/h2>\n
sudo mysql -u root -p<\/code><\/pre>\nALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';<\/code><\/pre>\nnew_password<\/code> with your desired password. Then, flush the privileges to apply the changes:<\/p>\nFLUSH PRIVILEGES;<\/code><\/pre>\nEXIT;<\/code><\/pre>\nStep 3: Resetting the MySQL\/MariaDB Root Password<\/h2>\n
Step 3.1: Stop the MySQL\/MariaDB Service<\/h3>\n
sudo systemctl stop mysql # For MySQL\r\nsudo systemctl stop mariadb # For MariaDB<\/code><\/pre>\nStep 3.2: Start MySQL\/MariaDB in Safe Mode<\/h3>\n
sudo mysqld_safe --skip-grant-tables &<\/code><\/pre>\nStep 3.3: Log in and Reset the Root Password<\/h3>\n
mysql -u root<\/code><\/pre>\nALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';<\/code><\/pre>\nFLUSH PRIVILEGES;\r\nEXIT;<\/code><\/pre>\nStep 3.4: Restart MySQL\/MariaDB Service<\/h3>\n
sudo systemctl stop mysql # For MySQL\r\nsudo systemctl stop mariadb # For MariaDB\r\nsudo systemctl start mysql # For MySQL\r\nsudo systemctl start mariadb # For MariaDB<\/code><\/pre>\nStep 4: Verifying the New Root Password<\/h2>\n
mysql -u root -p<\/code><\/pre>\nConclusion<\/h2>\n