mysql5.5.24无法启动-启动失败

mysql 版本升级到5.5据新东家oracle说读写性能较之前的mysql5.1提高了两三倍,所以就在centos vps上安装了mysql5.5.24.

rpm安装步骤:

http://dev.mysql.com/downloads/mysql/ 下载对应版本的mysql压缩包,我用的系统是centos 6.2,所以server platform 我选了 Linux Generic  具体下载地址是http://cdn.mysql.com/Downloads/MySQL-5.5/MySQL-5.5.24-1.linux2.6.x86_64.tar

下载完,解压缩之后 rpm -ivh server.rpm

遇到两个问题,一个是mysql 连接遇到错误:“Can’t connect to local MySQL server through   /var/lib/mysql/mysql.sock” ,解决方案 touch /var/lib/mysql/mysql.scok ,然后重新启动mysql  :service mysql start

遇到第二个问题:The server quit without updating PID file (/var/lib/mysql/*.pid), 打开mysql错误日志err,看了一下,提示:Mysql-Table ‘mysql.host’ doesn’t exist ,重建mysql数据库表,mysql_install_db –user=mysql –ldata=/var/lib/mysql  ,然后

/usr/bin/mysqld_safe  发现已经可以安全启动,ctrl+C,然后执行service mysql restart 成功启动mysql5.5.24

 

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Protected by WP Anti Spam