1 Topic by dice

  • dice
  • Junior Member
  • Offline
  • Registered: 2005-01-08
  • Posts: 2

Topic: mysql problem installing punbb

An error occured on line 58 in file C:\Program Files\Apache Group\Apache2\htdocs\forums\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

how do i fix this?

  • From: California
  • Registered: 2005-01-08
  • Posts: 152

Re: mysql problem installing punbb

Is this a remote or local server? What version of MySQL?

Why I use FreeBSD

Bwongar.com's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: mysql problem installing punbb

With the introduction of MySQL 4.1, the client authentication procedure was changed (stronger hashing). What the error message means is that you're running MySQL 4.1 or later and that your PHP environment is using a MySQL client library that is pre 4.1. There are three possible solutions to the problem.

1. Install the mysqli extention in your PHP environment. When installed, PunBB's install.php will detect it and enable "MySQL Improved" in the database type drop-down.
2. Upgrade the mysql extension in your PHP environment so that it works with MySQL 4.1 or later.
3. Start the MySQL server with the parameter --old-passwords and update any passwords.

You can find more info on the matter in the MySQL documentation.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website