Lets go direct onto the commands which will reset our mysql database root password, Please run all commands as root We assume that you have your linux server running with root access
# systemctl stop mysql # mysqld_safe --skip-grant-tables & # mysql> # UPDATE mysql.user SET Password=PASSWORD('NEW-PASSWORD') WHERE User='root'; # FLUSH PRIVILEGES; # EXIT # systemctl start mysql
Run all commands as root