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

2014-11-24 17:52:36 · 作者: · 浏览: 1

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..[确定]


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