Page 1 of 1

Cannot connect to localhost after configuring config.inc.php

Posted: Thu Jun 01, 2006 6:23 pm
by ix6tech
Here is a really strange issue when i try to running netjukebox.

I installed the required apps needed for this script.

Currently running:

Apache 1.3.35 (Win32)
PHP 4.4
MySQL 4.1

When i go to run the script after i have installed everything the script has trouble connecting to localhost on mysql.

Here is what i has set up so far in the config.inc.php:

// +---------------------------------------------------------------------------+
// | MySQL configuration |
// +---------------------------------------------------------------------------+
$cfg['mysql_host'] = 'localhost';
$cfg['mysql_db'] = 'netjukebox';
$cfg['mysql_user'] = 'root';
$cfg['mysql_password'] = 'test';


Now this is a test database i setup in mysql.

If in not mistake the mysql username is suppose to be the login name for the pc in windows which i have set as root with administrative privledges.
I have left the mysql_host as localhost
I created the database netjukebox
I setup mysql password to be test

Once i did this i added this in the script and still come up with the cannot connect to mysql on: localhost.

Is there anything that i may be doing wrong with the configuration of mysql or with the config.inc.php that im missing when running this on windows?

Any help on this would be greatly appreciated.

Thanks,

Chris

Posted: Thu Jun 01, 2006 7:23 pm
by wbartels
MySQL 4.1+ uses a new SHA1 password hash witch is not compatibel with the PHP 4.x MySQL clients,
here you can find a workaround: http://www.billkatz.com/node/10
Or install MySQL 4.0.x

Good luck,

Willem