DBI with MySQL client library compile on Solaris

UNIX Solaris
1

how dow you complie perl module DBI with mysql from /usr/local/mysql/bin

keeps going to mysql client for /usr/sfw/bin

is it the LD_PATH ???...:confused:

error is

# perl login.cgi
DBI connect('customers;mysql_socket=/tmp/mysql.sock:localhost','root',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at login.cgi line 17
Client does not support authentication protocol requested by server; consider upgrading MySQL client at login.cgi line 17.
2

If you don't need the MySQL version (4.x) packaged with Solaris, then deinstall it. In order to do so, you have to deinstall the SIP express router first, then the mysql packages:

pkgrm SUNWserweb
pkgrm SUNWseru
pkgrm SUNWmysqlt
pkgrm SUNWmysqlu
pkgrm SUNWmysqlr