MySQL 5525rpm安装及升级到5626 for RedHat Enterprise Linux 64.docx

1、MySQL 5525rpm安装及升级到5626 for RedHat Enterprise Linux 64MySQL 5.5.25（rpm）安装及升级到5.6.26 for RedHat Enterprise Linux 6.4环境：RedHat Enterprise Linux 6.4（64bit) MySQL:5.6.25 IP：192.168.15.166 步骤一：准备工作：a、建议删除系统存在的mysql用户rootmysql01 Desktop# id mysqluid=27(mysql) gid=27(mysql) groups=27(mysql)rootmysql01 Desk

2、top# userdel -r mysqlb、清理已安装的mysql程序包rootsuzzy # rpm -qa|grep mysqlmysql-server-5.1.66-2.el6_3.x86_64dovecot-mysql-2.0.9-5.el6.x86_64qt-mysql-4.6.2-25.el6.x86_64rsyslog-mysql-5.8.10-6.el6.x86_64mysql-5.1.66-2.el6_3.x86_64mod_auth_mysql-3.0.0-11.el6_0.1.x86_64mysql-devel-5.1.66-2.el6_3.x86_64mysql-li

3、bs-5.1.66-2.el6_3.x86_64使用rpm -e 包名 （都地上面显示）来清除安装包，如果碰到不能报错不能删除，加上参数 -nodeps强制删除即可。例如：rootsuzzy # rpm -e qt-mysql-4.6.2-25.el6.x86_64error: Failed dependencies:qt4-mysql is needed by (installed) akonadi-1.2.1-2.el6.x86_64rootsuzzy # rpm -e qt-mysql-4.6.2-25.el6.x86_64 -nodepsrootsuzzy # rpm -e mysql

4、-server-5.1.66-2.el6_3.x86_64 -nodepsrootsuzzy # rpm -e dovecot-mysql-2.0.9-5.el6.x86_64 -nodepsrootsuzzy # rpm -e qt-mysql-4.6.2-25.el6.x86_64 -nodepsrootsuzzy # rpm -e rsyslog-mysql-5.8.10-6.el6.x86_64 -nodepsrootsuzzy # rpm -e mysql-5.1.66-2.el6_3.x86_64 -nodepsrootsuzzy # rpm -e mod_auth_mysql-3

5、.0.0-11.el6_0.1.x86_64 -nodepsrootsuzzy # rpm -e mysql-devel-5.1.66-2.el6_3.x86_64 -nodepsrootsuzzy # rpm -e mysql-libs-5.1.66-2.el6_3.x86_64 -nodeps 直到下面语句找不到mysql包为止rootmysql01 # rpm -qa | grep mysqlrootmysql01 # 注意：在卸载完成之后需要删除配置文件/etc/f和数据库文件/var/lib/mysql ，保守起见可将配置文件f进行改名处理。rootmysql01 Desktop#

6、rpm -qpl MySQL-client-advanced-5.6.25-1.el6.x86_64.rpm rootmysql01 Desktop# rpm -qpl MySQL-devel-advanced-5.6.25-1.el6.x86_64.rpm rootmysql01 Desktop# rpm -qpl MySQL-embedded-advanced-5.6.25-1.el6.x86_64.rpm rootmysql01 Desktop# rpm -qpl MySQL-server-advanced-5.6.25-1.el6.x86_64.rpm rootmysql01 Desk

7、top# rpm -qpl MySQL-shared-advanced-5.6.25-1.el6.x86_64.rpm rootmysql01 Desktop# rpm -qpl MySQL-shared-compat-advanced-5.6.25-1.el6.x86_64.rpm rootmysql01 Desktop# rpm -qpl MySQL-test-advanced-5.6.25-1.el6.x86_64.rpm 步骤二：开始安装1、建立用户组及用户rootmysql01 # groupadd mysqlrootmysql01 # useradd -g mysql mysql2

8、、将下载好的mysql程序rpm包上传至服务器此处略过或者：rootmysql01 Desktop# unzip V76360-01.ziprootmysql01 Desktop# rpm -ivh MySQL-*Preparing. # 100% 1:MySQL-devel-advanced # 14% 2:MySQL-client-advanced # 29% 3:MySQL-test-advanced # 43% 4:MySQL-embedded-advanced# 57% 5:MySQL-shared-compat-adv# 71% 6:MySQL-shared-advanced #

9、86% 7:MySQL-server-advanced # 100%2015-08-28 10:56:58 0 Warning TIMESTAMP with implicit DEFAULT value is deprecated. Please use -explicit_defaults_for_timestamp server option (see documentation for more details).2015-08-28 10:56:58 0 Note /usr/sbin/mysqld (mysqld 5.6.25-enterprise-commercial-advance

10、d) starting as process 4981 .2015-08-28 10:56:58 4981 Note InnoDB: Using atomics to ref count buffer pool pages2015-08-28 10:56:58 4981 Note InnoDB: The InnoDB memory heap is disabled2015-08-28 10:56:58 4981 Note InnoDB: Mutexes and rw_locks use GCC atomic builtins2015-08-28 10:56:58 4981 Note InnoD

11、B: Memory barrier is not used2015-08-28 10:56:58 4981 Note InnoDB: Compressed tables use zlib 1.2.32015-08-28 10:56:58 4981 Note InnoDB: Using Linux native AIO2015-08-28 10:56:58 4981 Note InnoDB: Using CPU crc32 instructions2015-08-28 10:56:58 4981 Note InnoDB: Initializing buffer pool, size = 128.

12、0M2015-08-28 10:56:58 4981 Note InnoDB: Completed initialization of buffer pool2015-08-28 10:56:58 4981 Note InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!2015-08-28 10:56:58 4981 Note InnoDB: Setting file ./ibdata1 size to 12 MB2015-08-28 10:56:58 4981

13、Note InnoDB: Database physically writes the file full: wait.2015-08-28 10:56:59 4981 Note InnoDB: Setting log file ./ib_logfile101 size to 48 MB2015-08-28 10:57:00 4981 Note InnoDB: Setting log file ./ib_logfile1 size to 48 MB2015-08-28 10:57:01 4981 Note InnoDB: Renaming log file ./ib_logfile101 to

14、 ./ib_logfile02015-08-28 10:57:01 4981 Warning InnoDB: New log files created, LSN=457812015-08-28 10:57:01 4981 Note InnoDB: Doublewrite buffer not found: creating new2015-08-28 10:57:01 4981 Note InnoDB: Doublewrite buffer created2015-08-28 10:57:01 4981 Note InnoDB: 128 rollback segment(s) are act

15、ive.2015-08-28 10:57:01 4981 Warning InnoDB: Creating foreign key constraint system tables.2015-08-28 10:57:02 4981 Note InnoDB: Foreign key constraint system tables created2015-08-28 10:57:02 4981 Note InnoDB: Creating tablespace and datafile system tables.2015-08-28 10:57:02 4981 Note InnoDB: Tabl

16、espace and datafile system tables created.2015-08-28 10:57:02 4981 Note InnoDB: Waiting for purge to start2015-08-28 10:57:02 4981 Note InnoDB: 5.6.25 started; log sequence number 02015-08-28 10:57:02 4981 Note RSA private key file not found: /var/lib/mysql/private_key.pem. Some authentication plugi

17、ns will not work.2015-08-28 10:57:02 4981 Note RSA public key file not found: /var/lib/mysql/public_key.pem. Some authentication plugins will not work.A random root password has been set. You will find it in /root/.mysql_secret.2015-08-28 10:57:03 4981 Note Binlog end2015-08-28 10:57:03 4981 Note In

18、noDB: FTS optimize thread exiting.2015-08-28 10:57:03 4981 Note InnoDB: Starting shutdown.2015-08-28 10:57:04 4981 Note InnoDB: Shutdown completed; log sequence number 16259772015-08-28 10:57:04 0 Warning TIMESTAMP with implicit DEFAULT value is deprecated. Please use -explicit_defaults_for_timestam

19、p server option (see documentation for more details).2015-08-28 10:57:04 0 Note /usr/sbin/mysqld (mysqld 5.6.25-enterprise-commercial-advanced) starting as process 5006 .2015-08-28 10:57:04 5006 Note InnoDB: Using atomics to ref count buffer pool pages2015-08-28 10:57:04 5006 Note InnoDB: The InnoDB

20、 memory heap is disabled2015-08-28 10:57:04 5006 Note InnoDB: Mutexes and rw_locks use GCC atomic builtins2015-08-28 10:57:04 5006 Note InnoDB: Memory barrier is not used2015-08-28 10:57:04 5006 Note InnoDB: Compressed tables use zlib 1.2.32015-08-28 10:57:04 5006 Note InnoDB: Using Linux native AIO

21、2015-08-28 10:57:04 5006 Note InnoDB: Using CPU crc32 instructions2015-08-28 10:57:04 5006 Note InnoDB: Initializing buffer pool, size = 128.0M2015-08-28 10:57:04 5006 Note InnoDB: Completed initialization of buffer pool2015-08-28 10:57:04 5006 Note InnoDB: Highest supported file format is Barracuda

22、.2015-08-28 10:57:04 5006 Note InnoDB: 128 rollback segment(s) are active.2015-08-28 10:57:04 5006 Note InnoDB: Waiting for purge to start2015-08-28 10:57:04 5006 Note InnoDB: 5.6.25 started; log sequence number 16259772015-08-28 10:57:04 5006 Note RSA private key file not found: /var/lib/mysql/priv

23、ate_key.pem. Some authentication plugins will not work.2015-08-28 10:57:04 5006 Note RSA public key file not found: /var/lib/mysql/public_key.pem. Some authentication plugins will not work.2015-08-28 10:57:04 5006 Note Binlog end2015-08-28 10:57:04 5006 Note InnoDB: FTS optimize thread exiting.2015-

24、08-28 10:57:04 5006 Note InnoDB: Starting shutdown.2015-08-28 10:57:06 5006 Note InnoDB: Shutdown completed; log sequence number 1625987A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !You will find that password in /root/.mysql_secret.You must change that password on your first connect,no ot

25、her statement but SET PASSWORD will be accepted.See the manual for the semantics of the password expired flag.Also, the account for the anonymous user has been removed.In addition, you can run: /usr/bin/mysql_secure_installationwhich will also give you the option of removing the test database.This i

26、s strongly recommended for production servers.See the manual for more instructions.Please report any problems at The latest information about MySQL is available on the web at Support MySQL by buying support/licenses at New default config file was created as /usr/f andwill be used by default by the s

27、erver when you start it.You may edit this file to change server settingsrootmysql01 Desktop# cat /root/.mysql_secret# The random password set for the root user at Fri Aug 28 10:57:02 2015 (local time): FY2X3PPff8VzaEn53、配置并启动mysql及设置开机自动启动rootmysql01 Desktop# cp /usr/share/mysql/my-f /etc/frootmysql

28、01 Desktop# ls -l /etc/f-rwxr-xr-x. 1 root root 1126 Aug 28 11:09 /etc/frootmysql01 Desktop# ps -ef | grep mysqlroot 5369 5167 0 11:10 pts/1 00:00:00 grep mysqlrootmysql01 Desktop# service mysql startStarting MySQL. OK rootmysql01 Desktop# service mysql statusMySQL running (5507) OK rootmysql01 Desk

29、top# chkconfig -list | grep mysqlmysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off备注：如2、3、4为off，即mysql位设置为开机自动启动，可以使用如下方法设置rootmysql01 Desktop# chkconfig -list | grep mysqlmysql 0:off 1:off 2:off 3:off 4:off 5:off 6:offrootmysql01 Desktop# chkconfig -level 2345 mysql onrootmysql01 Desktop# chkconfig -list | grep mysqlmysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off4、登录系统：rootmysql01 Desktop# mysql -uroot -pEnter password: FY2X3PPff8VzaEn5或者：rootmysql01 Desktop# mysql -u root -pEnter password: FY2X3PPff8VzaEn5或者：rootmysql0