是否有像phpMyAdmin这样的工具可以配置为只访问单个数据库？ [英] Is there a tool like phpMyAdmin which can be configured to access just a single database?

问题描述

有没有像phpMyAdmin这样的工具可以配置为只访问服务器中的单个MySQL数据库？

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

我不能使用phpMyAdmin，因为它允许访问所有数据库。一个可以允许用户创建/删除/插入/更新表的视图。我记得使用类似的软件，但不记得是什么。它也将是巨大的，如果它在PHP。

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.

推荐答案

您可以创建具有访问权限的MySQL用户，只访问单个数据库，然后使用该帐户登录phpMyAdmin。

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

这篇关于是否有像phpMyAdmin这样的工具可以配置为只访问单个数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！