centos 安装mysql5.7版本

前端之家收集整理的这篇文章主要介绍了centos 安装mysql5.7版本前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

参考资料:https://www.linuxidc.com/Linux/2016-09/135288.htm

https://www.cnblogs.com/ivictor/p/5142809.html

 

1、配置yum源

  下载MysqL源安装包,shell> wget http://dev.MysqL.com/get/MysqL57-community-release-el7-8.noarch.rpm

  安装MysqL源:shell> yum localinstall MysqL57-community-release-el7-8.noarch.rpm

2、安装MysqL

  shell> yum install MysqL-community-server

3、启动MysqL服务

  systemctl start MysqLd

4、开机启动

  systemctrl enable MysqLd

  systemctrl daemon-reload

5、修改root本地密码

  首先在/var/log/MysqLd.log文件中,找到默认密码,如:A temporary password is generated for [email protected]: -g/-uX&JH1y7

  -g/-uX&JH1y7为默认密码。

  登录msyql

    MysqL -u root -p

    输入默认密码

  修改密码

  ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘MyNewPass4!‘;

  注意:一般情况下,此时会有报错,ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

  解决方法:设置密码策略

  MysqL> set global validate_password_policy=0;

  重新设置密码。

6、添加远程登录用户

  liunx默认只允许root账号在本地登录,如果要在机器登录,必须修改root允许远程连接,或者添加一个允许远程连接的账号

  GRANT ALL PRIVILEGES ON *.* TO ‘yangxin‘@‘%‘ IDENTIFIED BY ‘Yangxin0917!‘ WITH GRANT OPTION;

  yangxin为账号名,Yangxin0917!为密码。

7、配置默认编码为utf8

  修改/etc/my.cnf配置文件,在[MysqLd]下添加编码配置,如

  [MysqLd]

       character_set_server=utf8

        init_connect=‘SET NAMES utf8‘

  重启MysqL服务。systemctl restart MysqLd

  查看数据默认编码

  MysqL> show variables like ‘%character%‘;

猜你在找的CentOS相关文章