《CentOS6.0安装MySQL5.6及配置.docx》由会员分享,可在线阅读,更多相关《CentOS6.0安装MySQL5.6及配置.docx(7页珍藏版)》请在金锄头文库上搜索。
1、CentOS 6.0安装MySQL 5.6及配置从今年3月份开始mysql官网开始发布相关的5.6系列的各个版本,对于mysql5.6系列的版本对一起的版本进行了全局性的细节性加强;个人感觉,以下是在虚拟机中配置的mysql5.6.10源码安装的过程分享记录下:一、必要软件包安装:rootmysql5#yum-yinstallgccgcc-c+gcc-g77autoconfautomakezlib*fiex*libxml*ncurses-devellibmcrypt*libtool-ltdl-devel*makecmake二、编译安装:rootmysql5 # groupadd mysqlro
2、otmysql5 # useradd -r -g mysql mysqlrootmysql5 # lsanaconda-ks.cfg install.log install.log.syslog mysql-5.6.10.tar.gzrootmysql5 # cd /usr/local/rootmysql5 local# lsbin etc games include lib libexec sbin share srcrootmysql5 local# cp /root/mysql-5.6.10.tar.gz /usr/local/rootmysql5 local# lltotal 3446
3、8drwxr-xr-x 2 root root 4096 Jan 27 2010 bindrwxr-xr-x 2 root root 4096 Jan 27 2010 etcdrwxr-xr-x 2 root root 4096 Jan 27 2010 gamesdrwxr-xr-x 2 root root 4096 Jan 27 2010 includedrwxr-xr-x 2 root root 4096 Jan 27 2010 libdrwxr-xr-x 2 root root 4096 Jan 27 2010 libexec-rw-r-r- 1 root root 35174149 A
4、pr 17 00:55 mysql-5.6.10.tar.gzdrwxr-xr-x 2 root root 4096 Jan 27 2010 sbindrwxr-xr-x 4 root root 4096 Apr 17 00:32 sharedrwxr-xr-x 2 root root 4096 Jan 27 2010 srcrootmysql5 local# tar -zxvf mysql-5.6.10.tar.gzrootmysql5 local# cd mysql-5.6.10 rootmysql5 local# cmake . #编译报如下错误暂不管 63% Building CXX
5、object sql/CMakeFiles/sql.dir/sql_planner.cc.o/root/mysql-5.6.13/sql/sql_planner.cc: In member function void Optimize_table_order:best_access_path(JOIN_TAB*, table_map, uint, bool, double, POSITION*, POSITION*):/root/mysql-5.6.13/sql/sql_planner.cc:431: warning: loose_scan_opt.Loose_scan_opt:best_lo
6、ose_scan_start_key may be used uninitialized in this function/root/mysql-5.6.13/sql/sql_planner.cc: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/sql_planner.cc:431: warning: loose_scan_opt.Loose_scan_opt:best_loose
7、_scan_records may be used uninitialized in this function/root/mysql-5.6.13/sql/sql_planner.cc: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/sql_planner.cc:431: warning: loose_scan_opt.Loose_scan_opt:quick_max_loose_ke
8、ypart may be used uninitialized in this functionrootmysql5 local# make & make install三、配置MySQLrootmysql5 mysql-5.6.10# chown -R mysql.mysql /usr/local/mysqlrootmysql5 mysql-5.6.10#rootmysql5 mysql-5.6.10# cd /usr/local/mysql/scripts/rootmysql5 scripts# ./mysql_install_db -user=mysql -basedir=/usr/lo
9、cal/mysql -datadir=/usr/local/mysql/dataInstalling MySQL system tables.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 m
10、emory heap is disabled2013-04-17 01:26:58 18715 Note InnoDB: Mutexes and rw_locks use InnoDBs own implementation2013-04-17 01:26:58 18715 Note InnoDB: Compressed tables use zlib 1.2.32013-04-17 01:26:58 18715 Note InnoDB: CPU does not support crc32 instructions2013-04-17 01:26:58 18715 Note InnoDB:
11、Initializing buffer pool, size = 128.0M2013-04-17 01:26:58 18715 Note InnoDB: Completed initialization of buffer pool2013-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 ./ibdata
12、1 size to 12 MB2013-04-17 01:26:59 18715 Note InnoDB: Database physically writes the file full: wait.2013-04-17 01:26:59 18715 Note InnoDB: Setting log file ./ib_logfile101 size to 48 MB2013-04-17 01:26:59 18715 Note InnoDB: Setting log file ./ib_logfile1 size to 48 MB2013-04-17 01:26:59 18715 Note
13、InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile02013-04-17 01:26:59 18715 Warning InnoDB: New log files created, LSN=457812013-04-17 01:26:59 18715 Note InnoDB: Doublewrite buffer not found: creating new2013-04-17 01:26:59 18715 Note InnoDB: Doublewrite buffer created2013-04-17 01:26:59 18
14、715 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 created2013-04-17 01:26:59 18715 Note InnoDB: Creating tablespace and datafile syste
15、m 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 start2013-04-17 01:26:59 18715 Note InnoDB: 1.2.10 started; log sequence number 02013-04-17 01:26:59 18715 Note Binlog end2013-04-17 01:26:59 18715 Note InnoDB: FTS optimize thread exiting.2013-04-17 01:26:59 18715 Note InnoDB: Starting shutdown.2013-04-17 01:27:00 18715 Note InnoDB: Shutd