1.下载
$ wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
2.安装MySQL源 ,如果没有yum 移步安装
$ yum localinstall mysql57-community-release-el7-8.noarch.rpm
3.检查MySQL源是否安装成功
$ yum repolist enabled | grep "mysql.*-community.*"
4.安装MySQL
$ yum install mysql-community-server
5.启动MySQL服务
$ systemctl start mysqld
6.查看MySQL的启动状态
$ systemctl status mysqld
7.设置开机启动
$ systemctl enable mysqld
$ systemctl daemon-reload
8.获得root默认密码
$ grep 'temporary password' /var/log/mysqld.log
9.修改root密码(设置密码必须大小写字母+数字+特殊字符)
$ mysqladmin -u root -p password "Mshu1995."
Enter password: 【输入默认密码】
10.登陆root
$ mysql -uroot -p
Enter password: 【新密码】
11.退出MySQL
$ exit
12.设置用户(mshu)允许远程连接
$ GRANT ALL PRIVILEGES ON *.* TO 'mshu'@'%' IDENTIFIED BY 'Mshu1995.' WITH GRANT OPTION;
$ flush privileges;
13.想要远程连接还需关闭防火墙(仅适用于CentOs7)
1.$ firewall-cmd --state //查看防火墙状态
---run //开启状态
---not run //关闭状态
2. $ systemctl stop firewalld.service //关闭防火墙
$ systemctl disable firewalld.service //禁止firewall开机启动
14.设置编码
1.修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置,如下所示:
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
2.重新启动mysql服务
$ service mysqld restart
3. 查看数据库默认编码
$ show variables like '%character%';