首页 > 数据库技术 > 详细

MySQL 5.7.21 在 OEL6.9 平台上的二进制安装

时间:2018-03-16 22:20:09      阅读:295      评论:0      收藏:0      [点我收藏+]
  • 前提准备 (关闭防火墙,selinux,安装libaio)
    
    shell> chkconfig --level 2345 iptables off
    shell> service iptables stop
    shell> vi /etc/selinux/config
    SELINUX=disabled
  • shell> yum install libaio

    
    1. 配置用户属组 (MySQL用户不需要登录操作系统)

    shell> groupadd mysql
    shell> useradd -r -g mysql -s /bin/false mysql

    
    2. 解压二进制软件

    shell> cd /usr/local
    shell> mv ~/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz ./

    shell> tar zxvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
    or
    shell> gunzip < mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz | tar xvf -

    shell> mv mysql-5.7.21-linux-glibc2.12-x86_64 mysql-5.7.21

    
    3. 修改软件权限创建链接

    shell> chmod -R 750 ./mysql-5.7.21
    shell> chown -R mysql:mysql ./mysql-5.7.21
    shell> ln -s /usr/local/mysql-5.7.21 mysql

    
    4. 创建MySQL数据目录 (提前touch日志文件,否则启动的时候会报错)

    shell> mkdir -p /mysql/{data,log,binlog}
    shell> chown -R mysql:mysql /mysql/
    shell> touch /mysql/log/mysqld.log
    shell> chown mysql:mysql /mysql/log/mysqld.log

    
    5. 编辑数据库服务器参数 (指定数据初始化目录,也可以通过命令行指定初始化目录)

    shell> vi /etc/my.cnf
    [mysqld]
    datadir=/mysql/data
    socket=/mysql/log/mysql.sock

    [mysqld_safe]
    log_error=/mysql/log/mysqld.log
    pid_file=/mysql/log/mysqld.pid

    
    6. 初始化数据库

    shell> cd mysql
    shell> bin/mysqld --initialize --user=mysql (m3gfb<1gKDZ%)
    shell> bin/mysql_ssl_rsa_setup
    shell> bin/mysqld_safe --user=mysql &

    
    7. 修改默认root口令

    [root@crmdb1 mysql]# mysql -u root -p -S /mysql/log/mysql.sock
    mysql> ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘oracle‘;
    mysql> FLUSH PRIVILEGES;

    
    8. 关闭数据库
    `[root@crmdb1 mysql]# bin/mysqladmin -u root -p -S /mysql/log/mysql.sock shutdown`
    
    9. 修改环境变量

    shell> vi ~/.bash_profile
    export PATH=/usr/local/mysql/bin:$PATH
    export MYSQL_PS1="(\u@\h) [\d]> "

    [root@crmdb1 mysql]# . ~/.bash_profile

    
    10. 配置MySQL服务

    shell> cp support-files/mysql.server /etc/init.d/mysql
    shell> chkconfig --add mysql
    shell> chkconfig --level 2345 mysql on

    
    11. 编辑数据库客户端参数

    [client]
    host=localhost
    user=root
    password=oracle
    socket=/mysql/log/mysql.sock

    
    12. 启动MySQL服务
    `shell> service mysql start`
    
    13. 登录数据库验证

    shell> mysql
    (root@localhost) [(none)]> show databases;

    
    错误解决:
    1. 

    2018-03-15T13:38:06.902460Z 0 [ERROR] SSL error: Unable to get private key from ‘server-key.pem‘
    2018-03-15T13:38:06.902470Z 0 [Warning] Failed to set up SSL because of the following SSL library error: Unable to get private key

    mysql用户没有权限访问‘server-key.pem‘文件,修改权限后错误解决:
    [root@crmdb1 security]# cd /mysql/data/
    [root@crmdb1 data]# ls -la server-key.pem
    -rw------- 1 root root 1679 Mar 15 21:24 server-key.pem
    [root@crmdb1 data]# chmod 644 server-key.pem
    [root@crmdb1 data]# service mysql restart

    2018-03-15T14:29:38.605619Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
    null

    2.
    2018-03-15T13:38:06.767757Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_time
    stamp server option (see documentation for more details).

    通过设置参数解决该告警:
    explicit_defaults_for_timestamp=1

    Note
    explicit_defaults_for_timestamp is itself deprecated because its only purpose is to permit control over deprecated TIMESTAMP behaviors that are to be removed in a future MySQL release. When removal of those behaviors occurs, explicit_defaults_for_timestamp will have no purpose and will be removed as well.

    MySQL 5.7.21 在 OEL6.9 平台上的二进制安装

    原文:http://blog.51cto.com/recyclebin/2087781

    (0)
    (0)
       
    举报
    评论 一句话评论(0
    关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
    © 2014 bubuko.com 版权所有
    打开技术之扣,分享程序人生!