linx 6.0.60 x64 绿色部署mysql5.7.25

爱被打了一巴掌 2023-10-18 17:11 13阅读 0赞

Linx凝思操作系统是一个基于debian6的很老的平台

很多新的软件都没有deb包，只能自己手工编译部署

下面介绍如何部署mysql5.7.25，并且保证所有文件都在/home/mysql下

1.安装Linx操作系统，使用国网定制版(d5000版)

2.在终端使用root用户，删除系统自带的mysql

dpkg --list | grep mysql | awk -F'[ ]' '{print $3}' | xargs apt-get -qy remove
    apt-get autoremove -qy

3.登录mysql官网，下载 mysql-5.7.25-linux-glibc2.12-x86\_64.tar.gz，这是原生的二进制文件包

4.将文件解压缩到/home下，并将目录改名为mysql

5.在/home/mysql目录下创建一个my.cnf文件，内容为

# For advice on how to change settings please see
    # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
    # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
    # *** default location during install, and will be replaced if you
    # *** upgrade to a newer version of MySQL.
    
    [client]
    #password = your_password
    port = 3306
    socket = /home/mysql/mysql.sock
    default_character_set = utf8
    
    [mysqld]
    
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    
    # These are commonly set, remove the # and set as required.
    basedir = /home/mysql
    datadir = /home/mysql/data
    port = 3306
    # server_id = .....
    socket = /home/mysql/mysql.sock
    character_set_server = utf8
    
    lower_case_table_names = 1
    #skip-grant-tables
    default_password_lifetime = 0
    
    interactive_timeout=288000
    wait_timeout=288000
    
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M 
    
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

6.在/home/mysql目录下创建一个目录data

7.终端执行，创建软连接

ln -s  /lib/libncurses.so.5.7  /lib/libtinfo.so.5

8.终端执行，初始化mysql数据

/home/mysql/bin/mysqld --defaults-file=/home/mysql/my.cnf --initialize-insecure --user=mysql

9.执行脚本

/home/mysql/bin/mysql_ssl_rsa_setup --defaults-file=/home/mysql/my.cnf --user=mysql

10.执行脚本，保证root用户能够操作mysql

chown -R mysql:mysql /home/mysql

11.执行脚本，运行mysql，mysql启动后敲回车，回到终端

/home/mysql/bin/mysqld_safe --defaults-file=/home/mysql/my.cnf &

12.执行脚本，为了能够使用mysql客户端