Advanced Search

Return to Snippet

Revision: 14587
at June 7, 2009 11:24 by stiobhart
Initial Code 
-- mySQL granting DB specific privileges:
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 ;   

-- mySQL granting generic specific privileges:
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 ;
Initial URL 









Initial Description





granting DB specific and general access priveleges from the CLI









Initial Title





mySQL - granting access permissions









Initial Tags





mysql, database, user









Initial Language





MySQL