Lorian

I know now that this is not a x64 issue. I have just had a new server built, clean install of Server 2003 R2 (x86), MySQL 5.0.27 and PHP 5.2. I create the database, create the user, assign it full permissions to the db and still get the same error The User/Pass combination connects fine if I use any other tool to connect to the db - it is only the WHMCS installer which doesn't like it. I do not use cPanel .. I simply want to use WHMCS as a CRM system, hence the instructions to put the cPanel username before the dbusername and dbhost do not apply.. Will open a support ticket. L

Just a note to voice my support for the inclusion of Protx as well. We use Protx for all payments so it will be a very welcome addition to WHMCS. L

I am fairly sure the Permissions are correct, I think you are spot on with the 64-bit assumption though - it's the only thing left that can be causing issues! Unless anyone else has successfully got WHM running on a x64 version of Windows Server? L

Thanks for the reply.. that's kind of the problem - everything else connects to it absolutely fine. MySQL Administrator, MySQL Query Browser, Command Prompt etc. Using the same specific database and User/Pass they all work without error. Yet I put that exact same info into the WHMCS Installer and it fails. Write permissions on the configuration.php file appear fine as the info does get written to it correctly. Looking at configuration.php I see an entry for cc_encryption_hash which doesn't appear in any PHP Installer for other software which works. Is it possible that this is causing a problem? L

Thank you for the advice guys. I have just tried backing up the working installation from the Dev server and restoring it into MySQL5 on the live server and the same issue occurs. MySQL is on the same server so I am using localhost. As you guys point out, it is definately an issue with connecting to MySQL - but it ONLY affects WHM. I have been setting up MySQL/PHP based websites for several years but this issue completely loses me. Today alone I have done installations of IPB, vBulletin and CS-Cart for clients which all involve setting up MySQL Databases and Users then running PHP installers and all work fine. I use the exact same procedure for WHM and it fails Any other suggestions anyone? L

I have completely uninstalled the x64 version of MySQL 5.0.24 and replaced it with the latest x86 version - 5.0.26. Unfortunately I still encounter the same issue. Web based PHP installers for other software I use can connect to the db fine using the details (IPB, vBulletin and CS-Cart all work fine) it appears only to be WHM which gives me the error. Could not connect to the database - check the database connection details you entered and go back and correct them if necessary Anybody got any other suggestions? WHM looks perfect and I really would like to get it working L

I know this may sound strange but we do not run cPanel as we have no need for it. I create databases and users manually on the server through MySQL Administrator. My interest in WHM stems from that fact that as far as I can see it is the cleanest looking and easiest to use Hosting Client Manager around. The installation on our Dev server has shown that it can do what we need it to do - ie we don't need cPanal to make use of WHM. Appreciate the help though! L

Thank you for the prompt response - yes the details are correct. As a test I tried installing a forum (IPB) to that database using the same details and it went through fine. I can also connect to the Databse through MySQL Administrator using those details without a problem. For the purposes of testing, the user has full permissions. L

Hi For the purposes of testing I installed WHMCS onto our dev server (MySQL4 & PHP4) and it works like a dream. However.. on our live server, which ultimately it would need to run on, I cannot get past Step 4 of the installation. As much as I hate to be one of those awkward people that uses the latest version of everything, this is our live server setup: Server 2003 x64 R2 MySQL 5.0.24 PHP 5.1.6 Attempting to intall on this simply returns a cannot connect to database error. The database information is correct so it would appear to be something to do with MySQL5? Any ideas? L