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

  • Ubuntu Debian Linux Cannot Install Wine Solution - wine1.6 : Depends: wine1.6-i386 (= 1:1.6.2-0ubuntu14.2) but it is not installable wine1.4 : Depends: wine1.6 but it is not going to be installed
  • How To Install python 3.4 3.5 and up on Linux with wine - Working Solution
  • using Xvfb on virtual remote ssh server to have X graphical programs work
  • ssh Received disconnect from port 22:2: Too many authentication failures
  • named bind errors - DNSKEY: unable to find a DNSKEY which verifies the DNSKEY RRset and also matches a trusted key for '.'
  • OpenVZ vs LXC DIR mode poor security in LXC
  • httpd: Syntax error on line 221 of /etc/httpd/conf/httpd.conf: Syntax error on line 6 of /etc/httpd/conf.d/php.conf: Cannot load modules/libphp5.so into server: /lib64/libresolv.so.2: symbol __h_errno, version GLIBC_PRIVATE not defined in file libc.s
  • Radeon R3 GPU on Debian Crashing
  • MySQL 5.7 on Debian and Ubuntu - How To Reset Root Password
  • SSH and sshfs timeout settings keepalive
  • Linux How To Add User To Additional Group
  • Howto Set Static IP on boot in initramfs for dropbear or other purposes NFS, Linux, Debian, Ubuntu, CentOS
  • Convert and install to LUKS Encrypted Drive Ubuntu 18.04 19.10 Linux Mint and Debian Based Linux
  • Debian and Netplan
  • CentOS 8 how to restart the network!
  • CentOS 8 how to convert to a bootable mdadm RAID software array
  • ADATA USB Thumb Drive Issues
  • KMODE EXCEPTION NOT HANDLED - QEMU/KVM Won't Boot Windows 2016 or 10 Image or Physical Machine
  • Linux Mint / Ubuntu / Debian Mate Disable Guest Session and Hide Usernames on Lightdm Login screen GUI
  • SSH How To Create Public/Private Key Pair and with a Larger Keysize than 2048 bits