首页 CentOS Linux( CentOs7 )下安装MySQL

Linux( CentOs7 )下安装MySQL

1.下载 $ wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm 2.安装MySQL源 ,如果没有yum 移步安装https://segmentfault.com/n/1330000014274523 $ yum localinstall mysql57-community-release-el7-8.noarch.rpm 3.检查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%';

本文来自网络,不代表云浮站长网立场。转载请注明出处: https://www.0766zz.com/html/zhonghe/fwq/centos/20200901/9143.html
上一篇
下一篇

作者: dawei

【声明】:云浮站长网内容转载自互联网,其相关言论仅代表作者个人观点绝非权威,不代表本站立场。如您发现内容存在版权问题,请提交相关链接至邮箱:bqsm@foxmail.com,我们将及时予以处理。

为您推荐

返回顶部