查看已经安装的MYSQL包
yum list installed |grep mysql
去除旧版本的MYSQL:
yum -y remove mysql-libs.x86_64
下载yum source
wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
yum 本地安装:
yum localinstall mysql-community-release-el6-5.noarch.rpm
查看5.6是否enable
yum repolist enabled |grep mysql
直接安装
yum install mysql-community-server
参考以前配置文件修改 把数据文件日志文件指向 /data/mysql 目录
vim /etc/my.cnf
log-error=/data/mysql/mysqld.log
datadir=/data/mysql
max_connections = 2000
innodb_file_per_table = 1
innodb_buffer_pool_size = 4G
log_queries_not_using_indexes = 1
slow_query_log = 1
slow_query_log_file = /data/mysql/mysql-slow.log
cd /data
mkdir mysql
chown mysql:mysql mysql
启动MYSQL并初始化:
service mysqld restart
初始化权限 5.6 密码应该为空 5.7密码 在日志文件里面
mysql_secure_installation //设置权限和密码
service mysqld stop //服务暂停
service mysqld start //服务启动
参考:https://blog.csdn.net/wzhwei1987/article/details/50902722