liunx安装mysql的启动，查看状态命令

1. 找到mysql.server文件
2. 复制　mysql.server文件到/etc/init.d/目录下，重命名为mysql
3. 查看mysqld　status状态    使用命令1:service mysql status

 

命令1:service mysql status

SUCCESS! MySQL running (9954)

 

命令2：systemctl status mysqld

● mysqld.service - LSB: start and stop MySQL
Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
Active: active (running) since Thu 2023-05-11 06:30:09 PDT; 5s ago
Docs: man:systemd-sysv-generator(8)
Process: 9691 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=0/SUCCESS)
Tasks: 28
Memory: 193.4M
CGroup: /system.slice/mysqld.service
├─9708 /bin/sh /usr/local/mysql/bin/mysqld_safe...
└─9954 /usr/local/mysql/bin/mysqld --basedir=/u...

May 11 06:30:09 localhost.localdomain systemd[1]: Starting...
May 11 06:30:09 localhost.localdomain mysqld[9691]: Starti...
May 11 06:30:09 localhost.localdomain systemd[1]: Started ...
Hint: Some lines were ellipsized, use -l to show in full.

 

命令3：systemctl start mysqld

启动MySQL

输入以下命令出现：bash: mysqldump: command not found...

 

[root@localhost data]# mysqldump -u root -p cless aaa> /beifen/cless-aaa.sql
bash: mysqldump: command not found...

则进入

[root@localhost data]# vim /etc/profile

# 添加mysql的环境变量

export MYSQL_HOME=/usr/local/mysql

export PATH=.:${MYSQL_HOME}/bin:$PATH

然后刷新mysql的环境变量

[root@localhost data]# source /etc/profile

 

查看文件大小

du -shc * | sort -h

 

过滤查找文件：

eg：tail -n500 /data/mysql/mysql.err|grep -E "Warning|ERROR"