Warning: ob_start(): output handler 'ob_gzhandler' conflicts with 'zlib output compression' in /home/wikitech/public_html/qa-include/qa-index.php on line 177

Notice: ob_start(): failed to create buffer in /home/wikitech/public_html/qa-include/qa-index.php on line 177
How to reset root password for mysql and phpmyadmin - wikiTechSolutions

How to reset root password for mysql and phpmyadmin

0 votes
51 views
asked Dec 27, 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.
...