[RESOLVED] PHP Configuration problem

[seniseven]

I can't figure out what is going on with the PHP MySQL interface.
PHPMyAdmin won't work because it says it can't interact with MySQL.

I am looking at my php.ini and the web output of the phpinfo.php page.

The phpinfo.php clearly shows that ALL but the MySQL extension is enabled. Why?

More details below


There are five extensions shown enabled in php.ini are:

extension=php_curl.dll
extension=php_gd2.dll
extension=php_mbstring.dll
extension=php_mysql.dll
extension=php_openssl.dll

Now what does phpinfo.php report?

curl

• cURL support: enabled
• cURL Information: libcurl/7.21.0 OpenSSL/0.98t zlib/1.2.3

gd

• GD Support: enabled
• GD Version: bundled (2.0.34 compatible)
  [more records not shown]

mbstring

• Multibyte Support: enabled
• Multiybte string engine: libmbfl
  [more records not shown]

mysql

• ????? no table showing extension!!

openssl

• OpenSSL support: enabled
• OpenSSL Version: OpenSSL 0.9.8q 2 Dec 2010

[MarPlo]

Hi
I'm not sure about this, b ut somethimes the cause can be the firewall, or the port that should works with mysql is busy.
Try desactivate the firewall, and close other programms, or test with XAMPP too.

[criterion9]

Is the path to the used php.ini the same as the file you looked at to check for the extension?

[seniseven]

I'm not sure about this, b ut somethimes the cause can be the firewall, or the port that should works with mysql is busy. Try desactivate the firewall, and close other programms, or test with XAMPP too.

1. Turning off Windows Firewall did not have any effect
2. Shutting down the MySQL 5.5 service did not have any effect

Exceptions for php.exe and php_win.exe were added to the Windows Firewall

Is the path to the used php.ini the same as the file you looked at to check for the extension?

All the DLLs defined in the extension are in one path:

D:\PHP52\ext

The executables are in the parent D:\PHP52

PHP was installed outside of the normal program installation path.

Although 4 of the 5 extensions show in phpinfo.php, I am wondering if this is some sort of Windows "security" issue. Any suggestions regarding the unfathomable Windows security issues are welcome.

[criterion9]

I thought PHP 5.2+ came with mysql enabled by default? Did you do an installer or extract a zip or compile yourself?

[seniseven]

I recall it as an unzip.

If the msi installer makes registry entries in HKLM\Software\Microsoft\Windows\CurrentVersion\App Paths (all users) or HKCU\Software\Microsoft\Windows\CurrentVersion\App Paths (specific users), then I did not find them in my registry and thus the installer was not used.

[criterion9]

Did you add the install folder to your PATH environment variable?

[seniseven]

Did you add the install folder to your PATH environment variable?

That was missing.

Now the phpinfo.php script is hanging, timing out with server taking too long to respond.

CORRECTION: mysql extension now found in phpinfo.php

Marking this thread solved.

Thanks criterion9