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