This is a very common problem for people using versions of Ubuntu Linux. Usually you install the MySQL server using Apt or Synaptic Package Manager and they setup packages without asking you for a root password. Then you realize that there a bunch of solutions for this problem, but none of them gives you a full, step by step description how to reset the root password. This is really very easy to do and I’ll tell you how.
Continue reading »

After installing the Postgres on my machine I had some issues regarding it’s connections through sockets. So after a long time of trying to configure correctly I’ve finally gave up and started from scratch. Here is a good post of how to install it (in russian): http://lug.nsk.ru/lugnskru/2010/10/ustanovka-postgresql-9-pgadmin-iii-v-ubuntu-10-04.html. So the steps were the following (for those who don’t know russian). Continue reading »