<div id="article_content" class="article_content"> <p>mysql错误解决：</p> <p>先 参考：http://www.jb51.net/article/48625.htm</p> <p>参考第四条：<br /></p> <p>mysql在启动时没有指定配置文件时会使用/etc/my.cnf配置文件，请打开这个文件查看在[mysqld]节下有没有指定数据目录(datadir)。</p> <p>mysql版本：mysql Ver 14.14 Distrib 5.5.44, for linux2.6 (i686) using readline 5.1<br /><br /><br /></p> <p>错误原因：my.conf放置在/etc目录下，当安装mysql-admin（mysql客户端，里面包含了mysql-common等包，）后，， 问题出现</p> <p>toor@door:/lib$ sudo /etc/init.d/mysql.server start<br /> Starting MySQL<br /><span style="color:#FF0000">. The server quit without updating PID file (/var/lib/mysql/door.pid).</span><br /> toor@door:/lib$ clear<br /></p> <p>然后卸载mysql-admin(同时相应的包也卸载掉了）：<br /></p> <p>toor@door:/lib$ sudo /etc/init.d/mysql.server start<br /><span style="color:#FF0000">/usr/local/mysql/bin/my_print_defaults: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)</span> <br /> Fatal error in defaults handling. Program aborted<br /> Starting MySQL<br /><span style="color:#FF0000">. The server quit without updating PID file (/usr/local/mysql/data/door.pid).</span><br /> toor@door:/lib$ cd /etc/<br /> toor@door:/etc$ ls |grep mysql<br /> mysql<br /> toor@door:/etc$ cd mysql/<br /> toor@door:/etc/mysql$ ls<br /><span style="color:#FF0000">my.cnf</span><br /> 问题发生变化！</p> <p><br /></p> <p>然后再安装mysql-admin客户端</p> <p>toor@door:/lib$ sudo /etc/init.d/mysql.server start<br /> Starting MySQL<br /><span style="color:#FF0000">. The server quit without updating PID file (/var/lib/mysql/door.pid).</span><br /></p> <p>然后把/etc目录下的my.conf文件移动到/etc/mysql/目录下（这里覆盖了安装某些包生成的默认my.cnf文件。</p> <p>toor@door:/etc$ <span style="color:#FF0000">sudo mv my.cnf mysql</span><br /> toor@door:/etc$ cd mysql<br /> toor@door:/etc/mysql$ ls<br /> conf.d my.cnf<br /> toor@door:/etc/mysql$ gedit my.cnf <br /> toor@door:/etc/mysql$ ls<br /> conf.d my.cnf<br /><span style="color:#009900">toor@door:/etc/mysql$ sudo /etc/init.d/mysql.server start<br /> Starting MySQL<br /> ... <br /> toor@door:/etc/mysql$ sudo /etc/init.d/mysql.server status<br /> * MySQL running (9965)</span></p> <p><br /><br /><span style="background-color:rgb(204,0,0)">要注意的是，mysql的配置文件有一个加载顺序，加载顺序参考：<a target="_blank" href="http://www.linuxidc.com/Linux/2012-02/53855.htm"><span style="color:#3333FF"><u><span style="background-color:rgb(255,255,255)">http://www.linuxidc.com/Linux/2012-02/53855.htm</span></u></span></a></span></p> <p><br /><span style="background-color:rgb(204,0,0)"></span></p> <p><span style="background-color:rgb(204,0,0)">会先加载/etc/mysql/my.cnf，如果安装了某些软件，在/etc/mysql目录下创建了my.cnf，然而这个文件是新生成的默认文件，却不是我们的配置文件，启动的过程加载就不成功了！所以安装了某些包后出现启动不成功！当这些包或者程序卸载后如果my.cnf也没有删除掉的话，仍然启动失败！<span style="background-color:rgb(255,102,102)">。</span></span></p> <p><br /></p> <p>以上说的是mysql5.54版本！！ 仅供参考！！！<br /></p> <p><br /></p> </div>