This is what I ran into while installing Joomla! on Ubuntu

I was trying to install Joomla! on my Ubuntu box and ran into this error when I tried to install libapache2-mod-php5:

Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.

Since you only requested a single operation it is extremely likely that
the package is simply not installable and a bug report against
that package should be filed.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
libapache2-mod-php5: Depends: php5-common (= 5.2.1-0ubuntu1) but 5.2.1-0ubuntu1.2 is to be installed
E: Broken packages


I googled for possible fixes but couldn't find any. So, out of desperation, I tried the following:


sudo apt-get update
sudo apt-get install libapache2-mod-php5


It worked. But, I sure as hell don't know why. Sometimes, I can't help but think that apt-get is a bit retarded -OR- maybe it's just me.

What to do if you forget your MySQL admin password

1) run mysql daemon with these options:


sudo /usr/sbin/mysqld --skip-grant-tables --user=root


2) run mysql client and enter the following commands:

mysql> USE mysql
mysql> UPDATE user SET password=password("mysqlpass*0987") WHERE user="root";
mysql> flush privileges;
mysql> exit


3) restart mysql

A more complete explanation is found here