Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Possible actions on MySQL tables
This guide presents the different actions that are possible on a MySQL table depending on the rights granted to a user.
Actions on tables according to user rights
On shared web hosting
Read + Write + Admin
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW
Reading + Writing
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLE
Reading
GRANT SELECT
On Cloud Server
Read + Write + Admin
GRANT ALL
Reading + Writing
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES
Reading
GRANT SELECT
Learn more
Link to this FAQ: