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:
Exit the MySQL/MariaDB client:
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!