• Registered: 2007-05-28
  • Posts: 317

Topic: Fix MySQL Connection for PHP 5.3.x

Symptoms

  • Some applications connect connect correctly to the MySQL database server anymore.

Applies to: MoWeS Portable II, all PHP packages greater 5.3.0

Cause

  • After PHP 5.3.0 the IP resolution was changed. When using "localhost" instead of "127.0.0.1" as MySQL server PHP cannot connect anymore the MySQL server.

Resolution
Use "127.0.0.1" instead of "localhost" as database server in any application. Yet, some MoWeS packages have not been updated hence there is still "localhost" used. You need to fix this manually in the application configuration file.

  • Open the Windows Explorer and goto the www directory.

  • Switch to the application directory that is not working correctly anymore.

  • Look for a file that is called "config.inc.php", "settings.inc.php", "config.php" or similar.

  • Open this file in a text editor (e.g. Notepad)

  • Look for a line that says something like

$dbServer = "localhost";

  • Change this line to 

$dbServer = "127.0.0.1";

  • Save the changes. Everything should work fine now.

CH Software's Website