1)查看有哪些数据库:
show databases;
2)使用哪个数据库:
use databasename;
3)查看库中有哪些表:
show tables;
4)
查看是否有开启慢查询:
show variables like '%slow%';
5)查看是否有慢查询:
show status like '%slow%'
6)查询mysql time_out时间:
show global variables like 'wait_timeout';
show global variables like 'wait_timeout';
7)修改Mysql密码
use mysql;
update user set password=PASSWORD('新密码') where user='liuyang';
FLUSH PRIVILEGES;
update user set password=PASSWORD('新密码') where user='liuyang';
FLUSH PRIVILEGES;
8)查看正在锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;