Codigo Para Crear Usuarios Y Respaldar BD
grant all privileges on corrida.toros to jordan@'%' identified by 'jordan';
grant lock tables on corrida.* to jordan@'%' identified by 'jordan';
grant select on corrida.toreros to juan@'%' identified by 'juan';
grant lock tables on corrida.* to juan@'%' identified by 'juan';
mysqldump -u jordan -pjordan -h 192.168.210.73 corrida[toros] >D:respaldo.sql
mysqldump -u juan -pjuan -h 192.168.210.73 corrida[toreros] >D:respaldo1.sql
grant lock tables on corrida.* to jordan@'%' identified by 'jordan';
grant select on corrida.toreros to juan@'%' identified by 'juan';
grant lock tables on corrida.* to juan@'%' identified by 'juan';
mysqldump -u jordan -pjordan -h 192.168.210.73 corrida[toros] >D:respaldo.sql
mysqldump -u juan -pjuan -h 192.168.210.73 corrida[toreros] >D:respaldo1.sql
No hay comentarios:
Publicar un comentario