By fresh-off on

hello,
so i *believe* i finished the drupal installation locally, but when i tried to view the drupal folder in my browser using my local host i get the following error:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in e:\wamp\www\drupal-4.6.5\includes\database.mysql.inc on line 31
Client does not support authentication protocol requested by server; consider upgrading MySQL client

i've got php, appache, mySql, phpMyAdmin, etc installed on this computer using Wamp Server.

i'm a COMPLETE newbie to php and mySql.. heh.. i had to have a friend help me thru the instalation via messenger.. anyhow.. thats the warning i'm now getting, and am stuck. what to do next?

Comments

Samat Jain’s picture

Samat Jain commented

I know what the problem is, but not sure why you're getting it or how you can easily fix it. This is not a Drupal problem.

In MySQL 4.1 (and above), they introduced a new authentication protocol. In order to connect to these servers, your language bindings (e.g. PHP in your case) need to support it. Normally, you'd upgrade PHP to get this support; but since you're using WAMP, it should already work.

I'd check WAMP for support on this?
__
Personal home page | Rhombic Networks: Drupal hosting

rrajan’s picture

rrajan commented

If you get the authentication protocol error and unable to see the successful install page of drupal use this mysql uery to change the authentication method to old_password

UPDATE mysql.user SET Password = OLD_PASSWORD('password') WHERE User = 'user'

Thanks

london3’s picture

london3 commented

If you login to MySQL as root and issue the following command replacing astbilluser with your username and astbill419 with your password. The problem will be solved.

SET PASSWORD FOR 'astbilluser'@'localhost' = OLD_PASSWORD('astbill419');

Are Casilla
http://astartelecom.com - Independent VOIP Telecoms Broker. Consulting in Asterisk and Drupal
http://astbill.com - Billing, Routing and Management software for Asterisk and MySQL. Running on Drupal
AstBill DEMO: http://demo.astbill.com

fresh-off’s picture

fresh-off commented

i'd run that through the command line then?

heine’s picture

heine commented

This is an (my)SQL query: run it with phpmyadmin
--
Tips for posting to the forums