MySQL 5525rpm安装及升级到5626 for RedHat Enterprise Linux 64Word格式.docx
- 文档编号:16884928
- 上传时间:2022-11-26
- 格式:DOCX
- 页数:12
- 大小:19.33KB
MySQL 5525rpm安装及升级到5626 for RedHat Enterprise Linux 64Word格式.docx
《MySQL 5525rpm安装及升级到5626 for RedHat Enterprise Linux 64Word格式.docx》由会员分享,可在线阅读,更多相关《MySQL 5525rpm安装及升级到5626 for RedHat Enterprise Linux 64Word格式.docx(12页珍藏版)》请在冰豆网上搜索。
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-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).
580[Note]/usr/sbin/mysqld(mysqld5.6.25-enterprise-commercial-advanced)startingasprocess4981...
584981[Note]InnoDB:
Usingatomicstorefcountbufferpoolpages
TheInnoDBmemoryheapisdisabled
Mutexesandrw_locksuseGCCatomicbuiltins
Memorybarrierisnotused
Compressedtablesusezlib1.2.3
UsingLinuxnativeAIO
UsingCPUcrc32instructions
Initializingbufferpool,size=128.0M
Completedinitializationofbufferpool
Thefirstspecifieddatafile./ibdata1didnotexist:
anewdatabasetobecreated!
Settingfile./ibdata1sizeto12MB
Databasephysicallywritesthefilefull:
wait...
594981[Note]InnoDB:
Settinglogfile./ib_logfile101sizeto48MB
57:
004981[Note]InnoDB:
Settinglogfile./ib_logfile1sizeto48MB
014981[Note]InnoDB:
Renaminglogfile./ib_logfile101to./ib_logfile0
014981[Warning]InnoDB:
Newlogfilescreated,LSN=45781
Doublewritebuffernotfound:
creatingnew
Doublewritebuffercreated
128rollbacksegment(s)areactive.
Creatingforeignkeyconstraintsystemtables.
024981[Note]InnoDB:
Foreignkeyconstraintsystemtablescreated
Creatingtablespaceanddatafilesystemtables.
Tablespaceanddatafilesystemtablescreated.
Waitingforpurgetostart
5.6.25started;
logsequencenumber0
024981[Note]RSAprivatekeyfilenotfound:
/var/lib/mysql//private_key.pem.Someauthenticationpluginswillnotwork.
024981[Note]RSApublickeyfilenotfound:
/var/lib/mysql//public_key.pem.Someauthenticationpluginswillnotwork.
Arandomrootpasswordhasbeenset.Youwillfinditin'
/root/.mysql_secret'
.
034981[Note]Binlogend
034981[Note]InnoDB:
FTSoptimizethreadexiting.
Startingshutdown...
044981[Note]InnoDB:
Shutdowncompleted;
logsequencenumber1625977
040[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
040[Note]/usr/sbin/mysqld(mysqld5.6.25-enterprise-commercial-advanced)startingasprocess5006...
045006[Note]InnoDB:
HighestsupportedfileformatisBarracuda.
045006[Note]RSAprivatekeyfilenotfound:
045006[Note]RSApublickeyfilenotfound:
045006[Note]Binlogend
065006[Note]InnoDB:
logsequencenumber1625987
ARANDOMPASSWORDHASBEENSETFORTHEMySQLrootUSER!
Youwillfindthatpasswordin'
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:
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位设置为开机自动启动,可以使用如下方法设置
off3:
off4:
off5:
off6:
[root@mysql01Desktop]#chkconfig--level2345mysqlon
4、登录系统:
[root@mysql01Desktop]#mysql-uroot-p
Enterpassword:
[root@mysql01Desktop]#mysql-uroot-p
[root@mysql0
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- MySQL 5525rpm安装及升级到5626 for RedHat Enterprise Linux 64 5525 rpm 安装 升级 5626
链接地址:https://www.bdocx.com/doc/16884928.html