创建用户并授权
---------------------------------------------------------
grant all privileges on *.* to 'www'@'localhost' identified by '123456'; #授权www,所有操作，所有表权限
grant all privileges on *.* to 'navicat'@'%' identified by '123456'; #授权navicat,所有操作，所有表，所有主机权限
flush privileges; #刷新
show grants for 'www'@'localhost'; #查看权限
DROP USER 'www'@'host';
mysql基本知识：
日志文件
=======================================
开启/关闭日志
修改 /etc/my.cnf #log-bin=mysql-bin #重启mysql #reset master;
mysql日志
show variables like '%log_bin%';
=======================================
mysql 二进制文件
show binary logs;
显示当前二进制文件
show master status;
=======================================
删除之前的所有bin-log文件
reset master;
删除 xx 文件之前的所有bin-log文件
purge binary logs to 'mysql-bin.000018';
=======================================
显示日志事件
show binlog events;
show binlog events in 'mysql-bin.000005';