Yes. You read the title right. I was just playing around with my new server setup using Zend Server CE which was supervised and administered by Crynobone. Then, I reached to the common MYSQL backend – the famous PhpMyAdmin. The system alert that my root access was not secured and need a password.

As what you expected, I dig around, trying to setup the password for my root access. I found it somewhere. Unfortunately, there were about 3 users with the same username: root. Then, I changed the password. Guess what,

I BRICKED MY ROOT ACCESS.

After watching how Crynobone doing the setup for my Zend Server CE, I took interest with the power or Terminal (Mac/Linux). I started to dig and Google around to read how to use the mysql with Terminal, where to access the Zend’s MySQL database and functions. After a lot of try-and-error, I managed to display this information within my Terminal:

As you can see, I have 3 types of host using the same user: root and all of them have the same password. I guessed that this might be the reason why the system can’t create my access cookies/session. Having minimal knowledge on MySQL code and functions, I reseted all user: root with no password. Or you can call it the original status of the table.

AND I’M BACK INTO THE GAME. I RECLAIM MY ACCESS.

Haha. So, that is my story for today. As a noob in the web development world, I faced a lot try-and-error and a lot of experimentation in order to learn something and today I’ve learn something powerful: using mysql from Terminal.

I rest my case.