Debian 8 reset root password MySQL

Updated . Posted . Visible to the public.
# /etc/init.d/mysql stop 
# mysqld_safe --skip-grant-tables 
# mysql -u root 
mysql> use mysql;
mysql> update user set password=PASSWORD("new_password") where User='root'; 
mysql> flush privileges;
mysql> quit; 
# /etc/init.d/mysql stop 
# /etc/init.d/mysql start
Profile picture of L3UNIX
L3UNIX
Last edit
L3UNIX
Posted by L3UNIX to L3UNIX's deck (2016-07-25 14:39)