Sitee.in

Get A responsive website for Free , mobile-first projects on the web.

How to reset phpmyadmin password in ubuntu

By : sourabh

2016-02-23 16:49:49

How to reset phpmyadmin password in ubuntu

How to reset phpmyadmin password in ubuntu ?

Change or reset your MySQL root password in terminal ubuntu:

1.Stop the MySQL server
sudo service mysql stop

2.Start mysqld
sudo mysqld --skip-grant-tables &

3.Login to MySQL as root
mysql -u root mysql

4.Change MYSECRET with your new root password
UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;

5.Kill mysqld
sudo pkill mysqld

6.Start mysql
sudo service mysql start

--

Comment*
Website
Name*
Email*

*Required Field.

© 2015 blog.sitee.in