centos 7 安装 mysql

1 配置 yum 源 

在 https://dev.mysql.com/downloads/repo/yum/ 找到 yum 源 rpm 安装包

例如想安装这个

1 wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

2 yum localinstall mysql80-community-release-el7-1.noarch.rpm

检查 mysql 源是否安装成功

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

安装 MySQL

yum install mysql-community-server

启动 MySQL 服务

systemctl start mysqld

查看 MySQL 状态

systemctl status mysqld

设置开机启动

1 systemctl enable mysqld

2 systemctl daemon-reload

修改 root 本地账户密码

1 查看默认密码

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

2 使用默认密码登陆mysql

mysql -u root -p 

3 ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

添加远程登录用户

GRANT ALL PRIVILEGES ON *.* TO 'zhangsan'@'%' IDENTIFIED BY 'Zhangsan2018!' WITH GRANT OPTION;

允许root 远程连接

use mysql;  

UPDATE user SET Host='%' WHERE User='root'; 

flush privileges;

设置默认编码为 utf8

1 vi /etc/my.cnf

2 添加如下内容

[mysqld] 
character-set-server=utf8 
[client] 
default-character-set=utf8 
[mysql] 
default-character-set=utf8 

3 重启mysql服务，查询编码。

1 systemctl restart mysqld 

2 登陆mysql

3 show variables like 'character%';

ps 

默认配置文件路径：

配置文件：/etc/my.cnf
日志文件：/var/log/var/log/mysqld.log
服务启动脚本：/usr/lib/systemd/system/mysqld.service
socket文件：/var/run/mysqld/mysqld.pid