title: which privileges should be set for website database user / client in mysql
body: <p>So what privileges should be set for the mysql user that is to be used as 'main' user for the website?</p>
  
  <p>I'm thinking data and structure ( see below ) for the database that is used should be set. But do i need to add administration rights also? And would this be any different if you own a web server and grant privileges to a client that for example want you to host an website for them giving them rights to use phpmyadmin on there own databases.</p>
  
  <p>Data</p>
  
  <pre><code>SELECT
  INSERT
  UPDATE
  DELETE
  FILE 
  </code></pre>
  
  <p>Structure</p>
  
  <pre><code>CREATE
  ALTER
  INDEX
  DROP
  CREATE TEMPORARY TABLES
  SHOW VIEW
  CREATE ROUTINE
  ALTER ROUTINE
  EXECUTE
  CREATE VIEW
  EVENT
  TRIGGER 
  </code></pre>
  
  <p>Administration</p>
  
  <pre><code>GRANT
  SUPER
  PROCESS
  RELOAD
  SHUTDOWN
  SHOW DATABASES
  LOCK TABLES
  REFERENCES
  REPLICATION CLIENT
  REPLICATION SLAVE
  CREATE USER 
  </code></pre>