show global variables like '%slow%'
show character set; 字符集
show collation 排序规则
show global variables like '%data%'
[root@gz-zabbixproxy-n02 confluence2]# cat db.opt
default-character-set=utf8
default-collation=utf8_bin
[root@gz-zabbixproxy-n02 confluence2]# pwd
/var/lib/mysql/confluence2
[root@gz-zabbixproxy-n02 confluence2]#
修改数据库字符集：
2)show table statusG
3）show INDEX FROM USERS;
select user,password,host from mysql.user;
show grants for root@'%';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'winit2015';
show processlist;