Knowledge base
1000 FAQs, 500 tutorials and instructional videos. Here, there are only solutions!
Understanding possible MySQL actions
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 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 SELECTLink to this FAQ:
Has this FAQ been helpful?