1.启动数据库时报错
启动
# /etc/init.d/mysqld start
Starting MySQL.Logging to '/application/mysql-5.6.36/data/mysql02.err'.
170618 18:59:33 mysqld_safe Directory '/application/mysql-5.6.36/tmp' for UNIX socket file don't exists.
ERROR! The server quit without updating PID file (/application/mysql-5.6.36/data/mysql02.pid).
解决方法:
# mkdir /application/mysql/tmp
# chown -R mysql.mysql /application/mysql/
# /etc/init.d/mysqld start
Starting MySQL.Logging to '/application/mysql-5.6.36/data/mysql02.err'.. SUCCESS!
2、错误日志
tail -100 /application/mysql/data/db02.err
常见问题:
故障:ERROR! The server quit without updating PID file
1.权限.chown -R mysql.mysql
2.killall mysqld
3.重新初始化数据.
4.运行1年了,出问题(非法(断电)关机或者非法关数据库,例如kill -9)
3.编译安装时报错
解决方法:
yum install gcc* glibc* -y
4.没有设置环境变量
解决方法:
设置环境变量
echo 'PATH=/application/mysql/bin/:$PATH' >>/etc/profile
tail -1 /etc/profile
source /etc/profile
echo $PATH
生效环境变量