源安装MySQL 5.7.20
mysql5.7版本之后要用boost1.59
http://www.boost.org/
yum - y安装gcc gcc-c + + ncurses ncurses-devel cmake野牛wget
wget https://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz,,wget https://dev.mysql.com/get/downloads/mysql - 5.7 -/- mysql -提高5.7.20.tar.gz
tar xf boost_1_59_0.tar。广州,,tar xf mysql-boost-5.7.20.tar。广州
cd mysql-5.7.20
groupadd mysql
useradd mysql - s/bin/nologin - m - g mysql
mkdir - p/usr/local/mysql-5.7.20/usr/local/mysql-5.7.20/usr/local/mysql-5.7.20/mysql/数据。袜子
![MySQL5.7.20安装教程”> cmake。-DCMAKE_INSTALL_PREFIX=/usr/地方/mysql-5.7.20 \ <br/> -DMYSQL_DATADIR=/usr/地方/mysql-5.7.20/数据\ <br/> -DMYSQL_UNIX_ADDR=/usr/地方/mysql-5.7.20/mysql。袜子\ <br/> -DSYSCONFDIR=/etc \ <br/> -DWITH_BOOST=. ./boost_1_59_0 \ <br/> -DDEFAULT_CHARSET=utf8 \ <br/> -DDEFAULT_COLLATION=utf8_general_ci \ <br/> -DEXTRA_CHARSETS=gbk, gb2312, use utf8, ascii \ <br/> \ <br/> -DWITH_INNOBASE_STORAGE_ENGINE上-DENABLED_LOCAL_INFILE==1 \ <br/> -DWITH_FEDERATED_STORAGE_ENGINE=1 \ <br/> -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ <br/> -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \ <br/> -DWITHOUT_PARTITION_STORAGE_ENGINE=1 \ <br/> -DWITH_FAST_MUTEXES=1 \ <br/> -DWITH_ZLIB=捆绑\ <br/> -DENABLED_LOCAL_INFILE=1 \ <br/> -DWITH_READLINE=1 \ <br/> -DWITH_EMBEDDED_SERVER=1 \ <br/> -DWITH_DEBUG=0 <br/> <br/>编译安装<br/>让- j的grep处理器/proc/cpuinfo | wc - l ' <br/> make install <br/> <br/>设置启动脚本,开机自启动<br/> ls轻轨车/usr/local/mysql <br/> cp/usr/local/mysql/support-files/mysql。服务器/etc/init.d/mysqld <br/> chmod + x/etc/init.d/mysqld <br/> <br/>配置文件,<br/>/etc/my . cnf中所做<br/>猫比;/etc/my.cnf & lt; & lt;EOF <br/>[客户]<br/>=3306套接字<br/>=/dev/shm/mysql.港袜子<br/> (mysqld) <br/>=3306套接字<br/>=/dev/shm/mysql.港袜子<br/> basedir=/usr/local/mysql <br/> datadir=/数据/mysql <br/> pid文件=/数据/mysql/mysql。pid <br/>用户=mysql <br/> bind-address=0.0.0.0 <br/>服务器id=1 <br/> init-connect=& # 39;设置名称utf8mb4& # 39; <br/> character-set-server=utf8mb4 <br/> # skip-name-resolve <br/> # skip-networking <br/> back_log=300 <br/> max_connections=1000 <br/> max_connect_errors=6000 <br/> open_files_limit=65535 <br/> table_open_cache=128 <br/> max_allowed_packet=4 m <br/> binlog_cache_size=1 m <br/> max_heap_table_size=8 m <br/> tmp_table_size=16 m <br/> read_buffer_size=2 m <br/> read_rnd_buffer_size=8 m <br/> sort_buffer_size=8 m <br/> join_buffer_size=8 m <br/> key_buffer_size=4 m <br/> thread_cache_size=8 <br/> query_cache_type=1 <br/> query_cache_size=8 m <br/> query_cache_limit=2 m <br/> ft_min_word_len=4 <br/> log_bin=mysql-bin <br/> binlog_format=<br/>混合expire_logs_days=30 <br/> log_error=/数据/mysql/mysql-error。日志<br/> slow_query_log=1 <br/> long_query_time=1 <br/> slow_query_log_file=/数据/mysql/mysql-slow。日志<br/> performance_schema=0 <br/> explicit_defaults_for_timestamp <br/> # lower_case_table_names=1 <br/> skip-external-locking <br/> default_storage_engine=InnoDB <br/> # default-storage-engine=MyISAM <br/> innodb_file_per_table=1 <br/> innodb_open_files通过innodb_buffer_pool_size=64=500 <br/> <br/> innodb_write_io_threads=4 <br/> innodb_read_io_threads=4 <br/> innodb_thread_concurrency=0 <br/> innodb_purge_threads=1 <br/> innodb_flush_log_at_trx_commit=2 <br/> <br/> innodb_log_file_size innodb_log_buffer_size=2米=32 m <br/> innodb_log_files_in_group=3 <br/> innodb_max_dirty_pages_pct=90 <br/> innodb_lock_wait_timeout=120 <br/> bulk_insert_buffer_size=8 m <br/> myisam_sort_buffer_size=8 m <br/> myisam_max_sort_file_size=10 g <br/> myisam_repair_threads=1 <br/> interactive_timeout=28800 <br/> wait_timeout=28800 <br/> [, mysqldump] <br/>快速<br/> max_allowed_packet=16 m <br/> [myisamchk] <br/> key_buffer_size=8 m <br/> sort_buffer_size=8 m <br/> read_buffer=4 m <br/> write_buffer=4 m <br/> EOF <br/> <br/>添加mysql的环境变量<br/> echo - e & # 39; \ n \ nexport路径=/usr/地方/mysql/bin:美元路径\ n # 39;在比;/etc/profile,,源/etc/profile <br/> <br/>初始化数据库<br/> mysqld initialize-insecure——用户=mysql——basedir=/usr/地方/mysql——datadir=/数据/mysql <br/> <br/>启动数据库<br/> <br/> systemctl开始mysqld <br/> systemctl地位mysqld <br/> <br/>查看mysql服务进程和端口<br/> p ef | grep mysql <br/> <br/>设置数据库根用户密码<br/> mysql_secure_installation <br/> <br/>常用操作<br/>将mysql数据库的动态链接库共享至系统链接库<br/>一般mysql数据库还会被类似于PHP等服务调用,所以我们需要将mysql编译后的lib库文件添加至当前Linux主机链接库/etc/ld.so.conf。d/<br/>下,这样MySQL服务就可以被其它服务调用了。<h2 class=](/zixun/d/file/jishu/2021-06-09/0638b766a29a31fb7fc684ac4b22c4ec.jpg )
MySQL5.7.20安装教程
