centos安装mysql

1.下载 Mysql yum包

下载地址：http://dev.mysql.com/downloads/repo/yum/

wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm

2.安装软件源

rpm -Uvh mysql57-community-release-el7-10.noarch.rpm

3.安装mysql服务器

yum install -y mysql-community-server

4.启动mysql

systemctl start mysqld.service

或者service mysqld start

5.检查mysql运行状态

service mysqld status

6.修改临时密码

6.1 获取临时密码

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

6.2 修改root密码

6.2.1 登录mysql

mysql -uroot -p

6.2.2 修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';

7.授权远程登录

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION; 
FLUSH PRIVILEGES;

8.mysql相关启动、停止、重启

service mysqld start/stop/restart

9.参考资料

https://www.cnblogs.com/silentdoer/articles/7258232.html

https://www.cnblogs.com/xiami-mj/p/6978650.html