yum安装mysql

一、下载

mysql源安装包：wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

安装mysql源：yum -y install mysql57-community-release-el7-10.noarch.rpm

二、安装

yum -y install mysql-community-server

默认配置文件路径： 
配置文件：/etc/my.cnf 
日志文件：/var/log/mysqld.log 
服务启动脚本：/usr/lib/systemd/system/mysqld.service 
socket文件：/var/run/mysqld/mysqld.pid
数据：/var/lib/mysql/数据库名
二进制日志：/var/lib/mysql/mysql-bin.000001

三、启动MySQL服务并设置开机启动

systemctl start mysqld

systemctl enable mysqld

systemctl daemon-reload

四、端口开放

firewall-cmd --zone=public --add-port=3306/tcp --permanent

firewall-cmd --reload

五、修改root本地登录密码

 1）查看mysql密码

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

2019-09-10T05:38:23.232551Z 1 [Note] A temporary password is generated for root@localhost: /NKyEptZc5k1
2019-09-10T05:40:27.613697Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2019-09-10T06:34:36.355280Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)

2）连接mysql

mysql -uroot -p

/NKyEptZc5k1 #密码

3）修改密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Root123456!';

或者：

mysql> set password for 'root'@'localhost'=password('Root123456!'); 

六、添加远程登录用户

mysql> GRANT ALL PRIVILEGES ON *.* TO 'li'@'%' IDENTIFIED BY 'Li123456!' WITH GRANT OPTION;       #%可代替IP

用户名：li

密码：Li123456!