suse 12sp5 部署 mysql 5.7
0 前言 系统使用 Gnome 环境 1 安装 安装依赖 zypper in libatomic1 zypper in perl-JSON 下载 mysql 安装包, 链接 tar xf mysql-5.7.44-1.sles12.x86_64.rpm-bundle.tar rpm -ivh mysql-community-common-5.7.44-1.sles12.x86_64.rpm rpm -ivh mysql-community-libs-5.7.44-1.sles12.x86_64.rpm rpm -ivh mysql-community-client-5.7.44-1.sles12.x86_64.rpm rpm -ivh mysql-community-server-5.7.44-1.sles12.x86_64.rpm mkdir -p /data/mysql/{data,tmp} chown -R mysql /data/mysql mysqld --initialize --datadir=/data/mysql/data/ --user=mysql 修改 /etc/my.cnf 配置文件 [client] port = 3306 socket = /data/mysql/mysql.sock default-character-set=utf8 [mysqld] port = 3306 skip-grant-tables datadir = /data/mysql/data tmpdir = /data/mysql/tmp socket = /data/mysql/mysql.sock character-set-server = utf8 collation-server = utf8_general_ci pid-file = /data/mysql/mysql.pid user = mysql explicit_defaults_for_timestamp lower_case_table_names = 1 max_connections = 1000 back_log = 1024 open_files_limit = 10240 table_open_cache = 5120 skip-external-locking local-infile = 1 key_buffer_size = 32M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K ...
