Hi all,
This is my first topic here. Downloaded the just released 5.0 and thought to give it a try. I extracted the files under a subdirectory in the web root and followed the instructions in INSTALL.mysql.txt to create the MySQL user. The web server is Apache v. 2.0.59 and MySQL is v. 4.1.21. More specifically:
- created the database:
mysqladmin -u root -p create test1
- created the user:
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES on test1.* to 'test1'@'localhost' identified by 'test1';
- flushed the privileges:
flush privileges;
Ok, now calling from the browser the install.php file (
http://......./d1/install.php
) gives me the following error:
Failure to connect to your MySQL database server. MySQL reports the following message: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
Are you sure you have the correct username and password?
Are you sure that you have typed the correct database hostname?
Are you sure that the database server is running?
For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.
The problem is that during the database creation procedure, php uses the old authentication method to connect to MySQL, so a
set password for 'test1'@'localhost'=old_password('test1');MySQL command fixes this and the database is created with no problems.
I think this should be clarified in the instructions written in INSTALL.mysql.txt.
Comments
I'm getting this error on
I'm getting this error on exactly ONE drupal install on my server, out of about 6. And other MySQL php apps are working fine, even on the same domain. The site was working fine for a couple months, then I had them upgrade my server to MySQL 5, then some days later this started happening.
Running the set command is confusing. Do I run it on the database user or the domain user? Neither has worked.
Steel Rat
My Drupal Sites:
RPGMapShare.com
Infinite Ordnance
Malvern Rouge Valley Youth Center
handbook
handbooks >> Troubleshooting FAQ >> Client does not support authentication protocol requested by server...
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide
Been there, and it doesn't
Been there, and it doesn't tell me if the update is supposed to occur against the database user or the domain user.
It also doesn't explain why the same database user works on the Zen Cart db but not on the drupal db on the same domain space/server.
Steel Rat
My Drupal Sites:
RPGMapShare.com
Infinite Ordnance
Malvern Rouge Valley Youth Center
..
Because Zencart uses a different method to authenticate the user. it's a MySQL configuration setting which is why we have the link to the MySQL manual.
http://dev.mysql.com/doc/refman/4.1/en/old-client.html
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide
Yeah but my other drupal
Yeah but my other drupal sites weren't having a problem.
Turned out my hosting company had to re-compile Apache...
Steel Rat
My Drupal Sites:
RPGMapShare.com
Infinite Ordnance
Malvern Rouge Valley Youth Center