Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restricting user in phpMyAdmin to DB page only

Status
Not open for further replies.

a6m1n0

Programmer
Mar 7, 2005
233
US
My config:
Windows 2003 Server SE
MySQL 5.0.22
PHP 5.1.4.4 w/updated php_mysql.dll and libmysql.dll
phpMyAdmin 2.8.1 w/Control user and DB

Scenario:
I create a new user in phpMyAdmin with default permissions [Usage]. Lets say the user is 'Bob'.
I create a new DB the same name as the user, 'Bob' again.
I GRANT ALL to user 'Bob' on DB 'Bob'.

My question/problem:
Currently when I login as Bob, I am able to click the breadcrumb link 'Server: localhost' and can access things I would prefer the user be unable to access. Such as Runtime Info, System Variables, Show Processes, etc.

How do I restrict Bob in phpMyAdmin to just DB Bob and disallow access to the MySQL server information page? This should happen upon login.

I hope this is possible. :$

Thanks

-a6m1n0

Curiosity only kills cats.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top