Client does not supprt authentication Error

ecgreg wrote on Wednesday, May 14, 2008:

Hello,

When installing on a Win XP Pro (SP2) machine using Xampp on a dedicated partition I can get as far as the third step in the installation process (setup.php).  I’ve had the same error twice and can’t figure out where my problem is located.

1. Hardware: Dual Core AMD HP Desktop with SP2. Dedicated partition setup.
2. Using xampp running as a service installed using the installer from the apache friends site.  Working correctly with PHP4.x and all ports necessary open.
3. Installed OpenEMR 2.8.2
3a. Modified globals.php and php.ini as directed.
4. On the setup.php screen added the appropriate password for the server and client.  Clicked continue and get this error:

OpenEMR Setup

Step 3

Connecting to MySQL Server… OK.
Creating database… OK.
Creating user with permissions for database… OK.
Reconnecting as new user…
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in H:\xampp\htdocs\openemr\setup.php on line 210
ERROR. Check your login credentials.

Client does not support authentication protocol requested by server; consider upgrading MySQL client (#1251)

Any help would be appreciated.

Thanks!

Eoin

drbowen wrote on Thursday, May 15, 2008:

Dear Eoin,

The "HOWTO" is a bit dated and needs to be upgraded.  Your error message may be a problem with the PHP version?  What versions of Apache, MySQL, PHP are actually being installed?

1) It is probably wiser to use PHP 5 and the best version would be 5.2.5 or newer.

2) When modifying openemr/interface/globals.php, use forward slashes in your path:

$webserver_root="H:/xampp/htdocs/openemr/setup.php";

The Unix / works better than the Windows   for this setup.

3) I would go with OpenEMR 2.8.3 (or the CVS current version)  There have been a lot of bug fixes since 2.8.2.

Sam Bowen, MD