Warning: Illegal string offset 'region' in /home/mhd-01/www.gabcicala.it/htdocs/wp-content/plugins/mygeopositioncom-geotags-geometatags/mygeopositioncom-geotags-geometatags.php on line 386

Warning: Illegal string offset 'placename' in /home/mhd-01/www.gabcicala.it/htdocs/wp-content/plugins/mygeopositioncom-geotags-geometatags/mygeopositioncom-geotags-geometatags.php on line 390

Warning: Illegal string offset 'position' in /home/mhd-01/www.gabcicala.it/htdocs/wp-content/plugins/mygeopositioncom-geotags-geometatags/mygeopositioncom-geotags-geometatags.php on line 394

mysqldump e i permessi dell’utente per poter fare un dump di una tabella


Warning: Illegal string offset 'addMap' in /home/mhd-01/www.gabcicala.it/htdocs/wp-content/plugins/mygeopositioncom-geotags-geometatags/mygeopositioncom-geotags-geometatags.php on line 639

Warning: Illegal string offset 'position' in /home/mhd-01/www.gabcicala.it/htdocs/wp-content/plugins/mygeopositioncom-geotags-geometatags/mygeopositioncom-geotags-geometatags.php on line 561

Warning: Illegal string offset 'position' in /home/mhd-01/www.gabcicala.it/htdocs/wp-content/plugins/mygeopositioncom-geotags-geometatags/mygeopositioncom-geotags-geometatags.php on line 603

I GRANT minimi di cui deve godere un utente di backup sono “Select_priv” e “Lock_tables_priv“.
Nel caso in cui l’utente esista già:

UPDATE `user` SET `Select_priv` = ‘Y’,
`Lock_tables_priv` = ‘Y’,
`ssl_cipher` = ”,
`x509_issuer` = ”,
`x509_subject` = ” WHERE CONVERT( `user`.`Host` USING utf8 ) = ‘localhost’ AND CONVERT( `user`.`User` USING utf8 ) = ‘user_for_dump’ LIMIT 1 ;

altrimenti in sede di creazione

GRANT SELECT,LOCK TABLES ON *.* TO user_for_dump@’localhost’ IDENTIFIED BY ‘password’;

Technorati Tags:

About the Author: glycerin