Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    England, UK
    Posts
    10

    Unanswered: client does not support authentication protocol

    Hi there

    I have MySql 4.1 up and running on my system now but when I try to access the database using a perl script I get the following error:

    DBI connect('my_database:localhost','root',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at database_connection.pl line 9

    The perl script in question is:

    use DBI;

    my $dsn = 'DBI:mysql:my_database:localhost';
    my $db_user_name = 'root';
    my $db_password = '<my root password>';
    my ($id, $password);
    my $dbh = DBI->connect($dsn, $db_user_name, $db_password);

    I understand that mysql 4.1 changed its password authenication so I used the OLD-PASSWORD function in order to revert back to the old style, but although that worked, I still dont get rid of the error.

    Any help would be much appreciated.

    My system is a PC running SuSe 9.0

    Ffenics

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: client does not support authentication protocol

    Originally posted by ffenics2002
    Hi there

    I have MySql 4.1 up and running on my system now but when I try to access the database using a perl script I get the following error:

    DBI connect('my_database:localhost','root',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at database_connection.pl line 9

    The perl script in question is:

    use DBI;

    my $dsn = 'DBI:mysql:my_database:localhost';
    my $db_user_name = 'root';
    my $db_password = '<my root password>';
    my ($id, $password);
    my $dbh = DBI->connect($dsn, $db_user_name, $db_password);

    I understand that mysql 4.1 changed its password authenication so I used the OLD-PASSWORD function in order to revert back to the old style, but although that worked, I still dont get rid of the error.

    Any help would be much appreciated.

    My system is a PC running SuSe 9.0

    Ffenics
    http://www.mysql.com/doc/en/Old_client.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •