一些细节汇总

查看CentOS的版本信息

cat /etc/redhat-release

 

wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm

 

 

linux 修改面 直接输入 passwd + 回车

mysql 显示 too many connection 解决方法

show variables like 'max_connections';

set global max_connections=32768;

 docker run -id --name sd_mysql -p 3306:3306 -v /mysqldata/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=anzhiyi -e TZ=Asia/Shanghai --restart=always 5c62e459e087

 

隐藏ssh的banner信息

先查看版本  telnet IP地址 端口看

SSH-2.0-OpenSSH_8.6 

使用sed命令隐藏

sed -i 's/OpenSSH_8.6/welcome/g' /usr/sbin/sshd

 

查看镜像版本号

docker image inspect (docker image名称):latest|grep -i version

 

UPDATE ghy_integral n SET union_id = (SELECT o.union_id FROM ghy_user o WHERE o.id = n.user_id);
UPDATE ghy_integral n SET username = (SELECT o.realname FROM ghy_user o WHERE o.id = n.user_id);

 

测试端口号 telnet ip 端口号