Could not get lock /var/lib/dpkg/lock - open (11 Resource temporarily unavailable)

I was in Putty and was in the middle of installing a package via apt-get (where I was installing mysql-server and I was in the part of setting the password) when suddenly my connection dropped. When I returned back I tried re-typing my installation command to make sure that my installation went fine.

But, to my surprised, I got the said error every time I tried to create an installation.

E: Could not get lock /var/lib/dpkg/lock - open (11 Resource temporarily unavailable)
E: Unable to lock the administration directory (/var/lib/dpkg/)

Consulting the Blue Space

Based on what I have read on the net (correct me if I am wrong with this), it seems dpkg was locked every time an installation occurs and since my process didn't ended properly it was left locked.

Solution the net suggested

It seems that the only solution would be removing those locks manually.

sudo rm -f /var/lib/dpkg/lock
sudo rm /var/lib/apt/lists/lock
sudo rm /var/cache/apt/archives/lock

I did try the installation again and it returned an error again:

debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable

To resolve this, I rename all the *.dat files inside the /var/cache/debconf. I said all since renaming just config.dat will just bring you up another error pointing to the other .dat files inside there.

After renaming, installation should now be fine and should continue.