• Ubuntu安装MariaDB10.8.3


    1、安装依赖

    sudo apt install -y software-properties-common devscripts equivs cmake libncurses-dev

    2、设置用户和权限

    sudo groupadd mysql
    sudo useradd mysql -g mysql
    sudo mkdir -p /usr/local/mysql
    sudo mkdir -p /usr/local/db/mysql/data
    sudo mkdir -p /auth_pam_tool_dir
    sudo touch /auth_pam_tool_dir/auth_pam_tool
    
    sudo chown -R mysql:mysql /usr/local/mysql
    sudo chown -R mysql:mysql /usr/local/db/mysql/data
    sudo chown -R mysql:mysql /usr/local/mysql/.
    sudo chown -R mysql:mysql /usr/local/db/mysql/data/.
    sudo chown -R mysql:mysql /auth_pam_tool_dir

    3、设置环境变量

    sudo vi /etc/profile
    PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
    export PATH
    source /etc/profile

    4、安装(将 mariadb-10.8.3.tar.gz 放到 /usr/local 下)

    sudo tar zxvf mariadb-10.8.3.tar.gz
    cd /usr/local/mariadb-10.8.3/
    sudo cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/db/mysql/data -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=22066

    在之后的make过程中会自动下载pcre2,但下载的过程很慢。现在手工下载比较快(注:每个版本的MariaDB需要的pcre2也不同)

    cd /usr/local/mariadb-10.8.3/extra/pcre2/src/
    sudo wget https://dsideal.obs.cn-north-1.myhuaweicloud.com/pcre2-10.40.zip

    开始make

    cd -
    sudo make -j8
    sudo make install

    5、设置配置文件

    sudo vi /etc/my.cnf
    [client]
    port = 22066
    socket = /usr/local/mysql/mysqld.sock
    
    # The MySQL server
    [mysqld]
    port = 22066
    socket = /usr/local/mysql/mysqld.sock
    datadir = /usr/local/db/mysql/data
    skip-external-locking
    skip-name-resolve
    skip-grant-tables
    back_log = 100
    max_connections = 2048
    max_connect_errors = 30
    table_open_cache = 2048
    open_files_limit = 16384
    max_allowed_packet = 16M
    read_buffer_size = 8M
    read_rnd_buffer_size = 32M
    sort_buffer_size = 2M
    join_buffer_size = 2M
    thread_cache_size = 16
    query_cache_size = 128M
    query_cache_limit = 4M
    slow_query_log = 1
    long_query_time = 2
    lower_case_table_names = 1
    innodb_file_per_table = 1
    max_allowed_packet = 64M
    server-id = 1
    log-bin = mysql-bin
    expire_logs_days = 7
    binlog_format = ROW
    
    innodb_data_file_path = ibdata1:10M:autoextend
    innodb_buffer_pool_size = 2G
    innodb_write_io_threads = 8
    innodb_read_io_threads = 8
    innodb_flush_log_at_trx_commit = 2
    innodb_log_buffer_size = 16M
    innodb_log_file_size = 170M
    innodb_lock_wait_timeout = 60

    6、初始化数据库和复制启动脚本

    cd /usr/local/mysql
    sudo scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/db/mysql/data
    sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

    重新加载服务的配置文件

    sudo systemctl daemon-reload

    启动

    sudo systemctl start mysql

    自启

    sudo systemctl enable mysql

    7、设置root密码

    mysql
    flush privileges;
    GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";
    flush privileges;

    完成后,将my.cnf配置文件中的skip-grant-tables配置去掉,重启服务

  • 相关阅读:
    python内建函数
    python中fromkeys的用法
    python中append和+号的区别
    python中input用法
    opencv3.2.0之绘图
    opencv3.2.0之Mat
    【学习】Python进行数据提取的方法总结【转载】
    【python】python中的enumerate()函数【笔记】
    【学习】如何安装GraphLab Create 【转载】
    【学习】python文件读写,用with open as的好处,非常好【转载】
  • 原文地址:https://www.cnblogs.com/kgdxpr/p/16404924.html
Copyright © 2020-2023  润新知