MySQL-MySQL常用命令

select @@basedir as basePath from dual //C:\Program Files\MySQL\MySQL Server 5.7\

Show variables like "datadir"

MySQL -localhost -uroot -proot

 show databases;

exit

show variables    

show variables like "%具体变量%"

show status    

show status like "%具体变量%"    
 
 输出结果显示了有哪些线程在运行

show full processlist    

 show processlist    

show global variables like '%connect%';    

net stop MySQL
 net start MySQL

 set global max_user_connections=10    
 
 MySQL安装目录

select @@basedir    

 select @@datadir    

 C:\ProgramData\MySQL\MySQL Server 5.7\my.ini    

show variables like 'log_%';    

show variables like 'log_bin'