remove mysql

rpm -qa | grep -i mysql
rmp -ev "search sorftware package"
yum remove mysql, relviant mysql package
find / -name mysql

netstat -ln | grep mysqld

==client mysql
yum install mysql-server
显示icp 链接
ss -t -a
显示Sockets 摘要
ss -s
列出所有打开的网络链接端口
ss -l
查看进程使用的socket
ss -pl
找出打开套接字/端口应用程序
ss -pl | grep 3306
netstat -an | grep 8080
显示所有UDP Sockets
ss -u -a
列出所有端口 22(ssh) 的链接
ss state all sport = :ssh
查看TCP的链接状态
ss -tan|awk 'NR>1{++S[$1]}END{for (a in S) print a,S[a]}'
使用命令查看哪个文件夹占用的空间大
du -h --max-depth=1 /mydata
cat alert_LIN1.log | grep -i ORA- | wc -l
cat alert_LIN1.log | grep -i ORA-
find . -type f -pirint0 | xargs -0 du -h | sort -hr | head -20
ss -lntp | grep mysql
============================
remove a group named
groupdel 
verify that the group is removed
getent group | grep mygroup
===========================the system monitor tools=============
top,iostat ,vmstat 检查mysql 相关性能问题提供判断
==========================创建文件夹=================
groupadd mysql
useradd -g mysql mysql
mkdir -p /opt/mysql/data/{data,logs,tmp}
chown -R mysql:mysql /opt/mysql/
chmod -R 700 /opt/mysql/data
===========================grep 函数检索command==============
grep -A 3 -i "example" demo_text //output sucessfull patch of rows , so the thirds of rows