mySQL - granting access permissions
granting DB specific and general access priveleges from the CLI
Copy this code and paste it in your HTML
-- 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 ;
Report this snippet
Comments
Subscribe to comments