LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices


Reply
  Search this Thread
Old 06-01-2006, 12:44 PM   #1
DoctorWynn
Member
 
Registered: Nov 2005
Distribution: OpenSuSe 10.1
Posts: 63

Rep: Reputation: 15
phpmyadmin mysql user problems


Ok, I have my localhost server working nicely. I can use the user folders (/~user) to host web content including php scripts. phpmyadmin works fine as well. All is good. Or at least it was.

I looked into fixing the "root with no password" security issue, so I fixed that by deleting the root name from the config.inc.php file in phpmyadmin, and by adding myself as a fully privileged user in mysql. I wanted to add mysql users so that I don't even have to use the root user to access databases. This all is working fine so far except for one thing...I can't do anything in phpmyadmin anymore. It shows me logged in as "wwwrun@localhost" and I have absolutely no access to change anything. I see no "logout/login" options in phpmyadmin, so what do I do??
 
Old 06-01-2006, 01:39 PM   #2
david_ross
Moderator
 
Registered: Mar 2003
Location: Scotland
Distribution: Slackware, RedHat, Debian
Posts: 12,047

Rep: Reputation: 66
You'll need to change the authentication type. If you set it to http then it should let you log in as the user you like. Just make sure you follow the documentation here:
http://www.phpmyadmin.net/documentat...tication_modes
 
Old 06-01-2006, 02:52 PM   #3
DoctorWynn
Member
 
Registered: Nov 2005
Distribution: OpenSuSe 10.1
Posts: 63

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by david_ross
You'll need to change the authentication type. If you set it to http then it should let you log in as the user you like. Just make sure you follow the documentation here:
http://www.phpmyadmin.net/documentat...tication_modes
Yeah, I've done that. In fact, that's how it's set right now. I tried, cookies, config, and http. No change.

One other thing though, my config.inc.php file, was NOT in the phpmyadmin folder. It was in the "libraries" folder. I copied it to the root phpmyadmin folder and it accepted the changes (deleting the root user), so I assume it's reading from it, but I'm still always logged in as wwwrun@localhost instead of as the user "tom" as setup in mysql.
 
Old 06-01-2006, 03:03 PM   #4
DoctorWynn
Member
 
Registered: Nov 2005
Distribution: OpenSuSe 10.1
Posts: 63

Original Poster
Rep: Reputation: 15
Ok, I got it. The only thing I did, was delete the config.inc.php file from the libraries folder. I also noticed, that my real config.inc.php file still had "config" set instead of "http" for the authentication method. I don't know how I missed that, but apparently the whole problem was simply my overlooking this setting.

So thanx for the help, you did cause me to look at it yet again, and now it works! Thanx again!
 
  


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
MySql and phpMyAdmin problems eagletalontim Linux - Software 1 01-09-2006 08:28 PM
mysql and phpmyadmin jungleking Linux - Newbie 1 09-17-2005 08:07 AM
MYSQL problem (with phpmyadmin too) skeletor2069 Linux - Software 1 07-03-2005 08:05 AM
MySQL - PHP5 - phpMyAdmin 2.6.0 Fuel Linux - Software 2 07-25-2004 01:39 PM
Installing phpmyadmin with mysql?? chromelocust Linux - Software 0 04-07-2003 01:25 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 06:41 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