PHP MySQL support not enabled?

Posted by gaga on May 4, 2006 at 10:17am

Hi!

I have a strange problem. Trying to install Drupal according to the installing movie I come to the point where in the movie everything is fine and my drupal installation throws a error:

PHP MySQL support not enabled

We were unable to use the MySQL database because the MySQL extension for PHP is not installed. Check your PHP.ini to see how you can enable it.

For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.

The funny thing is, that on the same apache server I have running SquirrelMail (written in PHP and using the MySql database, just another schema than Drupal).

The link on the message (to the installation handbook) does not go to the section about modifying the PHP.ini and I can not find anything disabled in the PHP.ini (I don't think that there is something disabled, because Squirrelmail runs quite good).

Anybody an idea?

PHP version: 5.1.3
MySQL version: 5.0.21-win32
Apache: 2.0.58-win32-x86-ssl

Many thanks in advance,

Anton Trapp

Comments

MySQLi

Posted by Heine on May 4, 2006 at 10:41am

Did you try mysqli or mysql?
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

--
The Manual | Troubleshooting FAQ | Tips for posting | How to report a security issue.

MySql or MySqli

Posted by gaga on May 4, 2006 at 11:38am

both :(

yet another solution

Posted by dreamlusion on May 2, 2007 at 12:15am

I came across the same problem. The solution to my problem came out to be copying
libmysql to my windows directory. Grab more info here:

http://www.phpbuilder.com/board/archive/index.php/t-10283695.html

MySQL in PHP5

Posted by dblerner on May 11, 2006 at 12:03am

I was having the same problem. Here's the solution:

1) Make sure that your PHP directory is in your system path (c:\php)
2) Comment out the "extension=php_mysql.dll" in your php.ini
3) Specify the the following path in [extension_dir = "c:\php\ext"]

I hope this helps.

Debian GNU/Linux solution

Posted by jogness on May 11, 2006 at 7:01pm

Hi,

I had the same problem (but with Debian GNU/Linux (stable)). In order to fix it, I needed to add the following lines to my php.ini file:

extension=mysql.so
extension=mcrypt.so

and then restart Apache. This might not solve your problem, but at least it will help out the next Debian user that runs into the same problem I had.

This problem arises when you install Apache *after* PHP. If I had installed Apache first, then the PHP installation would have automatically updated the php.ini for me. For Debian, you can re-configure the PHP package with:

# dpkg-reconfigure php4-mysql

This will add the lines shown above. But then don't forget to forget to restart Apache afterwards.

> I was having the same

Posted by bradleyconnor on September 5, 2006 at 8:32am

> I was having the same problem. Here's the solution:
>
> 1) Make sure that your PHP directory is in your system path (c:\php)
> 2) Comment out the "extension=php_mysql.dll" in your php.ini
> 3) Specify the the following path in [extension_dir = "c:\php\ext"]
>
> I hope this helps.

I'm having the same problem, did as above, yet still having the issue ... Any ideas?

*I just read something about recompiling or reconfiging the php installation?

Rebooting the machine solves the problem

Posted by alpha0 on March 11, 2008 at 9:09pm

May be because it adds c:\PHP to the path and libmysql.dll has to be in the path.

I just rebooted the machine after installing php with mysql. It worked.