Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Sun Jul 18, 2004 10:20 pm 
Offline
Senior Newbie

Joined: Sun Apr 18, 2004 3:30 am
Posts: 19
Hi,

I have looked high and low for an answer on this... this is my last resort... any pointers would be appreciated...

I have a mysql db w/ permissions properly defined (permission to db, access... etc).

I want to set up a phpMyAdmin access to maintain the db for myself as well as some of my users. But I'd like to limit user access to spcific dbs I define.

I fiddled w/ config.ini.inc and managed to allow users to access only the dbs that I want them to. But what I can't figure out is, once they log in to phpMyAdmin, they essentially have access to the "Priviledges" option, which allows them to screw around w/ permissions... How do I take that option away from them?

Thank you...


Top
   
 Post subject:
PostPosted: Mon Jul 19, 2004 9:56 am 
Offline
Senior Member

Joined: Sun Mar 14, 2004 9:18 pm
Posts: 116
Website: http://michael.susens-schurter.com/
WLM: mschurter@yahoo.com
Yahoo Messenger: mschurter
Location: Peoria, IL
Go to the Privileges section and disable all of their global privileges. Then give them database-specific privileges in the section below that. IIRC they should no longer see the privileges section.

I would suggest reading MySQL's manual on the matter as well. It sounds like you might want to read up on how MySQL's privilege system works.


Top
   
 Post subject:
PostPosted: Mon Jul 19, 2004 4:05 pm 
Offline
Junior Member

Joined: Wed Jan 14, 2004 9:55 am
Posts: 44
untitled 9 is correct, really what phpmyadmin is all abou tis just a front end to mySQL. So really if they have those permissions in phpmyadmin, then they prolly have them if they made a manual connection to your datase (which isn't very secure.) Read up on how to limit people to specific operations and then they will be mirrored on the front end.


Top
   
 Post subject:
PostPosted: Wed Jul 21, 2004 5:22 pm 
Offline
Junior Member

Joined: Fri Jun 25, 2004 10:31 am
Posts: 27
also pick cookie or httpd and it will not set it to one user only


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group