CentOS安装MySQL

1、下载文件

MySQL :: Download MySQL Yum Repository

 2、安装mysql

将下载的文件上传到centos服务器。运行以下命令：

yum -y localinstall mysql80-community-release-el7-7.noarch.rpm 
yum install mysql-server

然后一路y就可以了

3、启动mysql服务

systemctl start mysqld
systemctl status mysqld

#查看mysql临时密码：
grep 'temporary password' /var/log/mysqld.log

#登录mysql
mysql -u root -p

#设置root新密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

#创建新账户并分配权限
CREATE USER 'finley'@'localhost'  IDENTIFIED BY 'password';
GRANT ALL ON *.*  TO 'finley'@'localhost'  WITH GRANT OPTION;

4、放行端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent   # 开放5672端口
firewall-cmd --reload   # 配置立即生效