Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Understand the possible MySQL actions
This guide presents the various actions 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: