Reset Password Mysql di Ubuntu

Stop the MySQL server.

#/etc/init.d/mysql stop

#mysqld –skip-grant-tables –skip-networking &

# mysql mysql -u root

>UPDATE user SET password=PASSWORD(‘newpassword’) WHERE user=”root”;

>FLUSH PRIVILEGES;

#/etc/init.d/mysql restart

FLUSH PRIVILEGES;
alioke Avatar

Leave a Reply

Liyana Parker

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.