mysql笔记

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 status\G

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;