MySQL 5525rpm安装及升级到5626 for RedHat Enterprise Linux 64.docx
《MySQL 5525rpm安装及升级到5626 for RedHat Enterprise Linux 64.docx》由会员分享,可在线阅读,更多相关《MySQL 5525rpm安装及升级到5626 for RedHat Enterprise Linux 64.docx(12页珍藏版)》请在冰豆网上搜索。
MySQL5525rpm安装及升级到5626forRedHatEnterpriseLinux64
MySQL5.5.25(rpm)安装及升级到5.6.26forRedHatEnterpriseLinux6.4
环境:
RedHatEnterpriseLinux6.4(64bit)MySQL:
5.6.25IP:
192.168.15.166
步骤一:
准备工作:
a、建议删除系统存在的mysql用户
[root@mysql01Desktop]#idmysql
uid=27(mysql)gid=27(mysql)groups=27(mysql)
[root@mysql01Desktop]#userdel-rmysql
b、清理已安装的mysql程序包
[root@suzzy~]#rpm-qa|grepmysql
mysql-server-5.1.66-2.el6_3.x86_64
dovecot-mysql-2.0.9-5.el6.x86_64
qt-mysql-4.6.2-25.el6.x86_64
rsyslog-mysql-5.8.10-6.el6.x86_64
mysql-5.1.66-2.el6_3.x86_64
mod_auth_mysql-3.0.0-11.el6_0.1.x86_64
mysql-devel-5.1.66-2.el6_3.x86_64
mysql-libs-5.1.66-2.el6_3.x86_64
使用rpm-e包名(都地上面显示)来清除安装包,如果碰到不能报错不能删除,加上参数--nodeps强制删除即可。
例如:
[root@suzzy~]#rpm-eqt-mysql-4.6.2-25.el6.x86_64
error:
Faileddependencies:
qt4-mysqlisneededby(installed)akonadi-1.2.1-2.el6.x86_64
[root@suzzy~]#rpm-eqt-mysql-4.6.2-25.el6.x86_64--nodeps
[root@suzzy~]#rpm-emysql-server-5.1.66-2.el6_3.x86_64--nodeps
[root@suzzy~]#rpm-edovecot-mysql-2.0.9-5.el6.x86_64--nodeps
[root@suzzy~]#rpm-eqt-mysql-4.6.2-25.el6.x86_64--nodeps
[root@suzzy~]#rpm-ersyslog-mysql-5.8.10-6.el6.x86_64--nodeps
[root@suzzy~]#rpm-emysql-5.1.66-2.el6_3.x86_64--nodeps
[root@suzzy~]#rpm-emod_auth_mysql-3.0.0-11.el6_0.1.x86_64--nodeps
[root@suzzy~]#rpm-emysql-devel-5.1.66-2.el6_3.x86_64--nodeps
[root@suzzy~]#rpm-emysql-libs-5.1.66-2.el6_3.x86_64--nodeps
直到下面语句找不到mysql包为止
[root@mysql01~]#rpm-qa|grepmysql
[root@mysql01~]#
注意:
在卸载完成之后需要删除配置文件/etc/f和数据库文件/var/lib/mysql,保守起见可将配置文件f进行改名处理。
[root@mysql01Desktop]#rpm-qplMySQL-client-advanced-5.6.25-1.el6.x86_64.rpm
[root@mysql01Desktop]#rpm-qplMySQL-devel-advanced-5.6.25-1.el6.x86_64.rpm
[root@mysql01Desktop]#rpm-qplMySQL-embedded-advanced-5.6.25-1.el6.x86_64.rpm
[root@mysql01Desktop]#rpm-qplMySQL-server-advanced-5.6.25-1.el6.x86_64.rpm
[root@mysql01Desktop]#rpm-qplMySQL-shared-advanced-5.6.25-1.el6.x86_64.rpm
[root@mysql01Desktop]#rpm-qplMySQL-shared-compat-advanced-5.6.25-1.el6.x86_64.rpm
[root@mysql01Desktop]#rpm-qplMySQL-test-advanced-5.6.25-1.el6.x86_64.rpm
步骤二:
开始安装
1、建立用户组及用户
[root@mysql01~]#groupaddmysql
[root@mysql01~]#useradd-gmysqlmysql
2、将下载好的mysql程序rpm包上传至服务器
此处略过
或者:
[root@mysql01Desktop]#unzipV76360-01.zip
[root@mysql01Desktop]#rpm-ivhMySQL-*
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###########################################[86%]
7:
MySQL-server-advanced###########################################[100%]
2015-08-2810:
56:
580[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
2015-08-2810:
56:
580[Note]/usr/sbin/mysqld(mysqld5.6.25-enterprise-commercial-advanced)startingasprocess4981...
2015-08-2810:
56:
584981[Note]InnoDB:
Usingatomicstorefcountbufferpoolpages
2015-08-2810:
56:
584981[Note]InnoDB:
TheInnoDBmemoryheapisdisabled
2015-08-2810:
56:
584981[Note]InnoDB:
Mutexesandrw_locksuseGCCatomicbuiltins
2015-08-2810:
56:
584981[Note]InnoDB:
Memorybarrierisnotused
2015-08-2810:
56:
584981[Note]InnoDB:
Compressedtablesusezlib1.2.3
2015-08-2810:
56:
584981[Note]InnoDB:
UsingLinuxnativeAIO
2015-08-2810:
56:
584981[Note]InnoDB:
UsingCPUcrc32instructions
2015-08-2810:
56:
584981[Note]InnoDB:
Initializingbufferpool,size=128.0M
2015-08-2810:
56:
584981[Note]InnoDB:
Completedinitializationofbufferpool
2015-08-2810:
56:
584981[Note]InnoDB:
Thefirstspecifieddatafile./ibdata1didnotexist:
anewdatabasetobecreated!
2015-08-2810:
56:
584981[Note]InnoDB:
Settingfile./ibdata1sizeto12MB
2015-08-2810:
56:
584981[Note]InnoDB:
Databasephysicallywritesthefilefull:
wait...
2015-08-2810:
56:
594981[Note]InnoDB:
Settinglogfile./ib_logfile101sizeto48MB
2015-08-2810:
57:
004981[Note]InnoDB:
Settinglogfile./ib_logfile1sizeto48MB
2015-08-2810:
57:
014981[Note]InnoDB:
Renaminglogfile./ib_logfile101to./ib_logfile0
2015-08-2810:
57:
014981[Warning]InnoDB:
Newlogfilescreated,LSN=45781
2015-08-2810:
57:
014981[Note]InnoDB:
Doublewritebuffernotfound:
creatingnew
2015-08-2810:
57:
014981[Note]InnoDB:
Doublewritebuffercreated
2015-08-2810:
57:
014981[Note]InnoDB:
128rollbacksegment(s)areactive.
2015-08-2810:
57:
014981[Warning]InnoDB:
Creatingforeignkeyconstraintsystemtables.
2015-08-2810:
57:
024981[Note]InnoDB:
Foreignkeyconstraintsystemtablescreated
2015-08-2810:
57:
024981[Note]InnoDB:
Creatingtablespaceanddatafilesystemtables.
2015-08-2810:
57:
024981[Note]InnoDB:
Tablespaceanddatafilesystemtablescreated.
2015-08-2810:
57:
024981[Note]InnoDB:
Waitingforpurgetostart
2015-08-2810:
57:
024981[Note]InnoDB:
5.6.25started;logsequencenumber0
2015-08-2810:
57:
024981[Note]RSAprivatekeyfilenotfound:
/var/lib/mysql//private_key.pem.Someauthenticationpluginswillnotwork.
2015-08-2810:
57:
024981[Note]RSApublickeyfilenotfound:
/var/lib/mysql//public_key.pem.Someauthenticationpluginswillnotwork.
Arandomrootpasswordhasbeenset.Youwillfinditin'/root/.mysql_secret'.
2015-08-2810:
57:
034981[Note]Binlogend
2015-08-2810:
57:
034981[Note]InnoDB:
FTSoptimizethreadexiting.
2015-08-2810:
57:
034981[Note]InnoDB:
Startingshutdown...
2015-08-2810:
57:
044981[Note]InnoDB:
Shutdowncompleted;logsequencenumber1625977
2015-08-2810:
57:
040[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
2015-08-2810:
57:
040[Note]/usr/sbin/mysqld(mysqld5.6.25-enterprise-commercial-advanced)startingasprocess5006...
2015-08-2810:
57:
045006[Note]InnoDB:
Usingatomicstorefcountbufferpoolpages
2015-08-2810:
57:
045006[Note]InnoDB:
TheInnoDBmemoryheapisdisabled
2015-08-2810:
57:
045006[Note]InnoDB:
Mutexesandrw_locksuseGCCatomicbuiltins
2015-08-2810:
57:
045006[Note]InnoDB:
Memorybarrierisnotused
2015-08-2810:
57:
045006[Note]InnoDB:
Compressedtablesusezlib1.2.3
2015-08-2810:
57:
045006[Note]InnoDB:
UsingLinuxnativeAIO
2015-08-2810:
57:
045006[Note]InnoDB:
UsingCPUcrc32instructions
2015-08-2810:
57:
045006[Note]InnoDB:
Initializingbufferpool,size=128.0M
2015-08-2810:
57:
045006[Note]InnoDB:
Completedinitializationofbufferpool
2015-08-2810:
57:
045006[Note]InnoDB:
HighestsupportedfileformatisBarracuda.
2015-08-2810:
57:
045006[Note]InnoDB:
128rollbacksegment(s)areactive.
2015-08-2810:
57:
045006[Note]InnoDB:
Waitingforpurgetostart
2015-08-2810:
57:
045006[Note]InnoDB:
5.6.25started;logsequencenumber1625977
2015-08-2810:
57:
045006[Note]RSAprivatekeyfilenotfound:
/var/lib/mysql//private_key.pem.Someauthenticationpluginswillnotwork.
2015-08-2810:
57:
045006[Note]RSApublickeyfilenotfound:
/var/lib/mysql//public_key.pem.Someauthenticationpluginswillnotwork.
2015-08-2810:
57:
045006[Note]Binlogend
2015-08-2810:
57:
045006[Note]InnoDB:
FTSoptimizethreadexiting.
2015-08-2810:
57:
045006[Note]InnoDB:
Startingshutdown...
2015-08-2810:
57:
065006[Note]InnoDB:
Shutdowncompleted;logsequencenumber1625987
ARANDOMPASSWORDHASBEENSETFORTHEMySQLrootUSER!
Youwillfindthatpasswordin'/root/.mysql_secret'.
Youmustchangethatpasswordonyourfirstconnect,
nootherstatementbut'SETPASSWORD'willbeaccepted.
Seethemanualforthesemanticsofthe'passwordexpired'flag.
Also,theaccountfortheanonymoususerhasbeenremoved.
Inaddition,youcanrun:
/usr/bin/mysql_secure_installation
whichwillalsogiveyoutheoptionofremovingthetestdatabase.
Thisisstronglyrecommendedforproductionservers.
Seethemanualformoreinstructions.
Pleasereportanyproblemsat
ThelatestinformationaboutMySQLisavailableonthewebat
SupportMySQLbybuyingsupport/licensesat
Newdefaultconfigfilewascreatedas/usr/fand
willbeusedbydefaultbytheserverwhenyoustartit.
Youmayeditthisfiletochangeserversettings
[root@mysql01Desktop]#cat/root/.mysql_secret
#TherandompasswordsetfortherootuseratFriAug2810:
57:
022015(localtime):
FY2X3PPff8VzaEn5
3、配置并启动mysql及设置开机自动启动
[root@mysql01Desktop]#cp/usr/share/mysql/my-f/etc/f
[root@mysql01Desktop]#ls-l/etc/f
-rwxr-xr-x.1rootroot1126Aug2811:
09/etc/f
[root@mysql01Desktop]#ps-ef|grepmysql
root53695167011:
10pts/100:
00:
00grepmysql
[root@mysql01Desktop]#servicemysqlstart
StartingMySQL..[OK]
[root@mysql01Desktop]#servicemysqlstatus
MySQLrunning(5507)[OK]
[root@mysql01Desktop]#chkconfig--list|grepmysql
mysql0:
off1:
off2:
on3:
on4:
on5:
on6:
off
备注:
如2、3、4为off,即mysql位设置为开机自动启动,可以使用如下方法设置
[root@mysql01Desktop]#chkconfig--list|grepmysql
mysql0:
off1:
off2:
off3:
off4:
off5:
off6:
off
[root@mysql01Desktop]#chkconfig--level2345mysqlon
[root@mysql01Desktop]#chkconfig--list|grepmysql
mysql0:
off1:
off2:
on3:
on4:
on5:
on6:
off
4、登录系统:
[root@mysql01Desktop]#mysql-uroot-p
Enterpassword:
FY2X3PPff8VzaEn5
或者:
[root@mysql01Desktop]#mysql-uroot-p
Enterpassword:
FY2X3PPff8VzaEn5
或者:
[root@mysql0