CentOS 安装Mysql 5.7

Windows下安装请跳转:

https://dev.mysql.com/downloads/installer/

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

CentOS 6.x安装Mysql5.7(下载安装)

CentOS 6使用yum安装Mysql5.7会出现libc相关的错误。故使用下载安装。

首先卸载旧的MySql5.1

  1. 查看是否安装有mysql
    yum repolist all|grep mysql
    yum repolist enabled|grep mysql
    rpm -qa|grep -i mysql
  2. 删除旧的mysql
    rpm -e --nodeps mysql-community-server-*
    rpm -e --nodeps mysql-community-common-*
    rpm -e --nodeps mysql-community-client-*
    rpm -e --nodeps mysql-community-libs-*
  3. 删除mysql老版本的残留文件
    rm -rf /usr/lib/mysql
    rm -rf /usr/include/mysql
    注意:卸载后/var/lib/mysql/etc/my.cnf不会删除,如果确定没用后就手工删除;
    rm -rf /etc/my.cnf
    rm -rf /var/lib/mysql

安装Mysql5.7

  1. 下载:wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.23-1.el6.x86_64.rpm-bundle.tar
  2. 解压:tar -xvf mysql-5.7.23-1.el6*
  3. 安装:
    rpm -ivh mysql-community-common*
    rpm -ivh mysql-community-libs*
    rpm -ivh mysql-community-client*
    rpm -ivh mysql-community-server*
    
  4. 修改配置vi /etc/my.cnf
    [client]
    default-character-set=utf8
    [mysql]
    default-character-set=utf8
    [mysqld]
    port = 2433
    character-set-server = utf8mb4
    collation-server = utf8mb4_general_ci
    init_connect='SET NAMES utf8mb4'
    lower_case_table_names = 1
    max_connections = 400
    max_connect_errors = 1000
    max_allowed_packet = 1G
    validate_password=OFF
    tmp_table_size=256M
    max_heap_table_size=256M
    
  5. 如果不想将数据存到默认路径下,建立软链接:
    mv /var/lib/mysql /data/mysqldata
    chown -R mysql:mysql /data/mysqldata
    ln -s /data/mysqldata /var/lib/mysql
  6. 查看默认密码:grep 'temporary password' /var/log/mysqld.log
  7. 启动:services mysqld start
  8. 设置开机自启动:chkconfig mysqld on
  9. 登陆:mysql -uroot -p
  10. 修改默认密码:SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');
  11. 创建远程用户:grant all on *.* to root@'%' identified by'newpassword';
  12. 刷新权限表:flush privileges;
  13. 创建数据库

CentOS 7.x安装Mysql5.7(Yum安装)

1. 配置YUM源

#下载mysql源安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

#安装mysql源

yum localinstall mysql57-community-release-el7-8.noarch.rpm

检查mysql源是否安装成功

yum repolist enabled | grep mysql

看到上图所示表示安装成功。
可以修改vim /etc/yum.repos.d/mysql-community.repo源,改变默认安装的mysql版本。比如要安装5.6版本,将5.7源的enabled=1改成enabled=0。然后再将5.6源的enabled=0改成enabled=1即可。改完之后的效果如下所示:

2. 安装MySQL

yum install -y mysql-community-server

3. 启动MySQL服务

systemctl start mysqld
(CenteOS6是:service mysqld start)

4. 开机自启

systemctl enable mysqld
systemctl daemon-reload
(CentOs6下用:chkconfig mysqld on设置开机自启动,chkconfig --list|grep mysqld 检查状态)

5. 修改root本地登陆密码

mysql安装完成之后,在/var/log/mysqld.log文件中给root生成了一个默认密码。通过下面的方式找到root默认密码,然后登录mysql进行修改:
grep 'temporary password' /var/log/mysqld.log

如图,随机密码为:kq?,-Zq_5m+w
然后根据得到的密码登陆:

mysql -uroot -p

修改密码:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

这时候修改本地密码会报错,因为mysql5.7对默认密码有复杂度限制。
如果不需要修改配置关闭校验。

6. 修改/etc/my.cnf

添加如下字段:

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
port = 3306
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
init_connect='SET NAMES utf8mb4'
lower_case_table_names = 1
max_connections = 400
max_connect_errors = 1000
max_allowed_packet = 1G

validate_password=OFF

tmp_table_size=256M
max_heap_table_size=256M

7. 配置修改后需要重启

CentOS7: systemctl restart mysqld

CentOS6: service mysqld restart


转载请注明来源,欢迎对文章中的引用来源进行考证,欢迎指出任何有错误或不够清晰的表达。可以在下面评论区评论,也可以邮件至 using1174@foxmail.com

文章标题: CentOS 安装Mysql 5.7

文章字数: 808

本文作者: Jun

发布时间: 2018-06-15, 11:03:00

最后更新: 2022-05-06, 23:36:31

原始链接: http://yoursite.com/2018/06/15/CentOS-7安装Mysql-5-7/

版权声明: "署名-非商用-相同方式共享 4.0" 转载请保留原文链接及作者。

目录
×

喜欢就点赞,疼爱就打赏