Contekan reset password mysql di ubuntu

Script Ubuntu :

sudo systemctl stop mysql

sudo systemctl set-environment MYSQLD_OPTS="--skip-networking --skip-grant-tables"

sudo systemctl start mysql

sudo mysql -u root


Script MYSQL :

mysql> flush privileges;

mysql> use mysql;

mysql> ALTER USER  'root'@'localhost' IDENTIFIED BY 'password_baru';

mysql> flush privileges;

mysql> quit;


Script Ubuntu lagi :

sudo systemctl unset-environment MYSQLD_OPTS

Komentar

Postingan populer dari blog ini

Contekan datatable untuk mengatasi pagination reset ketika reload