Centos7下安装MySQL5.7

2019独角兽企业重金招聘Python工程师标准>>>

下载源安装包

从MySQL官网上找到mysql的源下载地址

https://dev.mysql.com/downloads/repo/yum/

下载安装包

wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm

安装源

yum localinstall mysql57-community-release-el7-11.noarch.rpm

检查是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

安装mysql

yum install mysql-community-server

启动mysql

service mysqld start

安装完后，mysql会默认生成一个密码

grep 'temporary password' /var/log/mysqld.log

修改密码

set password for 'root'@'localhost'=password('XXXX');

添加一个远程账号

grant all privileges on *.* to 'XXXX'@'%' identified by 'XXXX!' with  grant option;

flush privileges;

PS: 因为MySQL5.7默认安装了密码安全插件，默认密码检查策略要求密码必须包含：大小写字母、数字和特殊符号，并且长度不能少于8位。

修改默认编码

vim /etc/my.cnf

## [mysqld]下增加配置
[mysqld]

character_set_server=utf8
init_connect='SET NAMES utf8'

添加到开机启动项

systemctl enable mysqld
systemctl daemon-reload

重启mysql

service mysqld restart

 

转载于:https://my.oschina.net/liangguoqiang/blog/1789543