masuk ke terminal linux kemudian ketikan perintah seperti di baawah.
service mysql stop
service mariadb stop
mysqld_safe --skip-grant-tables &
UPDATE user SET password=PASSWORD('PASSWORD_BARU') WHERE user='root';
FLUSH PRIVILEGES;
CREATE NEW USER
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
Lalu restart service mariadb dan mysqlnya
service mysql start
service mariadb start
GET DUMP DATABASES
mysqldump -u root db > save.sql --routines
Tutorial For All 