Apr 2, 2013, 10:55 AM
Post #1 of 6
Hi we just migrated a database from mysql 3.5 to mysql 5.5.
Connecting Mysql 5 problem (worked great on 3)
Any perl scripts that run on the server (centos) work fine.
We have a desktop application written in perl which won't connect to the new database.
my $db = DBI->connect("DBI:mysql:host=10.0.0.123;database=db","username","password");
returns a error "Client doesn't support authentication method requested by server"
The desktop perl application runs on Windows machines.
We are using perl version 5.8.3
DBMs installed are ExampleP, File, Proxy, Sponge, XBase, and mysql.
DBD:: says no odbc drivers installed.
I installed the most current windows driver for mysql.
I can't uninstall the windows 3.51 driver.
Anyone have suggestions on the most unobtrusive method of fixing this problem? I've searched all over the internet.