Переехал с MySQL4 на MySQL5

[Angel]

Вот код:
use DBI;
$dbh1 = DBI->connect("DBI:mysql:data:localhost:3306", "login", "1111");
$query="insert into Book(id, name, mail, daterec, memo) values (NULL, \'$Name\',\'$Mail\',\'$DateRec\',\'$Memo\')";
$sth = $dbh1->prepare($query);
$rv = $sth->execute;

На Мускуле 4,0.23 - всё работало отлично.
Перешёл на 5-й Мускул - Error 500.
Ссылается на  DBI->connect.

В логах Апача2:
[Mon Dec 19 21:12:35 2005] [error] [client 10.101.142.53] Premature end of script headers: insert.cgi, referer: http://10.101.142.53/cgi/insert.cgi
[Mon Dec 19 21:12:35 2005] [error] [client 10.101.142.53] DBI connect(\'metrokr:localhost:3306\',\'metrokr\',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at D:/WebServer/home/10.101.142.53/cgi/insert.cgi line 263\\r, referer: http://10.101.142.53/cgi/insert.cgi
[Mon Dec 19 21:12:35 2005] [error] [client 10.101.142.53] Can\'t call method "prepare" on an undefined value at D:/WebServer/home/10.101.142.53/cgi/insert.cgi line 265.\\r, referer: http://10.101.142.53/cgi/insert.cgi
[Mon Dec 19 21:12:35 2005] [error] [client 10.101.142.53] File does not exist: D:/WebServer/home/10.101.142.53/www/favicon.ico, referer: http://10.101.142.53/cgi/insert.cgi

Вставил:
use CGI::Carp qw (fatalsToBrowser);

В браузере выдало:
Software error:
Can\'t call method "prepare" on an undefined value at D:/WebServer/home/10.101.142.53/cgi/insert.cgi line 265.

В логах Апача2:
[Mon Dec 19 21:14:22 2005] [error] [client 10.101.142.53] [Mon Dec 19 21:14:21 2005] insert.cgi: DBI connect(\'metrokr:localhost:3306\',\'metrokr\',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at D:/WebServer/home/10.101.142.53/cgi/insert.cgi line 263\\r, referer: http://10.101.142.53/cgi/insert.cgi
[Mon Dec 19 21:14:22 2005] [error] [client 10.101.142.53] [Mon Dec 19 21:14:21 2005] insert.cgi: Can\'t call method "prepare" on an undefined value at D:/WebServer/home/10.101.142.53/cgi/insert.cgi line 265.\\r, referer: http://10.101.142.53/cgi/insert.cgi
[Mon Dec 19 21:14:22 2005] [error] [client 10.101.142.53] File does not exist: D:/WebServer/home/10.101.142.53/www/favicon.ico, referer: http://10.101.142.53/cgi/insert.cgi

Использую:
DBD:mysql 2,1026,0,0
DBI 1,34,0,0
ActivePerl-5.8.7.813

ПОМОГИТЕ!!!

[NeoNox]

Angel:
ПОМОГИТЕ!!!

Самая первая ссылка

[Sanchez]

DBI возможно надо обновить, в общем делай поиск на тему совместимости DBI и Mysql5 на сайте одного и другого

[Angel]

Уже разобрался и всё работает после первого ответа.