GNU/Linux CentOS 7 Reset MySQL/MariaDB Root Password

February 21, 2020 | By the+gnu+linux+evangelist.

Reset MySQL/MariaDB 5.7+ root Password CentOS 7

Hi! The Tutorial shows you Step-by-Step How to Reset MySQL/MariaDB 5.7+ root User Password in CentOS 7.x GNU/Linux Desktop/Server.

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

How to Install MySQL Workbench in CentOS 7 - 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 CentOS 7 should be Successfully Solved! ;)


QuickChic Theme • Powered by WordPress