{"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-12T12:45:04","modified_gmt":"2026-09-12T07:15:04","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

\n \u23f1\ufe0f 4 min read (877 words)<\/span>
\n \ud83d\udee1\ufe0f Verified on Ubuntu 24.04 \/ Debian 12<\/span>
\n \ud83d\udd04 Updated for 2026 Edition<\/span>\n<\/div>\n

<\/p>\n

\n
\n
\n \ud83d\udcd1<\/span> Table of Contents\n <\/div>\n

Guide Index<\/span>\n <\/div>\n

\n 1<\/span>Why Root Password Lockouts Happen on Linux VPS<\/span>›<\/span><\/a>2<\/span>Step-by-Step Root Password Reset Procedure<\/span>›<\/span><\/a>3<\/span>Fixing Authentication Plugin Mismatches (auth_socket vs mysql_native_password)<\/span>›<\/span><\/a>4<\/span>Securing MySQL Daemon with mysql_secure_installation<\/span>›<\/span><\/a>5<\/span>Resetting MySQL Root Password on cPanel & WHM Servers<\/span>›<\/span><\/a>6<\/span>Configuring ~\/.my.cnf for Passwordless Root CLI Administration<\/span>›<\/span><\/a>7<\/span>Frequently Asked Questions<\/span>›<\/span><\/a>8<\/span>Troubleshooting Access Denied for User ‘root’@’localhost’<\/span>›<\/span><\/a>\n <\/div>\n<\/div>\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

<\/p>\n

\n
\n
\n \u26a1 Executive Summary & Key Takeaways
\n <\/span>
\n Verified Guide<\/span>\n <\/div>\n