Reset Password Root MySQL 5.7 Ubuntu 16.04

1. Login ssh, harus punya akses sudo
2. Matikan MySQL

sudo /etc/init.d/mysql stop

3. Buat Direktori mysqld dan atur owner

sudo mkdir -v /var/run/mysqld && sudo chown mysql /var/run/mysqld

1. Hidupkan kembali mysqld
   sudo mysqld — skip-grant-tables — user=root &
2. Masuk ke shell MySQL
   mysql -u root mysql
3. Ganti PasswordBaruku sesuai kebutuhan (MySQL 5.7)
   UPDATE mysql.user SET Password = PASSWORD(‘PasswordBaruku’) WHERE User = ‘root’;
   FLUSH PRIVILEGES;
   exit;
4. Jika query error (password column doesn't exist,)
   UPDATE user SET authentication_string=password('YOURNEWPASSWORD') WHERE user='root';
5. Khusus MySQL 8 ke atas
   ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘PasswordBaruku’;