***Kunjungi WEB kami***

ikhwansaputera.com Semua Bisa Dengan Belajar

Cara Reset root Password untuk MySQL 5.7 di Ubuntu 16.04 LTS

03.16.2017 · Posted in Home
sudo /etc/init.d/mysql stop
sudo mkdir /var/run/mysqld/
sudo chown mysql /var/run/mysqld/
sudo mysqld_safe --skip-grant-tables &
mysql -uroot
use mysql;
update user set authentication_string=PASSWORD("NEW_PASSWORD_GOES_HERE") where User='root';
flush privileges;
quit;
sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start

Leave a Reply