Sometime you need to reset MySQL password on a server you have root access to. Here’s a step-by-step how-to to accomplish this task on a CentOS 6 server.