multiple users using phpmyadmin -- possible?

Question

multiple users using phpmyadmin -- possible?

general

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

forum:schmichael · Answer 1 · July 19, 2004, 9:56 a.m.

forum:schmichael 20 years, 5 months ago

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.

forum:Crisis · Answer 2 · July 19, 2004, 4:05 p.m.

forum:Crisis 20 years, 5 months ago

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.

forum:Joshua · Answer 3 · July 21, 2004, 5:22 p.m.

forum:Joshua 20 years, 5 months ago

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

Compute

Storage

Networking

Databases

Services

Developer Tools

Industries

Pricing

Community

Engage With Us

multiple users using phpmyadmin -- possible?

3 Replies

Reply

Tips: