Ghosts from the past visit the now, and I’m not talking about a horror here. Recently, I had learned something from Cpanel that I had no idea before. If you’re unfamiliar with Cpanel, I suggest you google it! Back to the main course, I logged into Cpanel and noticed that the MySQL databases I had deleted eon ago repopulated inside Cpanel. I pulled my hair, googled everywhere, but I couldn’t find the source of the souls of these supposed to be dead databases. Luckily, I called up a person who knew much more about ghosts of the past of MySQL/Cpanel, and he showed me the way.
It turned out, even though inside PHPMyAdmin and /var/lib/mysql, the ghosts of the past did not repopulated, and it supposed to be that way — this gave me an idea that everything had been normal besides the fact that the ghosts of the past of dead databases had repopulated within Cpanel. The person I called up figured it out and told me that inside directory /var/cpanel/databases/, there would be two files that I could take a look at. One would start with username.cache (replace username with a real account’s username) and the other would start with username.yaml (replace username with a real account’s username).
It turned out he was corrected. The ghosts of the past of MySQL turned out to be just a list of lost souls who’s silhouettes refused to leave the living world. Anyway, I deleted the list of dead databases in those two files, and my Cpanel is perfect again. If you still don’t know why I had wanted to get rid the ghosts of the past, I’ll tell you so… it’s because I do not want every time I get into Cpanel’s MySQL section and I have to wait for Cpanel to recall all the ghosts of the past; it takes a long time you know? Also, it can be very confusing by staring at the ghosts of the past, fearing of getting lost among them.
So, take a look at my report here and get rid of yours before Halloween once again returns!