title: How do I restrict MySQL user from dropping, and adding tables and databases
body: <p>I am trying to find the SQL command to create a user that can read and write in tables found in one database, but is not allowed to do anything else.</p>
  
  <p>Also if you can recommend other limits I should add to the MySQL user I would appreciate it.</p>
  
  <p>The reason I am asking is because one of my tables was dropped and I have no idea how... I think it's PHP but I am not sure... Maybe someone connected via my SSH... The thing is all my mysql logs are empty and no evidence of a another user trying to do something are to be found in the other logs...</p>
  
  <p>So for now I am assuming there is something wrong with my PHP... This is why I would like to limit it to only adding, removing, and dropping rows and content in the rows... But not more. So that I don't loose my table again or my other DBs.</p>