LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 04-27-2006, 06:22 AM   #1
imagineers7
Member
 
Registered: Mar 2006
Distribution: BackTrack, RHEL, FC, CentOS, IPCop, Ubuntu, 64Studio, Elive, Dream Linux, Trix Box
Posts: 310

Rep: Reputation: 30
mysql:- can be accessed from shell but not from myphpadmin


Hello everyone,

I can access mysql databases through shell but I am
unable to login using the same username and password
through myphpadmin.
Error is:-


Welcome to phpMyAdmin 2.6.0-pl2

Wrong username/password. Access denied.


Please help...

Thanks in Advance
 
Old 04-27-2006, 10:04 AM   #2
timmeke
Senior Member
 
Registered: Nov 2005
Location: Belgium
Distribution: Red Hat, Fedora
Posts: 1,515

Rep: Reputation: 61
Is phpMyAdmin configured correctly?
ie does it connect to the right mysql server and database?
 
Old 04-27-2006, 11:36 PM   #3
imagineers7
Member
 
Registered: Mar 2006
Distribution: BackTrack, RHEL, FC, CentOS, IPCop, Ubuntu, 64Studio, Elive, Dream Linux, Trix Box
Posts: 310

Original Poster
Rep: Reputation: 30
Yes it is!

MyPHP admin is configured correctly and can be
used to access other users databases using
respective login names. But one particular user
can not log in using his a/c. I have tried changing
the password for the user from the console using mysqladmin and a plesk also.(I forgot to tell you that
this had happened on a production server!) One more thing, that username can be used to log in and access the
databases using myphpadmin (dbwebadmin called in plesk) but not through the myphpadmin which is installed on separately on the server.(This myphpadmin is and was working properly for other users too.) No config play around have been done before it stopped working.

Sorry for late reply...
 
Old 04-28-2006, 01:43 AM   #4
timmeke
Senior Member
 
Registered: Nov 2005
Location: Belgium
Distribution: Red Hat, Fedora
Posts: 1,515

Rep: Reputation: 61
Have you checked the logs?

Secondly, try logging into the information_schema database as admin and
look for anything (ie access privileges) that is configured differently for the user
in question. However, from your explanation, it seems that the problem may not be caused by
the database (as MySql probably doesn't really care how you connect to it, just as long as you
give it the right database name and login credentials).

Thirdly, you may want to take a closer look at security measures (ie PAM rules) and environment settings for the myphpadmin (non-plesk).

Can you show us how you attempt to login to myphpadmin and dbwebadmin with a user that works and
with the user that doesn't?
 
Old 04-28-2006, 02:29 AM   #5
imagineers7
Member
 
Registered: Mar 2006
Distribution: BackTrack, RHEL, FC, CentOS, IPCop, Ubuntu, 64Studio, Elive, Dream Linux, Trix Box
Posts: 310

Original Poster
Rep: Reputation: 30
will check it out

Thanks, I will have to check out the logs
especially for phpmyadmin and the phpmyadmin in plesk
then i will go for finding out any customizations
done with the account.
( )
 
Old 04-28-2006, 05:57 AM   #6
imagineers7
Member
 
Registered: Mar 2006
Distribution: BackTrack, RHEL, FC, CentOS, IPCop, Ubuntu, 64Studio, Elive, Dream Linux, Trix Box
Posts: 310

Original Poster
Rep: Reputation: 30
Reinstalled the myphpadmin

Hello timmeke,
Thanks for your support but I just could not wait to find where the problem is as I told you earlier it was a production server.
I just had to make it work immedietly and I did..
I don't like this approach but its ok when you are in nick of time.

Thanks again
 
Old 04-28-2006, 06:11 AM   #7
timmeke
Senior Member
 
Registered: Nov 2005
Location: Belgium
Distribution: Red Hat, Fedora
Posts: 1,515

Rep: Reputation: 61
I would argue that especially production servers need to have stable, reliable configurations, certainly
no "quick hacks".
Can't you copy the configuration to a test machine now so that you can do some extensive testing?
 
Old 04-28-2006, 08:07 AM   #8
imagineers7
Member
 
Registered: Mar 2006
Distribution: BackTrack, RHEL, FC, CentOS, IPCop, Ubuntu, 64Studio, Elive, Dream Linux, Trix Box
Posts: 310

Original Poster
Rep: Reputation: 30
Yes, Its true!

I agree with you that those production servers do not need to be paid
extra attention once installed and configured especially when these are LINUX But I have to also mention that tweaks are to be done
always with test boxes and then to be used as customization(As they are no tweaks anymore). Anyway I will do some tests with those configs.
I will let you know what and how did I try with those config files.
Bye
 
  


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 On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql:- can be accessed from shell but not from myphpadmin imagineers7 Linux - Software 1 04-28-2006 07:34 AM
Edit table in myphpadmin jbg_sm Programming 1 04-11-2005 12:42 PM
MySQL in a shell script?! zaubara Programming 2 05-31-2004 05:27 PM
mysql via shell tommytomato Linux - General 8 12-01-2003 08:05 PM
phpnuke mysql no myphpadmin 5amYan Linux - Software 1 11-14-2002 03:04 AM


All times are GMT -5. The time now is 01:17 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration