创建用户并授权
grant all privileges on database.* to user@localhost identified by '123456';
flush privileges;
查看表结构
show columns from 表;
清空查询缓存
reset query cache;
分析sql
explain sql语句;
导出存储过程与事件
mysqldump -E -R -ndt -d -uroot -psmly125 dbname> dbname.sql