如何从MySQL官方Yum仓库安装MySQL5.6

Question

如题所述

Answer 1

首先我需要MySQL发者网站载Yum仓库文件导入Yum库简单yumupdate命令确保运行MySQL5.6新发布版包括些安全特性更新Yum同确保导入相关依赖库些都使我安装程简单化进入载RedHat Enterprise Linux 6 / Oracle Linux 6版

　　点击链接No thanks, just start my download.直接载

　　载完Yum库导入本：

　　sudo yum localinstallmysql-community-release-el6-*.noarch.rpm

　　Yum库包含MySQLServerMySQL工作台管理工具及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 重新设置