LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-03-2003, 04:43 AM   #1
Gear_freak2000
Member
 
Registered: Jun 2003
Posts: 90

Rep: Reputation: 15
My SQL problem


ok... im using:

Mysql installed using these RPM's MySQL-client-4.1.0-0.i386.rpm & MySQL-server-4.1.0-0.i386.rpm

When i first installed everything was fine..

Then i installed apache (apache_1.3.27.tar.gz)

Then PHP (php-4.3.2.tar.gz)

Everything worked fine (even MyPhpAdmin)...

Then i decided 2 set-up the root password for mysql.... That worked fine...

logged in

[root@localhost james]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 89 to server version: 4.1.0-alpha

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

See all fine...

But if i try and log in using a web interface (ie phpmyadmin) i get this error

Welcome to phpMyAdmin 2.5.1


Error

MySQL said:


Client does not support authentication protocol requested by server. Consider upgrading MySQL client

Any clues on what 2 do... i need to get this sorted ASAP... thanks for any help!
 
Old 06-03-2003, 07:06 AM   #2
Crashed_Again
Senior Member
 
Registered: Dec 2002
Location: Atlantic City, NJ
Distribution: Ubuntu & Arch
Posts: 3,503

Rep: Reputation: 57
I don't know much about phpMyAdmin but it doesn't like your MySQL client. Are those the latest versions? Maybe its looking for SSL support.
 
Old 06-03-2003, 08:20 AM   #3
gbbenson
LQ Newbie
 
Registered: Jan 2003
Location: Munich, Germany
Distribution: Linux from Scratch
Posts: 29

Rep: Reputation: 15
Hmmmm... I don't know much about Mysql, but with other RDMS systems out there, the application logging into the dbms uses a login other than the admin user, for security reasons. What user is php trying to use?
 
Old 06-03-2003, 08:21 AM   #4
Gear_freak2000
Member
 
Registered: Jun 2003
Posts: 90

Original Poster
Rep: Reputation: 15
i got everything working again...... But i kinda screwed up... he he (messed up the root password) i dont want 2 reset the root password.. i want 2 remove Mysql and remove the database that has the password init (the database is called mysql)

is there a way of doing this?
 
Old 06-03-2003, 12:47 PM   #5
bentman78
Member
 
Registered: Mar 2003
Location: Washington DC, USA
Distribution: Redhat
Posts: 212

Rep: Reputation: 30
Download and run MySQLCC from the MySql website. It's a great GUI tool to help with MySQL. Try to connect with that. Sometimes MySQL doesn't like "remote" connections. There is edit I had to do with the my.conf file to get phpadmin to work. I can't remember what it is though. I'll look.
 
Old 06-03-2003, 01:27 PM   #6
Gear_freak2000
Member
 
Registered: Jun 2003
Posts: 90

Original Poster
Rep: Reputation: 15
i got everything working just deleted and reinstalled... all works fine now!

MySQLCC would be useful if there was a moniter on my linux box... im doing everything though telnet from my win machine!

Last edited by Gear_freak2000; 06-03-2003 at 01:34 PM.
 
Old 06-03-2003, 05:39 PM   #7
bentman78
Member
 
Registered: Mar 2003
Location: Washington DC, USA
Distribution: Redhat
Posts: 212

Rep: Reputation: 30
There is a windows version. It's in a .zip extension, and of course like everything Windows, it's easy to install. It's at the site, and defenitly worth the download. Try it out.
 
Old 06-03-2003, 05:46 PM   #8
Crashed_Again
Senior Member
 
Registered: Dec 2002
Location: Atlantic City, NJ
Distribution: Ubuntu & Arch
Posts: 3,503

Rep: Reputation: 57
Quote:
Originally posted by bentman78
Download and run MySQLCC from the MySql website. It's a great GUI tool to help with MySQL. Try to connect with that. Sometimes MySQL doesn't like "remote" connections. There is edit I had to do with the my.conf file to get phpadmin to work. I can't remember what it is though. I'll look.
I can't find a stable version of that thing. It crashes randomly(Segmentation Fault)
 
  


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
My SQL Problem KiLLaWaBBiT Linux - Software 1 07-03-2005 02:44 PM
Migrating from MS-SQL server to My-SQL emailssent Linux - Networking 2 02-07-2005 03:20 PM
Which SQL is suitable for EMbedded SQL on C? hk_michael Programming 4 01-10-2005 06:07 PM
SQL Problem oulevon Programming 1 02-10-2004 07:24 PM
SQL problem.Need help please. Swift&Smart Programming 2 04-17-2003 05:22 PM


All times are GMT -5. The time now is 09:04 PM.

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