CentOS7下安装mysql5.7

安装yum Repo
进入官网找到5.7的yum源
https://www.mysql.com/downloads/



点进去后，点击下面的链接，右键复制链接地址：（https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm）

下载和安装yum源
在服务器上运行下载命令：wget [刚刚复制的链接]
继续输入安装命令：rpm -ivh mysql80-community-release-el7-3.noarch.rpm
执行完成后会在/etc/yum.repos.d/目录下生成两个repo文件mysql-community.repo mysql-community-source.repo

通过yum安装mysql
运行命令：yum install -y mysql-community-server

启动mysql服务
运行命令：systemctl start mysqld (开启数据库)
systemctl enable mysqld (开机自启数据库)

查看mysql的初始密码
grep 'password' /var/log/mysqld.log

修改初始密码
先通过上面的密码来登录mysql ：mysql -u root -p
输入修改密码的命令：ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'；

设置可远程访问
在mysql中运行：GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

相关命令

1、设置安全选项：
mysql_secure_installation

2、关闭MySQL
systemctl stop mysqld

3、重启MySQL
systemctl restart mysqld

4、查看MySQL运行状态
systemctl status mysqld

5、设置开机启动
systemctl enable mysqld

6、关闭开机启动
systemctl disable mysqld

7、配置默认编码为utf8：
vi /etc/my.cnf #添加 [mysqld] character_set_server=utf8 init_connect='SET NAMES utf8'