Create a backup MySQL user
Aus HS Syswiki
Version vom 17. Juni 2014, 15:20 Uhr von Vkl (Diskussion | Beiträge)
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 ;