How to reset root password for mysql and phpmyadmin

0 votes
asked Dec 26, 2015 in Linux by 'Sercan Demir (1,330 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;
Ask a Question
Welcome to WikiTechSolutions where you can ask questions and receive answers from other members of the community.

You can ask a question without registration.