MySQL常用命令

command	description
SELECT @@session.tx_isolation;	查看当前客户端事务隔离级别
SET session transaction isolation level read uncommitted;	更改事务隔离级别为read uncommitted
SHOW CREATE TABLE tablename;	查看表的存储引擎
SHOW TABLE STATUS FROM dbname;	查看表的存储引擎
ALTER TABLE tablename engine = InnoDB;	修改表的存储引擎
SET password for root@localhost = password(‘root’);	修改密码
grant all privileges on 库名.表名 to ‘用户名‘@’IP地址’ identified by ‘密码’ with grant option;	添加IP访问权限
flush privileges;	和上一条语句之后执行，使生效
GRANT replication slave ON 库名.表名 TO ‘slave‘@’%’ IDENTIFIED BY ‘密码’;	分配从服务账户
show master status;	查看主服务器BIN日志的信息