Is there a tool like phpMyAdmin which can be configured to access just a single database? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

开发者_开发百科 Improve this question

Is there a tool like phpMyAdmin which can be configured to access only a single MySQL database in a server?

I cannot use phpMyAdmin because it allows access to all databases. A view that can allow a user to create/delete/insert/update tables should do. I remember using a software similar to this but dont remember what it was. It would also be great if its in PHP.

---

You can create a MySQL user with permissions to access only a single database, and then use that account to log into phpMyAdmin.

---

PhpMyAdmin will only allow access to the databases allowed for the user you log in as. If your MySQL environment is set up as it should be, nobody should have access to more accounts than they should. Most PHP-based MySQL administrator packages will work in the same way, it just passes the username/password you give it to MySQL and shows all databases that user has permissions for.

---

SIDU allows you to connect to what db you specify each time, of course, you need to have the access to that db first.

Without the chart plugin, SIDU is only 90KB, with chart 150kb (the font.ttf takes up 50kb)?

But SIDU does a better job than PMA? sure in most areas. But the export need to be upgraded ? well it does my export job anyway. good to have a try from

sidu.sf.net

I m not sure what your question, SIDU can allow you to connect to just one database (in the menu tree browser), but you still be able to access to other database in the SQL browser

---

phpMyAdmin can do this, although i am not sure how.

i guess the most simple way is to create a MySQL user with the according privileges and configure phpmyadmin to use that account.

---

Check MySQL Ajax Table Editor (MATE) http://www.mysqlajaxtableeditor.com/