一、查看慢查询超时时间值 use performance_schema; select * from variables_by_thread where variable_name = 'long_query_time';
二、查看MySQL当前线程 show processlist;
三、建立wayne用户,设置密码,容许全部网段访问 use performance_schema; 1. create user 'wayne'@'%' identified by '123'; drop user 'wayne'@'%'; 2. create user 'wayne'@'192.168.32.%' identified by '123'; drop user 'wayne'@'192.168.32.%'; 3. show grants; 查看用户权限 show grants for 'wayne'@'%'; 查看'wayne'@'%'用户权限 4. grant select,update,insert,delete on test.* to 'wayne'@'%'; 赋予'wayne'@'%'用户对test库下全部tables增删改查的权限