Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 09-26-2005, 05:36 AM   #1
LQ Newbie
Registered: Sep 2005
Posts: 2

Rep: Reputation: 0
Trouble connecting from mysql 4.1 to 5.0

Hi all!

Im having trouble to connect from my server to mysql 5.0 server.
Everything works fine in shell (mysql -h -u bla -p)
But when my perl script tries to access that same database i get this error message:

Cannot connect to db server: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I got this same error message in shell also but it went away when i updated mysql to 4.1.

My server:

Your MySQL connection id is 30 to server version: 4.1.11-Debian_4sarge1-log

Other server:

Your MySQL connection id is 1210 to server version: 5.0.9-beta-nt


Any help would be appreciated

Old 09-27-2005, 04:03 PM   #2
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,696

Rep: Reputation: 232Reputation: 232Reputation: 232
You probably use a kind of perl module to access the server. It probably needs to be updated (just like the shell client).


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
having trouble connecting with dsl jgams Linux - Networking 12 11-06-2004 10:20 PM
wlan trouble connecting g4rr3tt Linux - Wireless Networking 1 03-16-2004 03:04 PM
Trouble connecting to dialup. Ross Clement Linux - Networking 9 01-22-2004 10:26 PM
trouble connecting to certain sites hotfootred Linux - Networking 4 12-30-2002 06:29 AM
Mysql is not connecting from servlet.But connecting from java, help pls Harish_f Linux - General 0 05-08-2002 03:21 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:21 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration