centos升级mysql到5.5

最新推荐文章于 2025-08-07 13:27:41 发布

mush_me

最新推荐文章于 2025-08-07 13:27:41 发布

阅读量88

点赞数

CC 4.0 BY-SA版权

文章标签：运维数据库

本文链接：https://blog.youkuaiyun.com/mush_me/article/details/84273347

本文提供了在CentOS5.5环境下将MySQL升级至5.5版本的详细步骤，包括安装MySQL5.5.x的yum源、安装客户端和支持包、卸载旧版本、安装新版本的服务端等，适用于需要进行数据库主从配置的场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

系统环境：centos5.5
centos5.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：                                              [确定]