"problem with the mysql server"

Guest

Windows
Apache2
MySQL 4.1

The database is there and populated. I can run querys against the database from a command line on the webserver by using the credentials listed in the config.php file.

Just to be sure I blew away the database and recreated it.

the config.php file is correct:

$dbhost = "10.16.114.3";
$dbuname = "xxx";
$dbpass = "xxx";
$dbname = "nuke";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "xxxx";
$gfx_chk = 0;
$subscription_url = "";
$admin_file = "admin";
$advanced_editor = 0;

Now if i change "mysql" to "mysql4" i get blank pages.

Please help!

Posted: Wed Sep 07, 2005 2:49 am

if the MySQL Server is on the same machine as the web server, then the $dbhost is normally localhost.

Guest

I have tried that as well, it makes no diffrence.

I am pretty sure it is a bug in 7.7, it does not seam to like 4.1.

Posted: Wed Sep 07, 2005 6:36 am

Sorry...I didnt realise you had MySQL 4.1. When I first installed MySQL 4.1, I had problems with passwords.

If you install MySQL 4.1, also install the MySql administrator. Next in MySQL Administrator, open the MySQL Command line client and run the following command:

Code:

SET PASSWORD FOR username@localhost = OLD_PASSWORD('password');

where username is the username you are going to use and password is the password you are going to use. That sorted out password problems for me.