This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
network:mysql_syslog [2014/03/11 13:18] tschulz [Create database] |
network:mysql_syslog [2014/03/11 13:18] tschulz [Grant Permissions to database] |
||
---|---|---|---|
Line 36: | Line 36: | ||
===== Grant Permissions to database ===== | ===== Grant Permissions to database ===== | ||
- | <file> | + | <file sql> |
CREATE USER 'syslog'@'localhost' IDENTIFIED BY '***'; | CREATE USER 'syslog'@'localhost' IDENTIFIED BY '***'; | ||
- | |||
GRANT USAGE ON * . * TO 'syslog'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; | GRANT USAGE ON * . * TO 'syslog'@'localhost' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; | ||
- | |||
GRANT ALL PRIVILEGES ON `syslog` . * TO 'syslog'@'localhost'; | GRANT ALL PRIVILEGES ON `syslog` . * TO 'syslog'@'localhost'; | ||
</file> | </file> |