centos6中 rpm安装mysql出错问题解决方法

[root@cch rpm]# rpm -ivh MySQL-server-5.5.29-1.rhel5.x86_64.rpm

error: Failed dependencies:
libaio.so.1()(64bit) is needed by MySQL-server-5.5.29-1.rhel5.x86_64
libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.5.29-1.rhel5.x86_64
libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.5.29-1.rhel5.x86_64

需要使用yum命令快速安装依赖包libaio，运行如下命令：

yum install libaio

出现：configure: error: No curses/termcap library found
解决方法：

# ./configure --prefix=/usr/local/mysql

为 .#./configure --with-named-curses-libs=/usr/lib/libncursesw.so.5

出现：

../depcomp: line 571: exec: g++: not found
make[1]: *** [my_new.o] 错误 127
make[1]: Leaving directory `/home/justme/software/mysql-5.1.30/mysys'
make: *** [all-recursive] 错误 1

解决 ：

下载 安装 gcc-c++-4.1.2-33.i386.rpm(yum intall gcc-c++)

安装或者重新mysql-5.1.30时mysql_install_db出现FATAL ERROR: Could not find mysqld错误解决，

因为/etc/mysql/下出现了个my.cnf

解决方法:

mv /etc/my.cnf /etc/my.cnf.bak

cp support-files/my-medium.cnf /etc/cnf

如果出现如下错误信息：

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

说明mysql服务还没有启动，输入service mysql start启动mysql服务

service mysql start

MySQL5.5后启动失败
我通过rpm安装MySQL5.5后，尝试使用 service mysql start命令启动MySQL，得到错误信息：
The server quit withoud updating PID file。
进一步查看localhost.localdomain.err文件，发现错误日志如下：
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
和
Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

而我进入数据库目录下，可以看到mysql目录下plugin和host的数据表文件。

Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

没有自动初始化，先在mysql的安装目录下执行mysql_install_db