Create a backup MySQL user
Aus HS Syswiki
(Unterschied zwischen Versionen)
Vkl (Diskussion | Beiträge) |
Jre (Diskussion | Beiträge) |
||
Zeile 1: | Zeile 1: | ||
+ | [[Category:ServerAdmin]] | ||
+ | {{note|ServerAdmin content. Please ignore and move.|error}} | ||
+ | |||
<syntaxhighlight lang="sql" style="font-size:9pt;"> | <syntaxhighlight lang="sql" style="font-size:9pt;"> | ||
CREATE USER 'dbbackup'@'144.76.15.211' IDENTIFIED BY 'aefithao4Lahshe'; | CREATE USER 'dbbackup'@'144.76.15.211' IDENTIFIED BY 'aefithao4Lahshe'; |
Aktuelle Version vom 25. Juni 2014, 17:18 Uhr
ServerAdmin content. Please ignore and move.
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 ;