mysql 常用命令

 

mysql 本分数据库命令

mysqldump -u root -p voice>voice.sql

 

 用户创建以及授权

grant all privileges on k559.* to k559@localhost identified by 'passwd';

grant select,insert,update,delete on book.* to test2@localhost Identified by "abc";

 59277 mysql重启

 ./etc/init.d/mysql start