Ada kalanya mungkin kita lupa password root mysql di vps kita 😀 Nah ini dia caranya buat reset password root mysql kita 😉 Check it out yachhh…..
Stop the MySQL Server.
1 |
sudo /etc/init.d/mysql stop |
Start the mysqld configuration.
1 |
sudo mysqld --skip-grant-tables & |
Login to MySQL as root.
1 |
mysql -u root mysql |
Replace YOURNEWPASSWORD with your new password!
1 |
UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit; |
Done !!