phpmyadmin - My password root caused disappearance in Mysql database

Question

I set a password for the user root manually in the phpmyadmin, and suddenly the mysql database disappeared from the list. When I use the control console, the root user can connect without a password, but the command line show database doesn't display the mysql database.

Answer 1

If you control your MySQL server, you can temporarily restart it without security. See http://docs.phpmyadmin.net/en/latest/faq.html?highlight=root%20password#i-have-lost-my-mysql-root-password-what-can-i-do