Posted By

stiobhart on 06/07/09


Tagged

mysql database db cli user access grant permissions


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

kubaitis


mySQL - granting access permissions


 / Published in: MySQL
 

granting DB specific and general access priveleges from the CLI

  1. -- mySQL granting DB specific privileges:
  2. GRANT ALL PRIVILEGES on DBNAME.* TO 'user'@'%' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
  3.  
  4. -- mySQL granting generic specific privileges:
  5. GRANT ALL PRIVILEGES on *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;

Report this snippet  

You need to login to post a comment.