mySQL - granting access permissions


/ Published in: MySQL

granting DB specific and general access priveleges from the CLI


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.