getting an error when trying to install.

[PILMAN]

I downloaded the trial version of WHMCS as I want to see how it is before I purchase it. I am getting an error for some reason about my MYSQL database. I actually recompiled my apache to install CURL before hand because I didn't have it.

 

When I try to do the install, I get the error

 

Could not connect to the database - check the database connection details you entered and go back and correct them if necessary

 

my MYSQL information is correct, I triple checked.

 

everything is CHMOD correctly as well.

 

Any ideas?

[urevised]

Double check with your web host that the database connection information is correct. There is only 1 way that this error occurs and that is through incorrect database login details or the mysql server being down.

 

Hope this helps

[PILMAN]

Double check with your web host that the database connection information is correct. There is only 1 way that this error occurs and that is through incorrect database login details or the mysql server being down.

 

Hope this helps

 

I am the server administrator, there is nothing wrong with the database details. Also all other scripts using my MYSQL database work fine.

[RPS]

Copy of the information you have entered into the following script and test the output.

 

<?php
mysql_connect("localhost", "mysqladminUsername", "mysqladminPassword") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("mysqlDatabase") or die(mysql_error());
echo "Connected to Database";
?>

[bear]

Did you remember to not only create the DB user but to give them the proper permissions to access the DB?

[PILMAN]

Did you remember to not only create the DB user but to give them the proper permissions to access the DB?

 

Yes, they have full permissions. It's the same procedure I have done for other MYSQL scripts.

[PILMAN]

Copy of the information you have entered into the following script and test the output.

 

<?php
mysql_connect("localhost", "mysqladminUsername", "mysqladminPassword") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("mysqlDatabase") or die(mysql_error());
echo "Connected to Database";
?>

 

 

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/data/public_html/test.php on line 2

Client does not support authentication protocol requested by server; consider upgrading MySQL client

[RPS]

Problem is NOT with WHMCS.

 

That simple php code should connect to MySQL to verify it is working, and then connect to the database and verify the database exists and is accessible via the mysql username entered.

 

Check this out: MySql >= 4.1 Client does not support authentication protocol...

[PILMAN]

Problem is NOT with WHMCS.

 

That simple php code should connect to MySQL to verify it is working, and then connect to the database and verify the database exists and is accessible via the mysql username entered.

 

Check this out: MySql >= 4.1 Client does not support authentication protocol...

 

Yes it appears you are right, looks like when I recompiled Apache, a number of my scripts stopped working (not able to connect to MYSQL database). My PHPNUKE and Modernbill still work but some of my store scripts and Joombla no longer work...

[PILMAN]

Getting a different error now.

 

Connected to MySQL

Access denied for user 'data_invoice'@'localhost' to database 'data_invoice'

[twilightwebdesign]

Add the mysql user to your mysql database

[PILMAN]

Add the mysql user to your mysql database

 

The user was already added to the database.

[RPS]

Either looking at a permission issue or incorrect password...

[JasonO]

Make sure the user is privileged under that particular database - else it will still say denied.