在phpMyAdmin中创建一个只读用户 [英] creating a read-only user in phpMyAdmin

问题描述

我正在尝试创建一个只能从数据库读取的用户.这是phpMyAdmin上的用户创建屏幕.对于第一组(Data)，我认为只需要SELECT.但是我不确定第二和第三组(Structure和Administration).某些选项，例如Event Trigger Execute有点令人困惑.我是否需要那些只读用户?我到底需要启用/禁用什么?

I'm trying to create a user that can only read from a database. This is the user creation screen on phpMyAdmin. For the first set (Data), I figured I only need SELECT. But I'm not sure about the second and third sets (Structure and Administration). Some options like Event Trigger Execute are a bit confusing. Do I need those for a read-only user? What exactly do I need to enable/disable?

推荐答案

如果用户只能读取数据库，则不应授予他们任何在结构"下列出的权限或管理".

If the user should only be able to read the database, they should not be granted any of the permissions listed under "Structure" or "Administration".

这篇关于在phpMyAdmin中创建一个只读用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！