***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, Linux

[ sourcecode language=”php” ]

sudo /etc/init.d/mysql stop
sudo mkdir /var/run/mysqld/
sudo chown mysql /var/run/mysqld/
sudo mysqld_safe skipgranttables &
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

[/sourcecode]

Leave a Reply