MySQL第一课 指令学习
登陆命令C:\Program Files\MySQL\MySQL Server5.7\bin>mysql.exe -h 120.77.155.115 -P 3316 -u
root–p
查看当前所有的用户
select distinct concat('User:''',user,'''@''',host,''':') as query from mysql.user;
查看用户的权限
select * from mysql.user where user='root'\G
修改配置文件/etc/my.cnf 配慢查询
slow_query_log = 1
slow_query_log_file = /mysql_slow_query.log
命令设置
set global slow_query_log=1;
查看修改状态
show global status like '%slow%';
测试慢查询
SELECT SLEEP(10);
页:
[1]