MySQL调优(一)-CentOS7安装MySQL

CentOS7 安装MySQL5.7

# CentOS-Base.repo文件备份
mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup 
wget -O /etc/yum.repos.d/CentOS-Base.repo 
# 执行更换yum源的命令
http://mirrors.aliyun.com/repo/Centos-6.repo 
# 更新本地缓存
yum clean all
yum makecache
# 查看系统中是否自带安装mysql
yum list installed | grep mysql 
# 删除系统自带的mysql及其依赖（防止冲突）
yum -y remove mysql-libs.x86_64 
wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm 
# 下载rpm
yum install mysql57-community-release-el7-10.noarch.rpm -y  
# 安装下载好的rpm文件
cd /etc/yum.repos.d/
# 启用mysql5.7
vi mysql-community.repo 
# 使用yum安装mysql
yum install mysql-community-server -y 
# 启动mysql服务
service mysqld start 
# 设置mysql开机启动
chkconfig mysqld on
# 获取mysql的临时密码
grep "password" /var/log/mysqld.log 
# 使用临时密码登录
mysql -uroot -p 

# 修改密码
set global validate_password_policy=0;
set global validate_password_length=1;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

# 修改远程访问权限
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;

# 查询 mysql 字符集
show variables like '%char%';
cp /usr/share/mysql/my-default.cnf   /etc/my.cnf
# 设置字符集为utf-8
vi my.cnf
# 在[mysqld]下面加入：
character-set-server=utf8
# 在文件末尾新增[client]段，并在[client]段添加： 
default-character-set=utf8
collation-server=utf8_general_ci

# 重启 mysql 服务
service mysqld restart  
# 再次登录 MySQL ，查看字符集是否修改
mysql -uroot -p123456
show variables like '%char%' 

#但此时还有一个问题，就是因为安装了Yum Repository，以后每次yum操作都会自动更新，需要把这个卸载掉：
yum -y remove mysql57-community-release-el7-10.noarch

启用mysql5.7
vi mysql-community.repo