Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Understanding possible MySQL actions
This guide presents the various 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 VIEWRead + Write
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLERead
GRANT SELECT... on Cloud Server
Read + Write + Admin
GRANT ALLRead + Write
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLESRead
GRANT SELECT
Link to this FAQ: