centos mysql 基本操作

启动：/etc/init.d/mysqld start

创建用户：CREATE USER 'username'@'host' IDENTIFIED BY 'password'

赋予权限：GRANT privileges ON databasename.tablename TO 'username'@'host' 

设置与更改用户密码：SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');如果是当前登陆用户用SET PASSWORD = PASSWORD("newpassword");

删除用户：DROP USER 'username'@'host'; 

查看binlog：SHOW BINLOG EVENTS in 'mysql-bin.000010' from 46755013 limit 10;