SugarCRM installation error “MySQL not available”

While moving a SugarCRM installation to a different server I found this problem – “MySQL not available”. Firstly I had a blank page and then decide to re-run the installation script. During the system check it listed MySQL as not available, so I checked for the status of the mysql server and it was running. (as root – /etc/init.d/mysql status)

This problem is caused by PHP not being able to talk to the MySQL server. Here are some simple steps that can help you resolve this.

1 – add the line extension=mysql.so to the end of your php.ini ( found under /etc/php5/apache2)

2 - restart the apache server – /etc/init.d/apache2 restart

This should resolve your problem but if it does not, like in my case, the php-mysql extension is missing so you need to install it.

3 – in a Debian based distro (Like Ubuntu) just use apt-get install php-mysql to install it (as root or use sudo before the command)

4 – restart the apache server – /etc/init.d/apache2 restart

This is it!

Technorati Tags: SugarCRM, MySQL Error, php-mysql