Linux( CentOs7 )下安装MySQL

前端之家收集整理的这篇文章主要介绍了Linux( CentOs7 )下安装MySQL前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

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%';

猜你在找的CentOS相关文章