欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

RedHat企业版5.5下Mysql的安装与配置

程序员文章站 2022-03-26 17:34:48
...

因为Red Hat enterprise linux 5 自带了一个mysql,所以当你安装新的mysql时,就会提示错误如: error:Failed dependencies:

因为Red Hat enterprise linux 5 自带了一个mysql,所以当你安装新的mysql时,就会提示错误如:
error:Failed dependencies:

MySQL conflicts with mysql-server-5.0.77-4.el5_4.2.i386

rpm -qa|grep mysql 可以看到安装的mysql,运行后我的系统里出现如下mysql:
mysql-server-5.0.77-4.el5_4.2
libdbi-dbd-mysql-0.8.1a-1.2.2
mysql-connector-odbc-3.51.26r1127-1.el5

于是将自带的版本卸载,有些人说得从最后一个往前卸,其实这个没关系,我就是从第一个开始卸载的。但是卸载时出现两个问题:

问题一:

运行命令:rpm -e mysql-server-5.0.77-4.e15_4.2
出错提示: error: package mysql-server-5.0.77-4.e15_4.2 is not installed

解决:rpm -e mysql-server-5.0.77(这个原因很奇怪,估计是后面的一串数字不是表示版本号的……)

问题二:dependencies问题

运行命令:rpm -e mysql-server-5.0.77-4.el5_4.2
error:Failed dependencies:

libmysqlcient.so.................................................................i386

limysqlclient.so.........................................................................i386

解决:

在卸载命令后加参数以不考虑dependencies,问题解决

rpm -e mysql-server-5.0.77 --nodeps

安装:

一、安装服务器端

(1)在目录/usr/local下有两个rmp文件的目录下运行如下命令:

[root@localhost local]# rpm MySQL-server-5.1.52-1.glibc23.i386.rpm

显示如下信息:

Preparing……       ########################################### [100%]

1:MySQL-server     ########################################### [100%]

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands:/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

Alternatively you can run:/usr/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers 。See the manual for more instructions.Please report any problems with the /usr/bin/mysqlbug script!

Starting MySQL..[确定]

如出现如上信息,服务端安装完毕。

RedHat企业版5.5下Mysql的安装与配置