MySQL Recover/Reset Lost/Forgotten root Password

One note is to secure MySQL, I don't know for sure but I believe you could login to MySQL remotely with no password during this operation (I'm not sure, maybe it doesn't accept blank passwords but I firewall MySQL port anyway and recommend you do the same).

First edit /etc/my.cf

Under the [mysqld] field add the following line somewhere:

skip-grant-tables

Now restart mysql: service mysql restart or on Debian style systems: /etc/init.d/mysqld restart

You can now login to mysql as root with no password.

mysql -u root

Enter the following commands (you can copy and paste below, remember to change "YOURNEWPASSWORD" to whatever you want the password to be.

use mysql;
UPDATE user SET password=password("YOURNEWPASSWORD") WHERE user='root';
flush privileges;
quit

*Note more note is that if you are using Plesk, the root user is probably called/renamed "admin" so you'll need to replace everything above with "admin" if that's the case.  Of course an easier way if Plesk is actually running is to use the Forgot Password function of the Control Panel itself.


Tags:

mysql, reset, passwordone, login, remotely, password, doesn, passwords, firewall, edit, etc, cf, mysqld, restart, debian, init, commands, quot, yournewpassword, update, user, flush, privileges, plesk, renamed, admin, ll, panel,

Latest Articles

  • Debian Ubuntu Mint Howto Create Bridge (br0)
  • How To Control Interface that dhcpd server listens to on Debian based Linux like Mint and Ubuntu
  • LUKS unable to type password to unlock during boot on Debian, Ubuntu and Mint
  • Debian Ubuntu and Linux Mint Broken Kernel After Date - New Extra Module Naming Convention
  • Wordpress overwrites and wipes out custom htaccess rules and changes soluton
  • Apache htaccess and mod_rewrite how to redirect and force all URLs and visitors to the SSL / HTTPS version
  • python 3 pip cannot install mysql module
  • QEMU-KVM won't boot Windows 2016 or 2019 server on an Intel Core i3
  • Virtualbox vbox not starting "No suitable module for running kernel found"
  • Bind / named not responding to queries solution
  • Linux Mint How To Set Desktop Background Image From Bash Prompt CLI
  • ImageMagick Convert PDF Not Authorized
  • ImageMagick Converted PDF to JPEG some files have a black background solution
  • Linux Mint Mate Customize the Lock screen messages and hide username and real name
  • Ubuntu/Gnome/Mint/Centos How To Take a partial screenshot
  • ssh how to verify your host key / avoid MIM attacks
  • Cisco IP Phone CP-8845 8800/8900 Series How To Reset To Factory Settings Instructions
  • ls how to list ONLY directories
  • How to encrypt your SSH private key file id_rsa
  • Linux Mint 18 Disable User Name List from showing on Login Screen