LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 05-04-2006, 11:08 PM   #1
kaixiang
LQ Newbie
 
Registered: May 2006
Posts: 7

Rep: Reputation: 0
managing mysql using webmin = problem!


when i'm managing mysql using webmin
no matter doing what, whether create database user, drop database or what just get this error
Code:
Failed to create database : DBI connect failed : Client does not support authentication protocol requested by server; consider upgrading MySQL client
anyone can help?
 
Old 05-04-2006, 11:12 PM   #2
kaixiang
LQ Newbie
 
Registered: May 2006
Posts: 7

Original Poster
Rep: Reputation: 0
and here is the list of my installed package

mysql-devel-3.23.58-16.RHEL3.1
MySQL-shared-compat-5.0.20a-0.rhel3
mod_auth_mysql-20030510-2.ent
perl-DBD-MySQL-2.1021-3
MySQL-client-standard-5.0.20a-0.rhel3
libdbi-dbd-mysql-0.6.5-5
MySQL-server-standard-5.0.20a-0.rhel3
qt-MySQL-3.1.2-13.4
php-mysql-4.3.2-25.ent
MySQL-python-0.9.1-6
mysql-bench-3.23.58-16.RHEL3.1
 
Old 05-05-2006, 12:34 AM   #3
zulfilee
Member
 
Registered: Apr 2004
Location: India
Distribution: Redhat,Fedora
Posts: 430

Rep: Reputation: 39
Are u able to do it in command line.
Normal mysql open,connect and all operations?

Also if u specifically want to administer mysql database through browser try using phpmyadmin[a cool tool for database administration]
phpmyadmin is available in freshmeat.net
 
Old 05-05-2006, 02:39 AM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,412

Rep: Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397Reputation: 2397
Here is the explanation of why this happens & how to fix it: http://dev.mysql.com/doc/refman/4.1/en/old-client.html
Basically, "MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients."
 
Old 05-05-2006, 02:48 AM   #5
kaixiang
LQ Newbie
 
Registered: May 2006
Posts: 7

Original Poster
Rep: Reputation: 0
just installed phpmyadmin...
and its also give me this message
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
 
Old 05-05-2006, 10:48 AM   #6
farslayer
LQ Guru
 
Registered: Oct 2005
Location: Northeast Ohio
Distribution: linuxdebian
Posts: 7,241
Blog Entries: 5

Rep: Reputation: 190Reputation: 190
did you consider using mysql-admin ? it's a gui admin client provided by Mysql AB you should have a package available for it.. unless theres some reason you want a Web based client..

http://www.mysql.com/products/tools/administrator/
 
  


Reply


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
slack, webmin, & mySQL e1000 Slackware 5 04-28-2015 10:45 AM
LXer: Followup on Managing MySQL on Mac OS X LXer Syndicated Linux News 0 01-01-2006 09:01 AM
webmin+mysql a quick question pudhiyavan Linux - Software 0 01-13-2005 09:07 PM
/bin/sh needed by MySQL + Webmin??? Keyser Sose Linux - Software 2 06-29-2004 06:40 PM
Webmin and MySQL dsiguy Linux - General 0 02-07-2003 11:22 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 04:52 AM.

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