centos 7 安装 mysql 服务端

1. 添加源

选择合适本系统的源

## 下载源(如不可用, 可以去官网用oracle账号下载)
wget 'https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm'
## 安装源
sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
## 查看mysql 列表
yum repolist all | grep mysql

2. 安装

sudo yum install mysql-server -y

3. 启动

## 启动
systemctl start mysqld
## 查看状态
systemctl status mysqld

4. 设置密码

查看默认密码

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

ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';

5. 开机自启

vim /etc/rc.local
添加service mysqld start

6. 修改默认编码

在 /etc/my.cnf 中设置默认的编码

default-storage-engine = INNODB
character-set-server = utf8
collation-server = utf8_general_ci #不区分大小写
collation-server =  utf8_bin #区分大小写
collation-server = utf8_unicode_ci #比 utf8_general_ci 更准确

7. 创建数据库和用户

刷新使权限生效

flush privileges

CREATE DATABASE <datebasename> CHARACTER SET utf8;
CREATE USER 'username'@'host' IDENTIFIED BY 'password'; GRANT privileges ON databasename.tablename TO 'username'@'host'; SHOW GRANTS FOR 'username'@'host'; REVOKE privilege ON databasename.tablename FROM 'username'@'host'; DROP USER 'username'@'host';