Tag Archives: mysqldump. permessi

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 […]

Read More