$schemamarkup = get_post_meta(get_the_ID(), 'schemamarkup', true); if(!empty($schemamarkup)) { echo $schemamarkup; }

Ubuntu 18.04 Reset MySQL/MariaDB Root Password

April 24, 2019 | By the+gnu+linux+evangelist.

Reset MySQL/MariaDB 5.7+ root Password Ubuntu 18.04

Hi! The Tutorial shows you Step-by-Step How to Reset MySQL/MariaDB 5.7+ root User Password in Ubuntu 18.04 Bionic LTS GNU/Linux Desktop/Server.

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

How to Install MySQL Workbench in Ubuntu 18.04 Bionic LTS - Featured
  1. Stop MySQL Server.

    Copy
    sudo service mysql stop
  2. Make the Needed Directory.

    Copy
    sudo mkdir /var/run/mysqld

    And Set mysql as User:

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

    Copy
    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:

    Copy
    mysql -uroot mysql
  5. Setting New Pass.

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

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

  6. Kill mysqld Process

    Copy
    sudo pkill mysqld
  7. Restart MySQL Server.

    Copy
    sudo service mysql start
  8. And with this your Issue of Resetting MySQL 5.7 Pass on Ubuntu 18.04 should be Successfully Solved! ;)