Create a backup MySQL user
Aus HS Syswiki
(Unterschied zwischen Versionen)
Vkl (Diskussion | Beiträge) K (Vkl verschob Seite Create backup MySQL user nach Create a backup MySQL user) |
Vkl (Diskussion | Beiträge) |
||
Zeile 4: | Zeile 4: | ||
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 ; | 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 ; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
+ | |||
+ | [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 ;
[Category:MySQL]