第三步:安装 MySql
1- 利用FTPRush 将 MySql 源 上传到/home/data/下
2- 安装MySQL源: yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
3- 在线安装MySQL 服务: yum -y install mysql-community-server
4- 启动 MySQL 服务
[root@localhost ~]# systemctl start mysqld
5- 设置开机启动
[root@localhost ~]# systemctl enable mysqld
[root@localhost ~]# systemctl daemon-reload
6- 修改root本地登录密码
打开:vi /var/log/mysqld.log
在文中查找自动生成的临时密码:" A temporary password …:“临时密码在这” "
用临时密码进入mysql命令行:mysql -u root -p
修改密码:
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘Coco1995@’;
设置允许远程登录(默认不允许)
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘Coco1995@’ WITH GRANT OPTION;
退出:exit
添加 3306 端口并重启防火墙:[root@localhost ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
[root@localhost ~]# firewall-cmd --reload
7- 设置编码:
打开文件:vi /etc/my.cnf
在[mysqld]下加入:character_set_server=utf8
init_connect=‘SET NAMES utf8’保存重启:systemctl restart mysqld
进入命令行 查看编码: mysql> show variables like ‘%character%’;
8- 测试