CentOS7环境下源码如何安装MySQL5.7

2025-03-27 技术教程

这篇文章给大家分享的是有关CentOS7环境下源码如何安装MySQL5.7的内容。小编觉得挺实用的，因此分享给大家做个参考，一起跟随小编过来看看吧。

安装依赖包

yum-yinstallautoconfautomakelibtoolcmakencurses-developenssl-devellzo-develzlib-develgccgcc-c++

下载相应源码包

wgethttp://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gzwgethttp://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.12.tar.gz

添加mysql用户

useradd-M-s/sbin/nologinmysql

解压源码包

tarzxvfboost_1_59_0.tar.gz-C/home/mysql#将文件解压至/home/mysql目录下tarzxvfmysql-5.7.12.tar.gz

编译mysql

cmake.-DCMAKE_INSTALL_PREFIX=/home/mysql/mysql_client/mysql-5.7-01\-DMYSQL_DATADIR=/home/mysql/mysql_data/mysql-5.7-01\-DDOWNLOAD_BOOST=1\-DWITH_BOOST=/home/mysql/boost_1_59_0\#指定boost的位置-DSYSCONFDIR=/etc/mysql\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_PARTITION_STORAGE_ENGINE=1\-DWITH_FEDERATED_STORAGE_ENGINE=1\-DWITH_BLACKHOLE_STORAGE_ENGINE=1\-DWITH_MYISAM_STORAGE_ENGINE=1\-DENABLED_LOCAL_INFILE=1\-DENABLE_DTRACE=0\-DDEFAULT_CHARSET=utf8\-DDEFAULT_COLLATION=utf8_general_ci\-DEXTRA_CHARSETS=all\-DWITH_EMBEDDED_SERVER=1\-DMYSQL_TCP_PORT=3306;

编译安装

make-j`grepprocessor/proc/cpuinfo|wc-l`#编译时会消耗很大内存,小内存可能无法编译完成makeinstall#开始安装

配置启动

cp /home/mysql/mysql_client/mysql-5.7-01/support-files/mysql.server /etc/init.d/mysqld

添加可执行权限

chmod+x/etc/init.d/mysqld#mysqld可以修改mysql的配置文件路径

配置mysql的配置/etc/my.cnf，仅供参考

[client]port=3306socket=/home/mysql/mysql_data/mysql-5.7-01/mysql.sockdefault-character-set=utf8[mysqld]port=3306socket=/home/mysql/mysql_data/mysql-5.7-01/mysql.sockbasedir=/home/mysql/mysql_client/mysql-5.7-01datadir=/home/mysql/mysql_data/mysql-5.7-01pid-file=/home/mysql/mysql_data/mysql-5.7-01/mysql/mysql.piduser=mysqlbind-address=0.0.0.0server-id=1init-connect='SETNAMESutf8'character-set-server=utf8back_log=300max_connections=1000max_connect_errors=6000open_files_limit=65535table_open_cache=128max_allowed_packet=4Mbinlog_cache_size=1Mmax_heap_table_size=8Mtmp_table_size=16Mread_buffer_size=2Mread_rnd_buffer_size=8Msort_buffer_size=8Mjoin_buffer_size=8Mkey_buffer_size=4Mthread_cache_size=8query_cache_type=1query_cache_size=8Mquery_cache_limit=2Mft_min_word_len=4log_bin=/home/mysql/mysql_logs/mysql-5.7-01/mysql-binbinlog_format=mixedexpire_logs_days=30log_error=/home/mysql/mysql_logs/mysql-5.7-01/mysql-error.logslow_query_log=1long_query_time=1slow_query_log_file=/home/mysql/mysql_logs/mysql-5.7-01/mysql-slow.logperformance_schema=0explicit_defaults_for_timestampskip-external-lockingdefault_storage_engine=InnoDBinnodb_file_per_table=1innodb_open_files=500innodb_buffer_pool_size=64Minnodb_write_io_threads=4innodb_read_io_threads=4innodb_thread_concurrency=0innodb_purge_threads=1innodb_flush_log_at_trx_commit=2innodb_log_buffer_size=2Minnodb_log_file_size=32Minnodb_log_files_in_group=3innodb_max_dirty_pages_pct=90innodb_lock_wait_timeout=120bulk_insert_buffer_size=8Mmyisam_sort_buffer_size=8Mmyisam_max_sort_file_size=10Gmyisam_repair_threads=1interactive_timeout=28800wait_timeout=28800[mysqldump]quickmax_allowed_packet=16M[myisamchk]key_buffer_size=8Msort_buffer_size=8Mread_buffer=4Mwrite_buffer=4M

记得将mysql相关文件夹分配给我们之前创建的mysql用户

chown-Rmysql.mysqlmysql/

初始化数据库

/home/mysql/mysql_client/mysql-5.7-01/bin/mysqld--initialize-insecure--user=mysql--basedir=/home/mysql/mysql_client/mysql-5.7-01--datadir=/home/mysql/mysql_data/mysql-5.7-01#–-initialize-insecure不生成随机密码

启动数据库

/etc/init.d/mysqldstart

进入数据库

/home/mysql/mysql_client/mysql-5.7-01/bin/mysql-uroot-p

感谢各位的阅读！关于“CentOS7环境下源码如何安装MySQL5.7”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，让大家可以学到更多知识，如果觉得文章不错，可以把它分享出去让更多的人看到吧！