如何从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

\u4e0b\u8f7d\u5b8c\u6210\u540e\u5c06Yum\u5e93\u5bfc\u5165\u5230\u4f60\u7684\u672c\u5730\uff1a
sudo yum localinstallmysql-community-release-el6-*.noarch.rpm
\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
sudo yum install mysql-community-server
\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
\u9644\u5f55\uff1a
1\u3001root password update failed
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement.
\u89e3\u51b3\u529e\u6cd5\uff1a
[**@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
\u5982\u6b64\u4fbf\u53ef\u4ee5\u91cd\u65b0\u66f4\u65b0root\u5bc6\u7801\u4e86\uff01

2\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.

\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
#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
\u6839\u636e\u4e2a\u4eba\u73af\u5883\u7a7a\u95f4\u5927\u5c0f\u548c\u9700\u6c42\u8c03\u8282\u5982\u4e0b\u53c2\u6570\u7684\u503c
innodb_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
innodb_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

下载完成后将Yum库导入到你的本地：
sudo yum localinstallmysql-community-release-el6-*.noarch.rpm
这个Yum库包含了MySQLServer，MySQL工作台管理工具以及ODBC驱动，现在可以通过下面的命令简单地安装MySQLServer：
sudo yum install mysql-community-server
至此我就可以使用Yum简单地管理MySQL更新，并能确保总是从官网软件库得到最新的发布版。
附录：
1、root password update failed
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement.
解决办法：
[**@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
如此便可以重新更新root密码了！

2、[ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files.

解决办法：进入你的mysql数据存放目录，删除ibdata1文件即可，例如在我的环境下
#cd /var/lib/mysql
#mv ibdata1 ibdata1.bak

下载完成后将Yum库导入到你的本地：
sudo yum localinstallmysql-community-release-el6-*.noarch.rpm
这个Yum库包含了MySQLServer，MySQL工作台管理工具以及ODBC驱动，现在可以通过下面的命令简单地安装MySQLServer：
sudo yum install mysql-community-server
至此我就可以使用Yum简单地管理MySQL更新，并能确保总是从官网软件库得到最新的发布版。
附录：
1、root password update failed
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement.
解决办法：
[**@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
如此便可以重新更新root密码了！

2、[ERROR] InnoDB: Cannot create log files because data files are corrupt or the database was not shut down cleanly after creating the data files.

解决办法：进入你的mysql数据存放目录，删除ibdata1文件即可，例如在我的环境下
#cd /var/lib/mysql
#mv ibdata1 ibdata1.bak
3、[ERROR] InnoDB: space header page consists of zero bytes in data file ./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、ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
解决办法：Google上有很多，我遇到这个情况的时候只是使用/usr/bin/mysql_secure_installation 重新设置一次。

鎬庝箞浠嶮ySQL瀹樻柟Yum浠撳簱瀹夎MySQL5.6
绛旓細棣栧厛鎴戜滑闇瑕浠嶮ySQL寮鍙戣呯綉绔欎笅杞Yum浠撳簱鏂囦欢锛屽鍏um搴撳悗锛屼竴涓畝鍗曠殑yumupdate鍛戒护灏嗙‘淇濅綘杩愯鍦∕ySQL5.6鐨勬渶鏂板彂甯冪増涓婏紝鍖呮嫭涓浜涘畨鍏ㄧ壒鎬х殑鏇存柊銆俌um鍚屾椂涔熷皢纭繚瀵煎叆鐩稿叧渚濊禆搴擄紝杩欎簺閮藉皢浣挎垜浠殑瀹夎杩囩▼绠鍗曞寲銆傝繘鍏ttp://dev.mysql.com/downloads/repo/锛屼笅杞絉edHat Enterprise Linux 6 / Ora...

濡備綍浠嶮ySQL瀹樻柟Yum浠撳簱瀹夎MySQL5.6
绛旓細1銆侀鍏堥渶瑕浠嶮ySQL寮鍙戣呯綉绔欎笅杞Yum浠撳簱鏂囦欢锛屽鍏um搴撳悗锛屼竴涓畝鍗曠殑yumupdate鍛戒护灏嗙‘淇濊繍琛屽湪MySQL5.6鐨勬渶鏂板彂甯冪増涓婏紝鍖呮嫭涓浜涘畨鍏ㄧ壒鎬х殑鏇存柊銆俌um鍚屾椂涔熷皢纭繚瀵煎叆鐩稿叧渚濊禆搴擄紝杩欎簺閮藉皢浣垮畨瑁呰繃绋嬬畝鍗曞寲銆傝繘鍏ttp://dev.mysql.com/downloads/repo/锛屼笅杞絉edHat Enterprise Linux 6 / Oracle Linux...

濡備綍浠嶮ySQL瀹樻柟Yum浠撳簱瀹夎MySQL5.6
绛旓細棣栧厛鎴戦渶瑕MySQL鍙戣呯綉绔欒浇Yum浠撳簱鏂囦欢瀵煎叆Yum搴撶畝鍗晊umupdate鍛戒护纭繚杩愯MySQL5.6鏂板彂甯冪増鍖呮嫭浜涘畨鍏ㄧ壒鎬ф洿鏂癥um鍚岀‘淇濆鍏ョ浉鍏充緷璧栧簱浜涢兘浣挎垜瀹夎绋嬬畝鍗曞寲杩涘叆杞絉edHat Enterprise Linux 6 / Oracle Linux 6鐗 鐐瑰嚮閾炬帴No thanks, just start my download.鐩存帴杞 杞藉畬Yum搴撳鍏ユ湰锛歴udo yum localinstall...

濡備綍浠嶮ySQL瀹樻柟Yum浠撳簱瀹夎MySQL5.6
绛旓細1銆yum list mysql*; //鍒楀嚭mysql鐨鐗堟湰鍙 2銆亂um install mysql-xxserver*; //瀹夎鍗冲彲銆

mysql瀹夎鏁欑▼
绛旓細1锛庝娇鐢yum瀹夎mysql鏁版嵁搴撶殑杞欢鍖 [root@xuegod63 ~]# yum -y install mariadb-server mariadb 娉細mariadb-server #MariaDB鏁版嵁搴 mariadb # MariaDB鏈嶅姟鍣↙inux涓嬪鎴风 娉細浠巆entos7绯荤粺寮濮嬶紝绯荤粺涓嚜甯︾殑mysql鏁版嵁搴撳彉鎴愪簡mariadb-server锛宮ariadb-server鍜宮ysql鎿嶄綔涓婁竴鏍枫俶ariadb-...

鎬庝箞鏍浣跨敤yum鏉ュ畨瑁mysql
绛旓細1銆佸畨瑁 鏌ョ湅鏈夋病鏈夊畨瑁呰繃锛 yumlistinstalledmysql* rpm-qa|grepmysql* 鏌ョ湅鏈夋病鏈夊畨瑁呭寘锛 yumlistmysql* 瀹夎mysql瀹㈡埛绔細 yuminstallmysql 瀹夎mysql鏈嶅姟鍣ㄧ锛 yuminstallmysql-server yuminstallmysql-devel 2銆佸惎鍔ㄥ仠姝 鏁版嵁搴撳瓧绗﹂泦璁剧疆 mysql閰嶇疆鏂囦欢/etc/my.cnf涓姞鍏efault-character-set=utf...

linux瀹夎mysqllinux瑁卪ysql
绛旓細鐐瑰嚮鈥淒ownload鈥,涓嬫媺鍒版渶涓嬮潰锛岄夋嫨绀惧尯鐗堢殑杩涜涓嬭浇锛屽湪璺宠浆鐨勬柊椤甸潰缁х画鐐瑰嚮鈥淒ownload鈥濋夋嫨瀵瑰簲鐨勬搷浣滅郴缁熺増鏈拰浣嶆暟锛屼笅杞藉搴旂殑yum浠撳簱锛岀偣鍑烩淒ownloadnow鈥,鍦ㄨ烦杞殑鏂伴〉闈腑涓嬭浇鎿嶄綔绯荤粺瀵瑰簲鐨勭増鏈湪璺宠浆鐨勬柊鐨勯〉闈腑浼氭彁绀虹櫥褰曪紝閫夋嫨鐩存帴涓嬭浇涓婁紶鍒版湇鍔″櫒骞跺畨瑁mysql鐨剏um浠撳簱 ...

MySQL瀹樼綉娌℃湁centos鐗堟湰鐨勬暟鎹簱,搴旇涓嬭浇閭ｄ竴涓増鏈
绛旓細Centos灏辨槸redhat鐨勭ぞ鍖哄彂琛岀増锛屽唴鏍告槸涓鏍风殑锛岄夋嫨涓巖edhat瀵瑰簲鐗堟湰鍗冲彲銆傛瘮濡備綘鏄痗entos 6 閭ｅ氨閫夋嫨redhat 6

鎬庝箞鏍浣跨敤yum鏉ュ畨瑁mysql
绛旓細1銆佺敤yum瀹夎mysql鏈嶅姟绔 yum install mysql-server mysql-devel璇存槑锛歽um鏄痳edhat绯诲垪linux鐗堟湰涓婄殑鍖呯鐞嗗伐鍏凤紝install鏄痽um鐨勫弬鏁拌〃绀哄畨瑁咃紝mysql-server鏄mysql鐨鏈嶅姟绔紝mysql-devel鏄紪璇戞ā鍧楁椂鎵闇瑕佺殑鍖呭拰搴撴枃浠躲2銆佺敤yum瀹夎mysql瀹㈡埛绔 yum install mysql璇存槑锛歽um鏄痳edhat绯诲垪linux鐗堟湰涓婄殑鍖呯鐞...

Centos7瀹夎mysql缂轰箯yum婧鎬庝箞瀹夎?
绛旓細1锛歸get http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm 2锛氬畨瑁卪ysql-community-release-el7-5.noarch.rpm鍖 3锛歳pm -ivh mysql-community-release-el7-5.noarch.rpm 4.瀹夎杩欎釜鍖呭悗锛屼細鑾峰緱涓や釜mysql鐨剏um repo婧 [root@localhost ~]# ls -1 /etc/yum.repos.d/mysql-...