CentOS 6.0安装MySQL 5.6及配置
从今年3月份开始mysql开始发布相关的5.6系列的各个版本，对于mysql5.6系列的版本对一起的版本进行了全局性的细节性加强；个人感觉，以下是在虚拟机中配置的mysql5.6.10源码安装的过程分享记录下：
一、必要软件包安装：
[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
anaconda-ks.cfg  install.log  install.log.syslog  mysql-5.6.
[root@mysql5 ~]# cd /usr/local/
[root@mysql5 local]# ls
bin  etc  games  include  lib  libexec  sbin  share  src
[root@mysql5 local]# cp /root/mysql-5.6.  /usr/local/
[root@mysql5 local]# ll
total 34468
drwxr-xr-x 2 root root    4096 Jan 27  2010 bin
drwxr-xr-x 2 root root    4096 Jan 27  2010 etc
drwxr-xr-x 2 root root    4096 Jan 27  2010 games
drwxr-xr-x 2 root root    4096 Jan 27  2010 include
drwxr-xr-x 2 root root    4096 Jan 27  2010 lib
drwxr-xr-x 2 root root    4096 Jan 27  2010 libexec
-rw-r--r-- 1 root root 35174149 Apr 17 00:55 mysql-5.6.
drwxr-xr-x 2 root root    4096 Jan 27  2010 sbin
drwxr-xr-x 4 root root    4096 Apr 17 00:32 share
drwxr-xr-x 2 root root    4096 Jan 27  2010 src
[root@mysql5 local]#  tar -zxvf mysql-5.6.
[root@mysql5 local]# cd mysql-5.6.10
[root@mysql5 local]# cmake .        ###编译报如下错误暂不管
[ 63%] Building CXX object sql/CMakeFiles/sql.dir/
/root/mysql-5.6.13/sql/: In member function ‘void Optimize_table_order::bes
t_access_path(JOIN_TAB*, table_map, uint, bool, double, POSITION*, POSITION*)’:
/root/mysql-5.6.13/sql/:431: warning: ‘loose_scan_opt.Loose_scan_opt::best_loose_scan_start_key’ may be used uninitialized in this function
/root/mysql-5.6.13/sql/:431: warning: ‘loose_scan_opt.Loose_scan_opt::best_max_loose_keypart’ may be used uninitialized in this function
/root/mysql-5.6.13/sql/:431: warning: ‘loose_scan_opt.Loose_scan_opt::best_loose_scan_records’ may be used uninitialized in this function
/root/mysql-5.6.13/sql/:431: warning: ‘loose_scan_opt.Loose_scan_opt::best_loose_scan_key’ may be used uninitialized in this function
/root/mysql-5.6.13/sql/:431: warning: ‘loose_scan_opt.Loose_scan_opt::quick_max_loose_keypart’ may be used uninitialized in
this function
[root@mysql5 local]# make && make install
三、配置MySQL
[root@mysql5 mysql-5.6.10]# chown -sql /usr/local/mysql
[root@mysql5 mysql-5.6.10]#
[root@mysql5 mysql-5.6.10]# 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 2013-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).
2013-04-17 01:26:58 18715 [Note] InnoDB: The InnoDB memory heap is disabled
2013-04-17 01:26:58 18715 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2013-04-17 01:26:58 18715 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-04-17 01:26:58 18715 [Note] InnoDB: CPU does not support crc32 instructions
2013-04-17 01:26:58 18715 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-04-17 01:26:58 18715 [Note] InnoDB: Completed initialization of buffer pool
2013-04-17 01:26:58 18715 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2013-04-17 01:26:59 18715 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2013-04-17 01:26:59 18715 [Note] InnoDB: Database physically writes the file full:
2013-04-17 01:26:59 18715 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MBmysql下载starting the server
2013-04-17 01:26:59 18715 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2013-04-17 01:26:59 18715 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2013-04-17 01:26:59 18715 [Warning] InnoDB: New log files created, LSN=45781
2013-04-17 01:26:59 18715 [Note] InnoDB: Doublewrite buffer not found: creating new
2013-04-17 01:26:59 18715 [Note] InnoDB: Doublewrite buffer created
2013-04-17 01:26:59 18715 [Note] InnoDB: 128 rollback segment(s) are active.
2013-04-17 01:26:59 18715 [Warning] InnoDB: Creating foreign key constraint system tables.
2013-04-17 01:26:59 18715 [Note] InnoDB: Foreign key constraint system tables created
2013-04-17 01:26:59 18715 [Note] InnoDB: Creating tablespace and datafile system tables.
2013-04-17 01:26:59 18715 [Note] InnoDB: Tablespace and datafile system tables created.
2013-04-17 01:26:59 18715 [Note] InnoDB: Waiting for purge to start
2013-04-17 01:26:59 18715 [Note] InnoDB: 1.2.10 started; log sequence number 0
2013-04-17 01:26:59 18715 [Note] Binlog end
2013-04-17 01:26:59 18715 [Note] InnoDB: FTS optimize thread exiting.
2013-04-17 01:26:59 18715 [Note] InnoDB:

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