GNU/Linux Reset MySQL/MariaDB root Password

October 29, 2020 | By the+gnu+linux+evangelist | Filed in: Tutorial.

GNU/Linux Reset MySQL/MariaDB 5.7+ root Password

Hi! The Tutorial Shows You Step-by-Step How to Reset MySQL/MariaDB 5.7+ root User Password in GNU/Linux Desktop/Server.

And I’ve tried to Reset MySQL root Pass on Linux in many Ways but this was the Only one Working Solution!

How to Install MySQL Workbench in - Featured
  1. Stop MySQL Server

    sudo service mysql stop
    Or in case:
    sudo service mariadb stop
  2. Make the Needed Directory

    sudo mkdir /var/run/mysqld

    And Set mysql as User

    sudo chown mysql: /var/run/mysqld
  3. Start mysqld_safe

    sudo mysqld_safe --skip-grant-tables --skip-networking &
  4. Login into MySQL without Pass
    Open a New Window or Demonize the process with Ctrl+c:

    mysql -uroot mysql
  5. Setting New Pass

    UPDATE mysql.user SET authentication_string=PASSWORD('YOUR-NEW-PASS'), plugin='mysql_native_password' WHERE User='root' AND Host='localhost';
    FLUSH PRIVILEGES;

    Change “YOUR-NEW-PASS” in the Above…
    And then “Ctrl+c” to Quit MySQL.

  6. Kill mysqld Process

    sudo pkill mysqld
    But you may need to find out the mysqld process with:
    ps ax | grep mysqld
    And then use the process ID to kill it as Eg.:
    sudo kill -9 166394
  7. Restart MySQL/MariaDB Server

    sudo service mysql start
    Or:
    sudo service mariadb start

And with this your Issue of Resetting MySQL 5.7 Pass on Linux should be Successfully Solved! ;)


QuickChic Theme • Powered by WordPress