Day: November 25, 2019

Cara Reset Passwd Mysql server yang lupa

~ suji2019 ~ Leave a comment

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