Pages

Wednesday, May 29, 2013

Changing password in phpmyadmin ubuntu 12.04

In the ubuntu console type the following one by one

sudo /etc/init.d/mysql stop
sudo mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD("mynewpassword") where User='root';
flush privileges;
quit

No comments: