centos7安装mysql5.7

第一步下载mysql5.7安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

第二步安装mysql源

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

查看是否安装成功

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

安装mysql

yum install mysql-community-server

​ 启动mysql

systemctl start mysqld

查看mysql是否启动

systemctl status mysqld

设置mysql开机自启动

systemctl enable mysqld

查看mysql初始root密码

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

进入mysql

mysql -u root -p

设置允许使用简单密码

set global validate_password_policy=0;

设置允许使用密码长度

set global validate_password_length=1;

修改密码

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

允许root远程连接

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234456' WITH GRANT OPTION;FLUSH PRIVILEGES;

设置mysql数据库为utf-8编码

编辑/etc/my.cnf文件

因为my.cnf中没有[client]标签，所以我们添加一个

然后在这地下添加

default-character-set=utf8

在[mysqld]下添加

[mysqld]default-storage-engine=INNODBcharacter-set-server=utf8collation-server=utf8_general_ci

[client]一定要写在[mysqld]上面 否则会报错

最终配置为

[client]default-character-set=utf8[mysqld]default-storage-engine=INNODBcharacter-set-server=utf8collation-server=utf8_general_ci

重启mysql

systemctl restart mysqld

进入mysql查看字符编码是否修改成功

show variables like '%character%';

配置文件：/etc/my.cnf

日志文件：/var/log//var/log/mysqld.log

服务启动脚本：/usr/lib/systemd/system/mysqld.service

socket文件：/var/run/mysqld/mysqld.pid