Geek asks and answers

Creating a read-only user in phpMyAdmin

I am trying to create a user who can only read from the database. This is the user creation screen on phpMyAdmin. For the first set ( Data), I decided that I only needed SELECT. But I'm not sure the second and third sets ( Structureand Administration). Some options, such as a Event Trigger Executebit confusing. Are they read-only for the user? What do I need to enable / disable?

enter image description here

+3
source share
3 answers

If the user should only read the database, they should not be granted any permissions listed in the "Structure" or "Administration" section.

+9

"" "". /db, /db.

+3

The first section focuses only on managing table data, and you only need the SELECTprivilege of having a read-only user.

+3
source

More articles:


All Articles