Hi, I'm trying to set up MySQL 5.0.13 on my Windows XP system using Apache 2.0.55 server and PHP 5.0.5.
I configured PHP to work with Apache, but it doesn't seem to detect MySQL. When I access the phpinfo.php page MySQL isn't in the list, and when I open phpMyAdmin, it tells me it "cannot load mysql extension."
On the official PHP (http://www.php.net/mysql) it gives the following configuration instructions for MySQL and PHP 5+:
Can anyone help me get MySQL working? Thanks in advance!
I configured PHP to work with Apache, but it doesn't seem to detect MySQL. When I access the phpinfo.php page MySQL isn't in the list, and when I open phpMyAdmin, it tells me it "cannot load mysql extension."
On the official PHP (http://www.php.net/mysql) it gives the following configuration instructions for MySQL and PHP 5+:
So I follow their advice and set extension_dir = C:/www/php/ext/ (where php_mysql.dll is located) and copy "libmysql.dll" into the Windows folder, but the server still doesn't seem to recognize MySQL (it's not in phpinfo.php and phpMyAdmin gives me the error).MySQL is no longer enabled by default, so the php_mysql.dll DLL must be enabled inside of php.ini. Also, PHP needs access to the MySQL client library. A file named libmysql.dll is included in the Windows PHP distribution and in order for PHP to talk to MySQL this file needs to be available to the Windows systems PATH. See the FAQ titled "How do I add my PHP directory to the PATH on Windows" for information on how to do this. Although copying libmysql.dll to the Windows system directory also works (because the system directory is by default in the system's PATH), it's not recommended.
As with enabling any PHP extension (such as php_mysql.dll), the PHP directive extension_dir should be set to the directory where the PHP extensions are located. See also the Manual Windows Installation Instructions. An example extension_dir value for PHP 5 is c:\php\ext
Can anyone help me get MySQL working? Thanks in advance!