• MySQL8——源码安装


    一.环境

    ubuntu18.10(CentOS7由于gcc版本过低已经无法通过编译)

    二.准备工作

    1.安装依赖

    apt-get install -y gcc g++ cmake build-essential bison libncurses5-dev openssl libssl-dev

    2.下载源码包

    wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-boost-8.0.15.tar.gz (此版本带有boost)

    3.创建mysql用户

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

    4.创建安装目录和数据目录

    mkdir -p /usr/local/mysql
    mkdir -p /data/mysql

    三.安装MySQL8.0.15

    1.解压源码包

    tar -zxvf mysql-boost-8.0.15.tar.gz -C /usr/local/src

    2.编译&安装

    cd /usr/local/src/mysql-8.0.15
    cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DMYSQL_TCP_PORT=3306 -DWITH_BOOST=/usr/local/src/mysql-8.0.15/boost -DFORCE_INSOURCE_BUILD=1
    make && make install

    3.配置my.cnf文件

    文件参数很多,这里就不一一列举
    vim /etc/my.cnf

    [mysqld]
    server-id=1
    port=3306
    basedir=/usr/local/mysql
    datadir=/data/mysql
    socket=/data/mysql/mysql.sock
    max_allowed_packet=1G
    net_read_timeout=300
    net_write_timeout=600

    [client]
    socket=/data/mysql/mysql.sock

    ##请根据实际情况添加参数

    4.目录权限修改

    chown -R mysql:mysql /usr/local/mysql
    chown -R mysql:mysql /data/mysql
    chmod 755 /usr/local/mysql -R
    chmod 755 /data/mysql -R

    5.初始化

    cd /usr/local/mysql

    bin/mysqld --initialize --user=mysql --datadir=/data/mysql/
    bin/mysql_ssl_rsa_setup

    6.启动mysql

    bin/mysqld_safe --user=mysql &

    7.修改账号密码

    bin/mysql -uroot -p

    mysql> alter user 'root'@'localhost' identified by "123456";

    mysql> show databases;

    +--------------------+
    | Database |
    +--------------------+
    | information_schema |
    | mysql |
    | performance_schema |
    | sys |
    +--------------------+
    4 rows in set (0.00 sec)

    ##添加远程连接账号

    mysql> create user root@'%' identified by '123456';

        Query OK, 0 rows affected (0.08 sec)

    mysql> grant all privileges on *.* to root@'%';

        Query OK, 0 rows affected (0.04 sec)

    mysql> flush privileges;

        Query OK, 0 rows affected (0.01 sec)

    8.创建软链接(非必要)

    ln -s /usr/local/mysql/bin/* /usr/local/bin/


    mysql -h 127.0.0.1 -P 3306 -uroot -p123456 -e "select version();"

        mysql: [Warning] Using a password on the command line interface can be insecure.
        +-----------+
        | version() |
        +-----------+
        | 8.0.15 |
        +-----------+

    9.添加到启动(非必要)

    cp support-files/mysql.server /etc/init.d/mysqld
    /lib/systemd/systemd-sysv-install enable mysqld

  • 相关阅读:
    Spring REST
    Spring整合CXF,发布RSETful 风格WebService
    ZT:阿里合伙人发文:十年磨一剑,自研数据库终拿世界第一
    转载:OutOfMemoryError系列(2): GC overhead limit exceeded
    SpringBoot/SpringMVC 下载本地文件
    Eclipse中查找接口实现类快捷键
    [java]察看两个日期间差多少秒/小时/天
    MongoDB(mongodb-win32-x86_64-enterprise-windows-64-4.2.1-signed.msi)下载,启动和插入数据,查询
    简繁瘦金体下载
    方正宋刻本秀楷字体下载
  • 原文地址:https://www.cnblogs.com/small-wei/p/10826198.html
Copyright © 2020-2023  润新知