How to Reset the MySQL or MariaDB Root Password
If you lose the password for the MySQL/MariaDB root user, you can reset it by restarting MySQL/MariaDB in Safe Mode, which does not require a password.
First, shut down the database with the command:
- Ubuntu/Debian: MySQLsudo service mysql stop
- Ubuntu/Debian: MariaDBsudo service mariadb stop
- CentOS/Red Hat: MySQLsudo systemctl stop mysql
- CentOS/Red Hat: MariaDBsudo systemctl stop mariadb
SSL certificates from IONOS
Protect your domain and gain visitors' trust with an SSL-encrypted website!
Start MySQL/MariaDB in Safe Mode with the command:
mysqld_safe --skip-grant-tables &
You can now log in to MySQL/MariaDB as root without having to enter a password:
mysql -u root mysql
Reset the MySQL/MariaDB password with the following command. Change my-new-password to a secure password.
UPDATE user SET password=PASSWORD("my-new-password") WHERE user='root';
Reload the privilege tables:
FLUSH PRIVILEGES;
Exit the MySQL/MariaDB client:
quit;
Shut down MySQL/MariaDB:
mysqladmin -u root -p shutdown
You will need to enter the password for root which you set in the previous step.
Finally, restart the database in normal mode:
- Ubuntu/Debian: MySQLsudo service mysql start
- Ubuntu/Debian: MariaDBsudo service mariadb start
- CentOS/Red Hat: MySQLsudo systemctl start mysql
- CentOS/Red Hat: MariaDBsudo systemctl start mariadb
$1 Domain Names
Register great TLDs for less than $1 for the first year.
Why wait? Grab your favorite domain name today!
Related articles
kentohShutterstock MariaDB vs. MySQL
MySQL is the most used database management system in the world. This open source software has been available for productive use since 1995 and is generally considered a standard solution for users of relational databases. This could change in the near future. MariaDB, a community-developed fork of MySQL is catching up on its predecessor and is consequently becoming an increasingly attractive…
How to Backup Databases with MySQLDumper
“Data is the new oil!”. So when it comes to online businesses, loss of data means loss of capital. Important and sensitive data should be backed up at regular intervals. Thanks to free programs such as MySQLDumper you can create MySQL database backups in minutes! Once installed, you can use the software to automatize and administer backups.
How to install and use MySQL/MariaDB
MySQL/MariaDB is one of the most popular relational databases. Under Linux, it is easy to install and manage via the terminal. Find out how to install Mysql with this article’s step by step instructions. We will also show you the basic commands so that you can create your first custom database. What are you waiting for?
