Hello... all
Upon loading index.php to test my 1st install out, I get this error when trying to open http://xxx/index.php... Anyone experience this?
'mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /usr/local/apache/htdocs/includes/database.mysql.inc on line 31
Client does not support authentication protocol requested by server; consider upgrading MySQL client'
The line being refered to is (in database.mysql.inc)
$connection = mysql_connect($url['host'], $url['user'], $url['pass']) or die(mysql_error());
mysql_select_db(substr($url['path'], 1)) or die('unable to select database');
Mysql reports that MYSQL *mysql_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd): 'This function is deprecated. It is preferable to use mysql_real_connect() instead.' nice.
Not sure what to try next. I have the current Mysql 4.1.7 client, server, dev and shared-compat libraries RPM's (for 3.2.3 & 4.17) on a Mandrake 10.1 box. Drupal 4.50, Apache 1.3.33 PHP 4.3.9 After filling some dependancies, the install seemed to go well (no errors) & I compiled Apache, & Php with MYSQL. A php test page displayed fine, but w/o MYSQL - not drupal index.php
Any thoughts? Thanks Mark
Comments
A solution..
After having several other installation problems, I was stuck on this one too. I am using MySQL 4.1.8.
But I have just found a solution in the MySQL forums (see http://forums.mysql.com/read.php?11,6400,6701#msg-6701)!
At the
mysql>prompt I have typed the following:SET PASSWORD FOR XXXXXXX@localhost = OLD_PASSWORD('YYYYYYYl');Substitute the drupal database user name for XXXXX and his/her password for YYYYYYY.
Now I can finally see the Drupal welcome page!
Frans
Beautiful!!!
Thanks...nice solution.
thanks so much, it works
thanks so much, it works like joe sat strumming his strings ;-)
oh! i dont have shell
oh! i dont have shell access. how do i solve this ?