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

services.msc打開(kāi)服務(wù)可重啟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;