{"id":1617,"date":"2026-09-03T16:59:33","date_gmt":"2026-09-03T11:29:33","guid":{"rendered":"https:\/\/cpanelfree.com\/blog\/how-to-reset-mysql-root-password-linux-vps\/"},"modified":"2026-09-03T17:02:47","modified_gmt":"2026-09-03T11:32:47","slug":"how-to-reset-mysql-root-password-linux-vps","status":"publish","type":"post","link":"https:\/\/cpanelfree.com\/blog\/how-to-reset-mysql-root-password-linux-vps\/","title":{"rendered":"How to Reset MySQL Root Password on Linux VPS (Ubuntu \/ Debian \/ AlmaLinux)"},"content":{"rendered":"
\n

\n Quick Answer:<\/strong> To reset a lost MySQL\/MariaDB root password on a Linux VPS: 1)<\/strong> Stop MySQL (sudo systemctl stop mariadb<\/code>), 2)<\/strong> Start MySQL in safe mode with networking disabled (sudo mysqld_safe --skip-grant-tables --skip-networking &<\/code>), 3)<\/strong> Connect without password (mysql -u root<\/code>), 4)<\/strong> Run FLUSH PRIVILEGES;<\/code> and ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword123!';<\/code>, and 5)<\/strong> Kill safe mode and restart the normal MySQL service.\n <\/p>\n<\/div>\n

Why Root Password Lockouts Happen on Linux VPS<\/h2>\n

Losing the MySQL root administrative password blocks all database provisioning, phpMyAdmin root logins, and WP-CLI administration. Fortunately, Linux allows system administrators with root SSH access to bypass the user privilege table safely and assign a new administrative credential.<\/p>\n

Step-by-Step Root Password Reset Procedure<\/h2>\n

Step 1: Stop the Running MySQL Daemon<\/h3>\n
sudo systemctl stop mariadb  # or sudo systemctl stop mysql<\/pre>\n
Step 2: Start MySQL in Safe Mode (Bypass Permissions)<\/h3>\n
Use the --skip-networking<\/code> flag to ensure external hackers cannot connect while authentication is disabled:<\/p>\n
sudo mysqld_safe --skip-grant-tables --skip-networking &<\/pre>\n
Step 3: Connect to MySQL Shell Without Password<\/h3>\n
mysql -u root<\/pre>\n
Step 4: Reload Privileges and Update Root Password<\/h3>\n
Inside the MySQL\/MariaDB command prompt, execute the following SQL commands:<\/p>\n
FLUSH PRIVILEGES;\n\n-- For MySQL 8.0 \/ 8.4:\nALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourNewStrongPassword123!';\n\n-- For MariaDB 10.4+:\nALTER USER 'root'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('YourNewStrongPassword123!');\n\nFLUSH PRIVILEGES;\nEXIT;<\/pre>\n
Step 5: Terminate Safe Mode and Restart Normal Service<\/h3>\n
# Kill safe mode daemon\nsudo killall -v mysqld\n\n# Start standard database service\nsudo systemctl start mariadb  # or sudo systemctl start mysql\n\n# Test login with new password\nmysql -u root -p<\/pre>\n
\n
\n        \ud83d\udd17<\/span> Recommended Related Technical Guides:
\n    <\/h3>\n