multiple users using phpmyadmin -- possible?

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…

3 Replies

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.

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.

also pick cookie or httpd and it will not set it to one user only

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct