title: Ubuntu - Mysql, I have two permissions for a user, how do I delete one?
body: <p>I am running into the problem that my PHP scripts won't execute mysql insert queries, only read(select). I came down to the conclusion that it might be because of the permissions the user had, and I found two GRANT permissions under the user, so I think that's the reason.</p>
  
  <p><a href="https://i.stack.imgur.com/slRzH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/slRzH.png" alt="enter image description here"></a></p>
  
  <p>I want the user to have all privileges, or at least read and write. How do I remove the first grant ?</p>
  
  <p>I have tried this:</p>
  
  <p><a href="https://i.stack.imgur.com/o1GOn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o1GOn.png" alt="enter image description here"></a></p>
  
  <p>I learned that you can't revoke the USAGE permission. Instead you have to drop user, and create it on new I guess.</p>