如何从MySQL官方Yum仓库安装MySQL5.6
\u5982\u4f55\u4eceMySQL\u5b98\u65b9Yum\u4ed3\u5e93\u5b89\u88c5MySQL5.6\u3000\u9996\u5148\u6211\u4eec\u9700\u8981\u4eceMySQL\u5f00\u53d1\u8005\u7f51\u7ad9\u4e0b\u8f7dYum\u4ed3\u5e93\u6587\u4ef6\uff0c\u5bfc\u5165Yum\u5e93\u540e\uff0c\u4e00\u4e2a\u7b80\u5355\u7684yumupdate\u547d\u4ee4\u5c06\u786e\u4fdd\u4f60\u8fd0\u884c\u5728MySQL5.6\u7684\u6700\u65b0\u53d1\u5e03\u7248\u4e0a\uff0c\u5305\u62ec\u4e00\u4e9b\u5b89\u5168\u7279\u6027\u7684\u66f4\u65b0\u3002Yum\u540c\u65f6\u4e5f\u5c06\u786e\u4fdd\u5bfc\u5165\u76f8\u5173\u4f9d\u8d56\u5e93\uff0c\u8fd9\u4e9b\u90fd\u5c06\u4f7f\u6211\u4eec\u7684\u5b89\u88c5\u8fc7\u7a0b\u7b80\u5355\u5316\u3002\u8fdb\u5165\u4e0b\u8f7dRedHat Enterprise Linux 6 / Oracle Linux 6\u7248\u3002
\u3000\u3000\u70b9\u51fb\u94fe\u63a5No thanks, just start my download.\u76f4\u63a5\u4e0b\u8f7d\u3002
\u3000\u3000\u4e0b\u8f7d\u5b8c\u6210\u540e\u5c06Yum\u5e93\u5bfc\u5165\u5230\u4f60\u7684\u672c\u5730\uff1a
\u3000\u3000sudo yum localinstallmysql-community-release-el6-*.noarch.rpm
\u3000\u3000\u8fd9\u4e2aYum\u5e93\u5305\u542b\u4e86MySQLServer\uff0cMySQL\u5de5\u4f5c\u53f0\u7ba1\u7406\u5de5\u5177\u4ee5\u53caODBC\u9a71\u52a8\uff0c\u73b0\u5728\u53ef\u4ee5\u901a\u8fc7\u4e0b\u9762\u7684\u547d\u4ee4\u7b80\u5355\u5730\u5b89\u88c5MySQLServer\uff1a
\u3000\u3000sudo yum install mysql-community-server
\u3000\u3000\u81f3\u6b64\u6211\u5c31\u53ef\u4ee5\u4f7f\u7528Yum\u7b80\u5355\u5730\u7ba1\u7406MySQL\u66f4\u65b0\uff0c\u5e76\u80fd\u786e\u4fdd\u603b\u662f\u4ece\u5b98\u7f51\u8f6f\u4ef6\u5e93\u5f97\u5230\u6700\u65b0\u7684\u53d1\u5e03\u7248\u3002
\u3000\u3000\u9644\u5f55\uff1a
\u3000\u30001\u3001root password update failed
\u3000\u3000ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement.
\u3000\u3000\u89e3\u51b3\u529e\u6cd5\uff1a
\u3000\u3000[**@localhost ~]# mysql
mysql> set global read_only=0;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
[**@localhost ~]# /usr/bin/mysql_secure_installation
\u3000\u3000\u5982\u6b64\u4fbf\u53ef\u4ee5\u91cd\u65b0\u66f4\u65b0root\u5bc6\u7801\u4e86\uff01
\u3000\u30002\u3001[ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files.
\u3000\u3000\u89e3\u51b3\u529e\u6cd5\uff1a\u8fdb\u5165\u4f60\u7684mysql\u6570\u636e\u5b58\u653e\u76ee\u5f55\uff0c\u5220\u9664ibdata1\u6587\u4ef6\u5373\u53ef\uff0c\u4f8b\u5982\u5728\u6211\u7684\u73af\u5883\u4e0b
\u3000\u3000#cd /var/lib/mysql
#mv ibdata1 ibdata1.bak
3\u3001[ERROR] InnoDB: space header page consists of zero bytes in data file ./ibdata1
\u89e3\u51b3\u529e\u6cd5\uff1a\u4fee\u6539\u914d\u7f6e\u6587\u4ef6my.cnf
\u3000\u3000\u6839\u636e\u4e2a\u4eba\u73af\u5883\u7a7a\u95f4\u5927\u5c0f\u548c\u9700\u6c42\u8c03\u8282\u5982\u4e0b\u53c2\u6570\u7684\u503c
\u3000\u3000innodb_buffer_pool_size = 256M
innodb_log_file_size = 256M
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 2
\u6dfb\u52a0\u4e00\u6761\uff1a
\u3000\u3000innodb_flush_method=normal
4\u3001ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
\u89e3\u51b3\u529e\u6cd5\uff1aGoogle\u4e0a\u6709\u5f88\u591a\uff0c\u6211\u9047\u5230\u8fd9\u4e2a\u60c5\u51b5\u7684\u65f6\u5019\u53ea\u662f\u4f7f\u7528/usr/bin/mysql_secure_installation \u91cd\u65b0\u8bbe\u7f6e\u4e00\u6b21\u3002
2\u3001\u5b89\u88c5Mysql\u670d\u52a1\u5668\u7aef\uff1a yum install -y mysql55 mysql55-server
3\u3001\u5982\u679c\u62a5\u9519\uff0c\u8bf4\u5df2\u7ecf\u5b58\u5728\u4e86\uff0c\u90a3\u5c31\u79fb\u9664\u5df2\u6709\u7684\u5305\uff1ayum remove mysql mysql-server
4\u3001\u79fb\u9664\u540e\uff0c\u7ee7\u7eed\u5b89\u88c5\uff1a yum install -y mysql55 mysql55-server
5\u3001\u67e5\u770b\u4e00\u4e0b\u5df2\u5b89\u7684\u548c\u672a\u5b89\u88c5\u7684\u5305 \uff1aryum list mysql55\u73b0\u5728\u5c31\u5b89\u88c5\u5b8c\u4e86\uff0c\u53ef\u4ee5\u542f\u52a8\u4e86\uff0c\u54c8\u54c8
1、yum list mysql*; //列出mysql的版本号
2、yum install mysql-xxserver*; //安装即可。
绛旓細鑷姩鍖栬繍缁村繀澶囨妧鑳解旀惌寤哄睘浜庤嚜宸辩殑YUM浠撳簱http://blog.oldboyedu.com/autodeploy-yum/銆備簩杩涘埗鍏嶇紪璇戝畨瑁呮柟寮忓緢绠鍗曟柟渚匡紝涓旈傚悎5.0-5.1鍜5.5-5.7绯诲垪锛屾槸涓嶅皯涓撲笟DBA鐨勯夋嫨锛屾櫘閫歀inux杩愮淮浜哄憳涓鑸閲囩敤缂栬瘧鐨勬柟寮忓畨瑁咃紝瀵瑰簲鍒MySQL5.0-5.1绯诲垪灏辨槸甯歌缂栬瘧鏂瑰紡锛屽搴斿埌MySQL5.5-5.7绯诲垪灏辨槸...
绛旓細鏈枃璇︾粏鎻忚堪浜哃inux濡備綍鐢yum鏂瑰紡瀹夎mysql浠ュ強濡備綍淇敼mysql鐨鏁版嵁鏂囦欢瀛樻斁浣嶇疆 鏌ョ湅鏄惁瀹夎mysql锛 yum list installed | grep mysql鏈夌殑璇濋渶瑕佺Щ闄ゃ 濡傦細锛歽um -y remove mysql-libs.x86_64 鏌ョ湅yum搴撲笂鐨刴ysql鐗堟湰淇℃伅(CentOS绯荤粺闇瑕佹甯歌繛鎺ョ綉缁)銆 yum list|grep mysql 瀹夎锛歽um -y install ...
绛旓細linux涓嬩娇鐢yum瀹夎mysql锛屼互鍙婂惎鍔ㄣ佺櫥褰曞拰杩滅▼璁块棶銆1銆佸畨瑁 鏌ョ湅鏈夋病鏈夊畨瑁呰繃锛歽um list installed mysql rpm -qa | grep mysql 鏌ョ湅鏈夋病鏈夊畨瑁呭寘锛歽um list mysql 瀹夎mysql瀹㈡埛绔細yum install mysql 瀹夎mysql 鏈嶅姟鍣ㄧ锛歽um install mysql-server yum install mysql-devel 2銆佸惎鍔&&鍋滄 鏁版嵁搴...
绛旓細棣栧厛閫夋嫨姝ｇ‘鐨勪簯yum婧 MYSQL鐨剏um婧愬湪瀹樼綉 浠ヤ笅浠entos7鍜宑entos8涓轰緥 涓嬭浇婧 瀹夎婧 锛堣繖涓簮閲岄潰鏈8.0鍜5.7,涓や釜鐗堟湰绛変笅浼氬鍔5.6鍜5.5锛夊埌婧愬湴鍧涓嬭繘琛屼慨鏀规簮鏂囦欢杩涜鐗堟湰澧炲姞 鏌ョ湅杈撳嚭 浠ヤ笂鐪嬭捣鏉ユ尯澶氬彧瑕佷慨鏀瑰叾涓竴涓枃浠跺嵆鍙 淇敼yum婧 浠ヤ笂yum杩樻槸8.0鍦ㄥ惎鐢 enabled=1 鏀规垚enabled=0...
绛旓細linux涓嬩娇鐢yum瀹夎mysql锛屼互鍙婂惎鍔ㄣ佺櫥褰曞拰杩滅▼璁块棶銆1銆佸畨瑁 鏌ョ湅鏈夋病鏈夊畨瑁呰繃锛歽um list installed mysql rpm -qa | grep mysql 鏌ョ湅鏈夋病鏈夊畨瑁呭寘锛歽um list mysql 瀹夎mysql瀹㈡埛绔細yum install mysql 瀹夎mysql 鏈嶅姟鍣ㄧ锛歽um install mysql-server yum install mysql-devel 2銆佸惎鍔&&鍋滄 鏁版嵁搴...
绛旓細寰堥珮鍏存偍瑙ｇ瓟 1銆佸畨瑁 鏌ョ湅娌″畨瑁咃細yum list installed mysql rpm -qa | grep mysql 鏌ョ湅娌″畨瑁呭寘锛歽um list mysql 瀹夎mysql瀹㈡埛绔細yum install mysql 瀹夎mysql 鏈嶅姟鍣ㄧ锛歽um install mysql-server yum install mysql-devel 2銆佸惎&&鍋滄 鏁版嵁搴撳瓧绗﹂泦璁剧疆 mysql閰嶇疆鏂囦欢/etc/my.cnf鍔犲叆default-...
绛旓細http://dev.mysql.com/downloads/repo/ 2.#yum localinstall -y mysql-community-release-el6-5.noarch.rpm 3.#cd /etc/yum.repos.d/ 4.#vi mysql-community.repo 鏌ョ湅涓涓嬪唴瀹 5.#yum remove mysql 6.#yum install mysql 7.#yum install mysql-server 8.瀹屾瘯 浠庢渶鏂扮殑闄嶇骇锛屽鏋滈亣鍒...
绛旓細濡備綍姝ｇ‘瀹夎Mysql锛mysql鍦╨inux涓嬫湁涓夌瀹夎鏂瑰紡锛屼緷鐓ч毦浠ョ▼搴︽帓搴忥細绗竴绉嶆槸yuminstallmysql锛岃繖绉嶅畨瑁呮柟寮忔渶绠鍗曪紝鍒濆鍙互閲囩敤銆備絾鏄繖绉嶅畨瑁呯殑寮婄鏄畨瑁呯殑鐗堟湰姣旇緝浣庯紝鐜板湪瀹夎鐨勮瘽鏄5.17鐨勭増鏈傜浜岀鏂瑰紡鏄笅杞芥渶鏂扮殑MySQL-5.6.25-1.rhel5.x86_64.rpm-bundle.tar锛岃В鍘嬬缉鍚庯紝鐢╮pm-ivh鍖呭悕...
绛旓細棣栧厛閫夋嫨姝ｇ‘鐨勪簯yum婧 MYSQL鐨剏um婧愬湪瀹樼綉 浠ヤ笅浠entos7鍜宑entos8涓轰緥 涓嬭浇婧 瀹夎婧愶紙杩欎釜婧愰噷闈㈡湁8.0鍜5.7,涓や釜鐗堟湰锛屼笅涓绡囦細浠嬬粛濡備綍澧炲姞鍏朵粬鐗堟湰锛夋煡鐪嬪綋鍓嶅彲瀹夎鐨mysql鐗堟湰 浠ヤ笂婧愰粯璁ゆ槸8.0鐗堟湰鐨 闇瑕8.0鍙互鐩存帴杩愯瀹夎锛堟洿鎹5.7鐣ヨ繃姝ゆ楠わ級鏌ョ湅搴撲腑鎵鏈夌増鏈 濡傛灉鎴戜滑瑕侀夋嫨鐗堟湰锛...
绛旓細1銆佸畨瑁 鏌ョ湅鏈夋病鏈夊畨瑁呰繃锛 yum list installed mysql* rpm -qa | grep mysql* 鏌ョ湅鏈夋病鏈夊畨瑁呭寘锛 yum list mysql* 瀹夎mysql瀹㈡埛绔細 yum install mysql 瀹夎mysql 鏈嶅姟鍣ㄧ锛 yum install mysql-server yum install mysql-devel 2銆佸惎鍔&&鍋滄 鏁版嵁搴撳瓧绗﹂泦璁剧疆 mysql閰嶇疆鏂囦欢/etc/my.cnf涓...
