安装是不成功的 如何解决这个问题

liyihongcug

安装是不成功的  如何解决这个问题

集群（版本为 mysql cluster7）安装了

MySQL-Cluster-gpl-tools-7.0.5-0.rhel5.i386.rpm
MySQL-Cluster-gpl-server-7.0.5-0.rhel5.i386.rpm
。。。。。

现在要卸载所有mysql ， 重新安装mysql5.0.45版本
我用了yum 等删除方法 但是现在安装mysql5.0.45总感到有点不对劲。
网上找的删除方法有
卸载mysql

　　rpm -qa|grep -i mysql

　　rpm -ev MySQL-server-4.0.14-0 MySQL-client-4.0.14-0

（现在我不知道MySQL-server-4.0.14-0 MySQL-client-4.0.14-0
，这台linux环境好复杂， 最开始装了5.0.45 ，后来删除（yum 删除的哦）
之后装cluter（所有的cluster软件，好像5种），现在准备删除mysql 重新装mysql5.045
）
　　


这是 测试的rpm 反馈 。
从命令可以知道安装是不成功的
卸载也不成功
如何解决这个问题
[root@localhost tmp]# rpm -qa| grep msyql
[root@localhost tmp]# mysql -h localhost -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@localhost tmp]# rpm -ivh mysql-5.0.45-7.el5.i386.rpm
warning: mysql-5.0.45-7.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID e8562897
Preparing...                ########################################### [100%]
        package mysql-5.0.45-7.el5.i386 is already installed
[root@localhost tmp]# rpm -ev mysql-5.0.45-7.el5.i386.rpm
error: package mysql-5.0.45-7.el5.i386.rpm is not installed
[root@localhost tmp]# rpm -ev mysql-5.0.45-7.el5.i386.rpm
error: package mysql-5.0.45-7.el5.i386.rpm is not installed
[root@localhost tmp]# rpm -ivh mysql-5.0.45-7.el5.i386.rpm
warning: mysql-5.0.45-7.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID e8562897
Preparing...                ########################################### [100%]
        package mysql-5.0.45-7.el5.i386 is already installed
[root@localhost tmp]# rpm -ev mysql-5.0.45-7.el5.i386.rpm
error: package mysql-5.0.45-7.el5.i386.rpm is not installed
[root@localhost tmp]#

kider

你的语句有两处错误：
1、
[root@localhost tmp]# rpm -qa| grep msyql    －－－－应该为mysql
2、
[root@localhost tmp]# rpm -ev mysql-5.0.45-7.el5.i386.rpm    －－－－删除时不需要后缀.el5.i386.rpm

具体参考：http://www.mysqlpub.com/viewthread.php?tid=83&extra=page%3D1

liyihongcug

yum安装成功
现在新的问提。
var/lib/mysql 文件目录下是空的 ,没有 mysql test目录 （这是很不正常的 ，如果没看mysql，将无法启动），也没有socket。

所以我用 mysql -hlocalhost -uroot -p
报错误 eeror 2002(HY000) can't connect to local myslq serer. through socket '/var/lib/mysql/mysql.sock'
换--protocal=tcp  还是抱mysql.sock错误
这个很奇怪 ，为 什么mysql下面会没哟数据或者目录啦？？  （安装没有报错误 ）

liyihongcug

/var/log/mysqld.log
its content is like this:

090603 17:21:48  mysqld ended

090622 22:00:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
090622 22:00:59 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
090622 22:00:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090622 22:00:59  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090622 22:00:59  InnoDB: Started; log sequence number 0 46409
090622 22:00:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
090622 22:00:59 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
090623 15:21:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
090623 15:21:45 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
090623 15:21:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090623 15:21:46  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090623 15:21:47  InnoDB: Started; log sequence number 0 46409
090623 15:21:47 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
090623 15:21:47 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
090623 20:33:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
090623 20:33:28 [Warning] The syntax 'for replication startup options' is deprecated and will be removed in MySQL 5.2. Please use 'CHANGE MASTER' instead.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
090623 20:33:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090623 20:33:28  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090623 20:33:29  InnoDB: Started; log sequence number 0 46409
090623 20:33:29 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
090623 20:33:29 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended

kider

没有生成mysql系统库，重新卸载、安装MySQL rpm 包