mysql下载配置CentOS 安装MySQL 及配置
从今年3月份开始mysql开始发布相关的系列的各个版本，对于系列的版本对一路的版本进行了全局性的细节性增强；个人感觉，以下是在虚拟机中配置的源码安装的进程分享记录下：
一、必要软件包安装：
[root@mysql5~]#yum -y install  gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake 
二、编译安装：
[root@mysql5 ~]# groupadd mysql
[root@mysql5 ~]# useradd -r -g mysql mysql
[root@mysql5 ~]# ls
      ~]# cd /usr/local/
[root@mysql5 local]# ls
bin  etc  games  include  lib  libexec  sbin  share  src
[root@mysql5 local]# cp /root/  /usr/local/
[root@mysql5 local]# ll
total 34468
drwxr-xr-x 2 root root    4096 Jan 27  2021 bin
drwxr-xr-x 2 root root    4096 Jan 27  2021 etc
drwxr-xr-x 2 root root    4096 Jan 27  2021 games
drwxr-xr-x 2 root root    4096 Jan 27  2021 include
drwxr-xr-x 2 root root    4096 Jan 27  2021 lib
drwxr-xr-x 2 root root    4096 Jan 27  2021 libexec
-rw-r--r-- 1 root root  Apr 17 00:55  2 root root    4096 Jan 27  2021 sbin
drwxr-xr-x 4 root root    4096 Apr 17 00:32 share
drwxr-xr-x 2 root root    4096 Jan 27  2021 src
[root@mysql5 local]#  tar -zxvf local]# cd 
[root@mysql5 local]# cmake .         ###编译报如下错误暂无论
[ 63%] Building CXX object sql/CMakeFiles/
/root/ In member function ‘void Optimize_table_order::best_access_path(JOIN_TAB*, table_map, uint, bool, double, POSITION*, POSITION*)’:
/root/ warning: ‘::best_loose_scan_start_key’ may be used uninitialized in this function
/root/ warning: ‘::best_max_loose_keypart’ may be used uninitialized in this function
/root/ warning: ‘::best_loose_scan_records’ may be used uninitialized in this function
/root/ warning: ‘::best_loose_scan_key’ may be used uninitialized in this function
/root/ warning: ‘::quick_max_loose_keypart’ may be used uninitialized in this function
[root@mysql5 local]# make && make install
三、配置MySQL
[root@mysql5 chown -R  /usr/local/mysql
[root@mysql5  cd /usr/local/mysql/scripts/
[root@mysql5 scripts]# ./mysql_install_db  --user=mysql --basedir=/usr/local/mys
ql --datadir=/usr/local/mysql/data
Installing MySQL 2021-04-17 01:26:58 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp serv
er option (see documentation for more details).
2021-04-17 01:26:58 18715 [Note] InnoDB: The InnoDB memory heap is disabled
2021-04-17 01:26:58 18715 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2021-04-17 01:26:58 18715 [Note] InnoDB: Compressed tables use zlib  01:26:58 18715 [Note] InnoDB: CPU does not support crc32 instructions
2021-04-17 01:26:58 18715 [Note] InnoDB: Initializing buffer pool, size =
2021-04-17 01:26:58 18715 [Note] InnoDB: Completed initialization of buffer pool
2021-04-17 01:26:58 18715 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2021-04-17 01:26:59 18715 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2021-04-17 01:26:59 18715 [Note] InnoDB: Database physically writes the file full:
2021-04-17 01:26:59 18715 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2021-04-17 01:26:59 18715 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2021-04-17 01:26:59 18715 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2021-04-17 01:26:59 18715 [Warning] InnoDB: New log files created, LSN=45781
2021-04-17 01:26:59 18715 [Note] InnoDB: Doublewrite buffer not found: creating new
2021-04-17 01:26:59 18715 [Note] InnoDB: Doublewrite buffer created
2021-04-17 01:26:59 18715 [Note] InnoDB: 128 rollback segment(s) are active.
2021-04-17 01:26:59 18715 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-04-17 01:26:59 18715 [Note] InnoDB: Foreign key constraint system tables created
2021-04-17 01:26:59 18715 [Note] InnoDB: Creating tablespace and datafile system tables.
2021-04-17 01:26:59 18715 [Note] InnoDB: Tablespace and datafile system tables created.
2021-04-17 01:26:59 18715 [Note] InnoDB: Waiting for purge to start
2021-04-17 01:26:59 18715 [Note] InnoDB:  started; log sequence number 0
2021-04-17 01:26:59 18715 [Note] Binlog end
2021-04-17 01:26:59 18715 [Note] InnoDB: FTS optimize thread exiting.
2021-04-17 01:26:59 18715 [Note] InnoDB:
2021-04-17 01:27:00 18715 [Note] InnoDB: Shutdown completed; log sequence number 1625977

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。