PDA

View Full Version : Client does not support authentication protocol requested by server



sultan
11-18-2005, 01:59 AM
Problemm with conection

I try to connect to Mysql through perl script

if I use username root - not problemm with conection

but when try to use another user name see this mesage
Client does not support authentication protocol requested by server

I use mysql 4, and perl 5.6

another user can conect to mysql through phpmyadmin and have all permissions for work.

the script and function for connection is

use strict;
use DBI;

my $host_name = "localhost";
my $db_name = "some_db";
my $dsn = "DBI:mysql:host=$host_name;database=$db_name";

sub connect
{
return (DBI->connect ($dsn, "some_user", "some_pass",
{PrintError => 0, RaiseError => 1}));
}


If somebody have problemm like this please tell how you decide it

Tech support write that they can't help.

wildjokerdesign
11-19-2005, 10:09 AM
This might help sort out the problem you are haveing.
MySQL Manual (http://dev.mysql.com/doc/refman/5.0/en/old-client.html)

If that does not give you enough information you might try reviewing these Google Results (http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GWYA,GWYA:2005-07,GWYA:en&q=Client+does+not+support+authentication+protocol+ requested+by+server).