Reset MySQL Database root Password by Editing Configuration Files

Sometimes, there is a need or emergency circumstance involved an action to reset MySQL Database Server’s root account. One of those days are accidentally forgot the password of root account so that the account cannot be used normally to connect, to login or to access MySQL Database Server. And there are also many things can trigger the cause for a quick decision to reset MySQL Database Server’s password for the root account.

One way or another, this article doesn’t have any malicious intent or any bad purposes presenting method or way to reset someone else’ root account of his or her MySQL Database Server. The intention is to help fellow database administrator whom trapped in a situation explained previously. This is the detailed steps :

1. Either locally or remotely located, first of all access the server where the MySQL Database Server is located.

Continue reading “Reset MySQL Database root Password by Editing Configuration Files”