MariaDB社区

标题: 安装是不成功的如何解决这个问题 [打印本页]

作者: liyihongcug 时间: 2009-6-23 19:19
标题: 安装是不成功的如何解决这个问题
安装是不成功的  如何解决这个问题

集群（版本为 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 时间: 2009-6-24 08:54
你的语句有两处错误：
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 时间: 2009-6-24 15:29
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
/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 时间: 2009-6-24 17:38
没有生成mysql系统库，重新卸载、安装MySQL rpm 包

欢迎光临 MariaDB社区 (http://123.56.88.72/)