Share your knowledge at the LQ Wiki.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 07-03-2005, 05:56 AM   #1
LQ Newbie
Registered: Jul 2005
Posts: 4

Rep: Reputation: 0
MYSQL problem (with phpmyadmin too)

heres my problem:

i cannot log in to phpmyadmin with my mysql logins

ive setup the control user, and that works im pretty sure because it shows the user in the database (using webmin)

i can login to view my databases in webmin, but webmins mysql functions are really not what i like to use

so phpmyadmin came in and i set it up how it said, with the control user, and im trying to use http as the authentication, now if i remove roots password from the database, and then try and access phpmyadmin with root and password left blank, i can get into phpmyadmin, but as soon as i password my root in mysql i cannot access phpmyadmin

the same thing happens with every other mysql user, they cannot login with passwords, but as soon as i remove the passwords, they can get in

i have no idea whats going on, i cant see a .htaccess file in the directory, so i gather there isnt one there

if anyone has any help on this, please let me know


Mysql version: 4.1.12-standard
php version: 4.3.9
apache version: 2.0.52
linux: fedora core 3

i found that it wont connect because the client version that PHP is displaying is 3.23.** and thats incorrect, because im using the one from 4.1.12

anyone know how to fix that??

Last edited by skeletor2069; 07-03-2005 at 06:57 AM.
Old 07-03-2005, 08:05 AM   #2
LQ Newbie
Registered: Jul 2005
Posts: 4

Original Poster
Rep: Reputation: 0
ok found out how to get around it for now

mysql> SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('password');

this was the error i was getting but the http authorisation didnt display it till i changed it to cookie:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

that then lead me to scope out what was wrong

hope this helps anyone else with the same problem


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
mysql and phpmyadmin jungleking Linux - Newbie 1 09-17-2005 08:07 AM
MySQL Administrator vs phpMyAdmin Ice Dragon Linux - Software 1 08-01-2004 04:15 PM
Mysql - phpMyadmin questions paleogryph Linux - Software 1 02-27-2004 12:47 PM
mysql <> phpmyadmin error rizza Linux - Software 0 01-28-2004 06:34 AM
phpMyAdmin & MySQL Staz Linux - Software 0 09-26-2002 07:41 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:03 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration