mysql常用命令

select version()
查找數據文件存放路徑
show global variables like "%datadir%"

services.msc打開服務可重啟mysql


mysql提示got timeout reading communication packets的解決方法
show GLOBAL variables like '%timeout%'


set global interactive_timeout=400;
set global wait_timeout=400;


show GLOBAL variables like '%log_warning%'
set global log_warning=1;