Operaciones administrativas basicas de MySQL desde consola

create database database;

GRANT ALL PRIVILEGES ON database.* TO ‘usuario’@’servidor’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;

FLUSH PRIVILEGES ;

mysql –user=usuario –password database < database.sql

mysqldump –opt –password=password –user=usuario database > database.sql

REVOKE GRANT OPTION ON database.* FROM ‘usuario ‘@’localhost’;