centos6.0安装mysql5.6及配置
- 格式：docx
- 大小：15.81 KB
- 文档页数：13
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 system tables...2021-04-17 01:26:58 0 [Warning] TIMESTAMP
with implicit DEFAULT value is deprecated. Please use
--explicit_defaults_for_timestamp server 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: wait... 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: Starting shutdown...
2021-04-17 01:27:00 18715 [Note] InnoDB: Shutdown completed; log sequence
number 1625977
OK
Filling help tables...2021-04-17 01:27:00 0 [Warning] TIMESTAMP with implicit
DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server
option (see documentation for more details).
2021-04-17 01:27:00 18738 [Note] InnoDB: The InnoDB memory heap is
disabled
2021-04-17 01:27:00 18738 [Note] InnoDB: Mutexes and rw_locks use InnoDB's
