添加用户
insert into mysql.user(Host,User,Password) values('localhost','admin',password('1234'));
添加权限
mysql> GRANT ALL PRIVILEGES ON *.* TO admin@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO admin@"%" IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO admin@localhost;
mysql> grant select,insert,update,delete,create,drop on vtdc.employee to admin@10.163.225.87 identified by ‘password′;
刷新系统权限表
mysql>flush privileges; //重载mysql数据
show engines; 查看mysql 的数据库引擎
表修复 REPAIR TABLE `表名`;
导出数据库
/mysqldump --no-data=true -uroot -proot -S /tmp/mysql01.sock -P 3306 operation > /tmp/123.sql
非压缩备份文件恢复：
mysql -u root -p dataname < name2008010103.sql
从压缩文件直接恢复：
gzip < name2008010103.sql.gz | mysql -u root -p password
或：
zcat name2008010103.sql.gz | mysql -u root -p password
