MySQL无法正常启动（mysqld ended） 的解决方案及环境变量配置

启动mysql时报错： 

Starting mysqld daemon with databases from /var/lib/mysql 
STOPPING server from pid file /var/run/mysqld/mysqld.pid 
071112 00:22:06 mysqld ended 

 

1 首先查看日志

＃less /var/log/mysqld.log 

其中有一段如下： 

071112 0:22:06 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2) 
071112 0:22:06 [ERROR] Can't start server: can't create PID file: No such file or directory 
071112 00:22:06 mysqld ended 

 

 

 

 

说明/var/run/mysqld/mysqld.pid不存在

 

2  创建上面没有的文件

#cd /var/run/ 
#ls 

mysqld目录不存在，创建它： 

#mkdir /var/run/mysqld 
#cd /var/run/mysqld 


创建文件mysqld.pid： 

 

#touch mysqld.pid 

3 回到上一级目录，更改mysqld及其子目录的权限

#cd..