How to reset root password for mysql and phpmyadmin

0 votes
38 views
asked Dec 27, 2015 in Linux by 'Sercan Demir (980 points)
how to reset?

1 Answer

0 votes
answered Dec 27, 2015 by anonymous
mysqld_safe --skip-grant-tables

mysql --user=root mysql

mysql-> update user set Password=PASSWORD('newpass') where user='root';

mysql-> flush privileges;

mysql-> exit;
...