• Registered: 2006-10-09
  • Posts: 5

Topic: MySQL reported: Client does not support authentication protocol

Hello,
Please excuse my being a newbe
This is the first time for me to set up a php/MySQL forum
I'm trying to set up a Clinical forum for a hospital I work for and am getting this error.

An error occured on line 58 in file D:\BBoard\BBoard7\upload\include\dblayer\mysql.php.

PunBB reported: Unable to connect to MySQL server. MySQL reported: Client does not support authentication protocol requested by server; consider upgrading MySQL client


My config is:
Micro$oft Windoz server 2003
IIS 6
MySQL 5.0.24a
php 5.02
PunBB 1.2.13

Thank You
Ed Stephan

2 Reply by hcgtv

  • hcgtv
  • hcgtv
  • Senior Member
  • Offline
  • From: Charlotte, NC
  • Registered: 2004-06-25
  • Posts: 1,991

Re: MySQL reported: Client does not support authentication protocol

See here: http://punbb.org/forums/viewtopic.php?id=5369

Make sure you have the right PHP dll loading in your php.ini: extension=php_mysql.dll

PHPCrossRef . TXP Make . TXP Themes . TXP Tags . TXP Planet . We Love TXP

hcgtv's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: MySQL reported: Client does not support authentication protocol

Actually, the extension he should try and find is php_mysqli.dll (and he should choose MySQLi in the install)

  • Registered: 2006-10-09
  • Posts: 5

Re: MySQL reported: Client does not support authentication protocol

I edited my php.ini to point to my extension directory and uncommented extension=php_mysqli.dll and here is the error I got:
An error occured on line 58 in file D:\BBoard\BBoard7\upload\include\dblayer\mysql.php.

PunBB reported: Unable to connect to MySQL server. MySQL reported: Client does not support authentication protocol requested by server; consider upgrading MySQL client

PHP Warning: Unknown(): Unable to load dynamic library '.\php_mysqli.dll' - The specified module could not be found. in Unknown on line 0

I also tried extension=php_mysql.dll

An error occured on line 58 in file D:\BBoard\BBoard7\upload\include\dblayer\mysql.php.

PunBB reported: Unable to connect to MySQL server. MySQL reported: Client does not support authentication protocol requested by server; consider upgrading MySQL client

PHP Warning: Unknown(): Unable to load dynamic library '.\php_mysql.dll' - The specified module could not be found. in Unknown on line 0

This is the 1st time of working with php and MySQL and Windoz
Thank You
Ed Stephan

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: MySQL reported: Client does not support authentication protocol

Look in your php.ini file, there should be a line for 2 MySQL extensions for PHP that are commented by ;s
Remove the ;s

  • Registered: 2006-10-09
  • Posts: 5

Re: MySQL reported: Client does not support authentication protocol

Hello

extension=php_mysql.dll
extension=php_mysqli.dll

When I uncomment the 2 ext this is what I get:

An error occured on line 58 in file D:\BBoard\BBoard7\upload\include\dblayer\mysql.php.

PunBB reported: Unable to connect to MySQL server. MySQL reported: Client does not support authentication protocol requested by server; consider upgrading MySQL client

PHP Warning: Unknown(): Unable to load dynamic library '.\php_mysql.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: Unknown(): Unable to load dynamic library '.\php_mysqli.dll' - The specified module could not be found. in Unknown on line 0

Both the .dll are the latest from MySQL
Thank You
Ed Stephan

  • Registered: 2006-10-09
  • Posts: 5

Re: MySQL reported: Client does not support authentication protocol

Hello I added the path to a different ext directory and this is what I got:

An error occured on line 58 in file D:\BBoard\BBoard7\upload\include\dblayer\mysql.php.

PunBB reported: Unable to connect to MySQL server. MySQL reported: Client does not support authentication protocol requested by server; consider upgrading MySQL client

PHP Warning: Unknown(): Unable to load dynamic library 'D:\php5.0.2\ext\php_mysql.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: Unknown(): Unable to load dynamic library 'D:\php5.0.2\ext\php_mysqli.dll' - The specified module could not be found. in Unknown on line 0

I know the files are there


Thank You
Ed Stephan

  • Registered: 2006-10-09
  • Posts: 5

Re: MySQL reported: Client does not support authentication protocol

Hello
I found the solution at http://dev.mysql.com/doc/refman/5.0/en/old-client.html
Everything working perfectly
Thank you
Ed Stephan