liyihongcug 发表于 2009-6-23 19:19:47

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

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

集群(版本为 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 反馈 。
从命令可以知道安装是不成功的
卸载也不成功
如何解决这个问题
# rpm -qa| grep msyql
# 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)
# 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...                ###########################################
      package mysql-5.0.45-7.el5.i386 is already installed
# rpm -ev mysql-5.0.45-7.el5.i386.rpm
error: package mysql-5.0.45-7.el5.i386.rpm is not installed
# rpm -ev mysql-5.0.45-7.el5.i386.rpm
error: package mysql-5.0.45-7.el5.i386.rpm is not installed
# 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...                ###########################################
      package mysql-5.0.45-7.el5.i386 is already installed
# rpm -ev mysql-5.0.45-7.el5.i386.rpm
error: package mysql-5.0.45-7.el5.i386.rpm is not installed
#

kider 发表于 2009-6-24 08:54:47

你的语句有两处错误:
1、
# rpm -qa| grep msyql    ----应该为mysql
2、
# 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 发表于 2009-6-24 15:29:30

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 发表于 2009-6-24 16:36:51

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

090603 17:21:48mysqld ended

090622 22:00:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
090622 22:00:59 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 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:59InnoDB: 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:59InnoDB: Started; log sequence number 0 46409
090622 22:00:59 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 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 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:46InnoDB: 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:47InnoDB: Started; log sequence number 0 46409
090623 15:21:47 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 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 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:28InnoDB: 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:29InnoDB: Started; log sequence number 0 46409
090623 20:33:29 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 发表于 2009-6-24 17:38:47

没有生成mysql系统库,重新卸载、安装MySQL rpm 包
页: [1]
查看完整版本: 安装是不成功的 如何解决这个问题