Advanced Search

mySQL - granting access permissions

/ Published in: MySQL
Save to your folder(s)
granting DB specific and general access priveleges from the CLI

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.