首先我需要mysql發者網站載yum倉庫檔案匯入yum庫簡單yumupdate命令確保執行mysql5.6新發布版包括些安全特性更新yum同確保匯入相關依賴庫些都使我安裝程簡單化進入載redhatenterpriselinux6/oraclelinux6版
載完yum庫匯入本:
sudoyumlocalinstallmysql-community-release-el6-*.noarch.rpm
yum庫包含mysqlservermysql工作臺管理工具及odbc驅現通面命令簡單安裝mysqlserver:
sudoyuminstallmysql-community-server
至我使用yum簡單管理mysql更新並能確保總官網軟體庫新發布版
附錄:
1、rootpasswordupdatefailed
error1290(hy000):themysqlserverisrunningwiththe--skip-grant-tablesoptionsoitcannotexecutethisstatement.
解決辦:
[**@localhost~]#mysql
mysql>setglobalread_only=0;
queryok,0rowsaffected(0.00sec)
mysql>flushprivileges;
mysql>quit
[**@localhost~]#/usr/bin/mysql_secure_installation
便重新更新root密碼
2、[error]innodb:cannotcreatelogfilesbecausedatafilesarecorruptorthedatabasewasnotshutdowncleanlyaftercreatingthedatafiles.
#cd/var/lib/mysql
#mvibdata1ibdata1.bak
3、[error]innodb:spaceheaderpageconsistsofzerobytesindatafile./ibdata1
解決辦:修改配置檔案my.cnf
根據環境空間需求調節引數值
innodb_buffer_pool_size=256m
innodb_log_file_size=256m
innodb_thread_concurrency=16
innodb_flush_log_at_trx_commit=2
新增條:
innodb_flush_method=normal
4、error1045(28000):accessdeniedforuser"root"@"localhost"(usingpassword:no)
解決辦:google我遇情況候使用/usr/bin/mysql_secure_installation重新設定
首先我需要mysql發者網站載yum倉庫檔案匯入yum庫簡單yumupdate命令確保執行mysql5.6新發布版包括些安全特性更新yum同確保匯入相關依賴庫些都使我安裝程簡單化進入載redhatenterpriselinux6/oraclelinux6版
載完yum庫匯入本:
sudoyumlocalinstallmysql-community-release-el6-*.noarch.rpm
yum庫包含mysqlservermysql工作臺管理工具及odbc驅現通面命令簡單安裝mysqlserver:
sudoyuminstallmysql-community-server
至我使用yum簡單管理mysql更新並能確保總官網軟體庫新發布版
附錄:
1、rootpasswordupdatefailed
error1290(hy000):themysqlserverisrunningwiththe--skip-grant-tablesoptionsoitcannotexecutethisstatement.
解決辦:
[**@localhost~]#mysql
mysql>setglobalread_only=0;
queryok,0rowsaffected(0.00sec)
mysql>flushprivileges;
queryok,0rowsaffected(0.00sec)
mysql>quit
[**@localhost~]#/usr/bin/mysql_secure_installation
便重新更新root密碼
2、[error]innodb:cannotcreatelogfilesbecausedatafilesarecorruptorthedatabasewasnotshutdowncleanlyaftercreatingthedatafiles.
#cd/var/lib/mysql
#mvibdata1ibdata1.bak
3、[error]innodb:spaceheaderpageconsistsofzerobytesindatafile./ibdata1
解決辦:修改配置檔案my.cnf
根據環境空間需求調節引數值
innodb_buffer_pool_size=256m
innodb_log_file_size=256m
innodb_thread_concurrency=16
innodb_flush_log_at_trx_commit=2
新增條:
innodb_flush_method=normal
4、error1045(28000):accessdeniedforuser"root"@"localhost"(usingpassword:no)
解決辦:google我遇情況候使用/usr/bin/mysql_secure_installation重新設定