CentOS 5.5的流mysql升级

CentOS 5.5的源mysql升级

系统环境：CentOS 5.5

CentOS 5.5的源mysql目前还停留在5.0.19上，要做数据库主从的时候，必须升级到5.1以上。

索性，直接到5.5吧

1、安装MySQL 5.5.x的yum源：

rpm -Uvh http://repo.webtatic.com/yum/centos/5/latest.rpm

2、安装MySQL客户端的支持包：

yum install libmysqlclient15 --enablerepo=webtatic

3、卸载MySQL老版本的软件包：

yum remove mysql mysql-*

4、安装MySQL 5.5的客户端和服务端：

yum install mysql55 mysql55-server --enablerepo=webtatic

5、启动MySQL系统服务，更新数据库：

/etc/init.d/mysqld restart

mysql_upgrade

升级完毕

/etc/init.d/mysqld?restart ??停止?mysqld：??????????????????????????????????????????????[确定] ??初始化?MySQL?数据库：?Installing?MySQL?system?tables... ??OK ??Filling?help?tables... ??OK ????To?start?mysqld?at?boot?time?you?have?to?copy ??support-files/mysql.server?to?the?right?place?for?your?system ????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?client4.360zan.cn?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. ????You?can?start?the?MySQL?daemon?with: ??cd?/usr?;?/usr/bin/mysqld_safe?& ????You?can?test?the?MySQL?daemon?with?mysql-test-run.pl ??cd?/usr/mysql-test?;?perl?mysql-test-run.pl ????Please?report?any?problems?with?the?/usr/bin/mysqlbug?script! ???????????????????????????????????????????????????????????????[确定] ??启动?mysqld：??????????????????????????????????????????????[确定]??

源是国外的，特慢。

文件下载

下载在Linux公社的1号FTP服务器里，下载地址：

FTP地址：ftp://www.linuxidc.com

用户名：www.linuxidc.com

密码：www.muu.cc

在 2012年LinuxIDC.com\8月\CentOS下升级MySQL 5.0.19到5.5

下载方法见 http://www.linuxidc.net/thread-1187-1-1.html