jueves, 18 de noviembre de 2010

CREAR USUARIOS

grant select,insert,update on fiesta.apoderado to edwin@'192.168.210.%' identified by 'edwin';
grant select,insert,update,references
grant lock tables on fiesta.* to edwin@'192.168.210.%' identified by 'edwin';

-----------------------------------------------------------------------------------------------------

grant select,insert,update on fiesta.apoderado to chanito@'192.168.210.%' identified by 'chanito';
grant select,insert,update on fiesta.corrida to chanito@'192.168.210.%' identified by 'chanito';
grant select,insert,update,references
grant lock tables on fiesta.* to chanito@'192.168.210.%' identified by 'chanito';

-----------------------------------------------------------------------------------------------------
respaldar

mysqldump -u edwin -pedwin -h 192.168.210.60 fiesta apoderado >d:Respaldo.sql

mysqldump -u chanito -pchanito -h 192.168.210.60 fiesta corrida >d:RespaldoCorrida.sql

ELMER ERNESTO CEN POOL

EDWIN ROYNE RODRIGUEZ CASTRO

JOHNY FRANCISCO ITZA ESTRELLA