create database zhishu;
show databases;
show global variables like "%datadir%";
mysql> show global variables like "%datadir%";
+---------------+-----------------------------+
| Variable_name | Value |
+---------------+-----------------------------+
| datadir | /data/mysql/mysql3306/data/ |
+---------------+-----------------------------+
show create database zhishu;
查看数据库默认编码
[root@localhost zhishu]# cat /data/mysql/mysql3306/data/zhishu/db.opt
default-character-set=utf8
default-collation=utf8_general_ci
select * from t1 \G;
错误日志
show global variables like "%log%";
show variables like "%log%"; //session
查看有无连接
show processlist;
查看有无监听
ss -nltp | grep 3306
mysql -h 192.168.0.20 -P 3306 -u root -p
create user 'test'@'192.168.0.%'> grant select,update,delete,insert on zhishu.* to 'test'@'192.168.0.%';