CentOS安装MySql

[TOC]

1.下载[Yum Repository](https://dev.mysql.com/downloads/repo/yum/ )

2. 添加Yum Repository

rpm -Uvh *platform-and-version-specific-package-name*.rpm

注意：会遇到Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY异常，

原因：这是由于yum安装了旧版本的GPG keys造成的

解决办法：后面加上

--force --nodeps

rpm -Uvh *platform-and-version-specific-package-name*.rpm --force --nodeps

3. 安装MySql

yum install mysql-community-server

4. 启动MySql

service mysqld start

or (EL7-based 平台)

systemctl start mysqld.service

5.查看MySql运行状态

service mysqld status

or (EL7-based 平台)

systemctl status mysqld.service

6.查看root账户初始密码

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

7, 登录并修改密码

mysql -uroot -p;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'hoyNmX5zqgiIWJ0j!';

注意：会遇到ERROR 1819 (HY000): Your password does not satisfy the current policy requirements异常，最简单的解决办法就是把密码设置的复杂点。

8.查看端口号

show global variables like 'port';

9.修改端口号

修改/etc/my.cnf配置文件，增加port=6303，会将端口号设置为6303

10.重启MySql

service mysqld restart

or (EL7-based 平台)

systemctl restart mysqld.service