Kubuntu 18.04 How to Reset MySQL 5.7+ root Password

April 24, 2019 | By thelinuxevangelist | Filed in: Tutorial.

Reset MySQL 5.7+ root Password Kubuntu 18.04

You Are Welcome! The Tutorial Shows You Step-by-Step How-to Reset MySQL 5.7+ root User Password in Kubuntu 18.04 Bionic LTS GNU/Linux Desktop/Server.

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

How-to Install MySQL Workbench in Kubuntu 18.04 Bionic LTS - 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
  8. And with this your Issue of Resetting MySQL 5.7 Pass on Kubuntu 18.04 should be Successfully Solved! ;)


Tags: ,