Create a backup MySQL user
Aus HS Syswiki
(Unterschied zwischen Versionen)
Vkl (Diskussion | Beiträge) |
Vkl (Diskussion | Beiträge) |
||
Zeile 5: | Zeile 5: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
− | [Category:MySQL] | + | [[Category:MySQL]] |
Version vom 17. Juni 2014, 15:21 Uhr
CREATE USER 'dbbackup'@'144.76.15.211' IDENTIFIED BY 'aefithao4Lahshe'; GRANT SELECT , RELOAD , FILE , SUPER , LOCK TABLES , SHOW VIEW ON * . * TO 'dbbackup'@'144.76.15.211' IDENTIFIED BY 'no5Ahleod5xe5sh' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;