查看数据库地址:

select SUBSTRING_INDEX(host,':',1) as ip , count(*) from information_schema.processlist group by ip;

查看数据库端口:

show variables like 'port' ;

查看服务器属性:

show variables;