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.
sudo /etc/init.d/mysql stop
Start the mysqld configuration.
sudo mysqld --skip-grant-tables &
Login to MySQL as root.
mysql -u root mysql
Replace YOURNEWPASSWORD with your new password!
UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;
Done !!
More Stories
Auto Restart Mysql / MariaDB Using Monit In Ubuntu With EasyEngine
Allow user to edit and add files to /var/www
Install HHVM + NGINX with PHP-FPM as a fallback To Speed Up Your WordPress On Ubuntu 14.04