GNU/Linux CentOS 8 Reset MySQL/MariaDB root Password

February 21, 2020 | By the+gnu+linux+evangelist | Filed in: Tutorial.

Reset MySQL/MariaDB 5.7+ root Password CentOS 8

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

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

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

    sudo service mysql 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…

  6. Kill mysqld Process

    sudo pkill mysqld
  7. Restart MySQL Server

    sudo service mysql start

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


Tags: , , ,