{"rsdb":{"rid":"157254","subhead":"","postdate":"0","aid":"117970","fid":"57","uid":"1","topic":"1","content":"

1\u3001\u6240\u9700\u8f6f\u4ef6<\/strong><\/p>

mysql-5.6.34.tar.gz<\/p>

\u4e0b\u8f7d\u5730\u5740\uff1ahttp:\/\/mirrors.sohu.com\/mysql\/MySQL-5.6\/mysql-5.6.34.tar.gz<\/p>

2\u3001\u6240\u9700\u73af\u5883<\/strong><\/p>

1\uff09\u5378\u8f7d\u81ea\u5e26 mysql<\/p>

# yum -y remove mysql*<\/p>

2\uff09\u5c06\u539f\u914d\u7f6e\u6587\u4ef6\u5220\u9664\u6216\u6539\u540d<\/p>

# mv \/etc\/my.cnf \/etc\/my.cnf.old<\/p>

\"\"<\/p>

1\u3001\u914d\u7f6eyum\u6e90<\/p>

1\uff09\u5c06\u7cfb\u7edf rhel-server-7.3-x86_64-dvd.iso \u6587\u4ef6\u62f7\u8d1d\u5230 \/soft \u76ee\u5f55\u4e0b<\/p>

# cp rhel-server-7.3-x86_64-dvd.iso \/soft\/<\/p>

2\uff09\u5efa\u7acb\u6302\u8f7d\u6240\u9700\u7684\u76ee\u5f55<\/p>

# mkdir -p \/media\/cdrom<\/p>

3\uff09\u6302\u8f7d
# mount -o loop \/soft\/rhel-server-7.3-x86_64-dvd.iso \/media\/cdrom<\/p>

4\uff09\u8fdb\u5165 \/etc\/yum.repo.d \u76ee\u5f55\uff0c\u5bf9yum \u6e90\u8fdb\u884c\u8bbe\u7f6e
# cd \/etc\/yum.repo.d
# vi server.repo<\/p>

\"\"<\/p>

5\uff09\u67e5\u770b\u662f\u5426\u5b89\u88c5\u6210\u529f\uff0c\u663e\u793a\u67094751 \u4e2a\u8f6f\u4ef6\u5305\uff0c\u6e90\u914d\u7f6e\u6210\u529f
# yum repolist<\/p>

\"\"<\/p>

2\u3001\u5b89\u88c5\u4f9d\u8d56<\/strong><\/p>

# yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ make cmake<\/p>

\"\"<\/p>

3\u3001\u521b\u5efa\u7528\u6237\u548c\u7ec4<\/strong><\/p>

# groupadd -r mysql<\/p>

# useradd -g mysql -r -d \/mydata\/data mysql<\/p>

4\u3001\u89e3\u538b\u5b89\u88c5\u5305<\/strong><\/p>

# tar zxvf mysql-5.6.34.tar.gz<\/p>

5\u3001\u7f16\u8bd1<\/strong><\/p>

# cd mysql-5.6.34<\/p>

# cmake . -DCMAKE_INSTALL_PREFIX=\/usr\/local\/mysql -DMYSQL_DATADIR=\/mydata\/data -DSYSCONFDIR=\/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 -DMYSQL_UNIX_ADDR=\/tmp\/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci<\/p>

\u5176\u4ed6\u53c2\u8003<\/em><\/p>

6\u3001\u5b89\u88c5<\/strong><\/p>

# make<\/p>

# make install<\/p>

\u67e5\u770bmysql\u7248\u672c<\/p>

# \/usr\/local\/mysql\/bin\/mysql --version<\/p>

\"\"<\/p>

1\u3001\u66f4\u6539 \/usr\/local\/mysql \u76ee\u5f55\u6240\u5c5e<\/strong><\/p>

# cd \/usr\/local<\/p>

# chown -R mysql:mysql mysql<\/p>

2\u3001\u5b89\u88c5perl<\/strong><\/p>

# yum -y install perl*<\/p>

3\u3001\u521d\u59cb\u5316\u6570\u636e\u5e93<\/strong><\/p>

# mkdir -p \/mydata\/data<\/p>

# cd \/usr\/local\/mysql<\/p>

# .\/scripts\/mysql_install_db --user=mysql --basedir=\/usr\/local\/mysql --datadir=\/mydata\/data<\/p>

Installing MySQL system tables...2016-12-12 13:24:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-12-12 13:24:13 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
2016-12-12 13:24:13 0 [Note] \/usr\/local\/mysql\/bin\/mysqld (mysqld 5.6.34) starting as process 4076 ...
2016-12-12 13:24:13 4076 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-12-12 13:24:13 4076 [Note] InnoDB: The InnoDB memory heap is disabled
2016-12-12 13:24:13 4076 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-12-12 13:24:13 4076 [Note] InnoDB: Memory barrier is not used
2016-12-12 13:24:13 4076 [Note] InnoDB: Compressed tables use zlib 1.2.7
2016-12-12 13:24:13 4076 [Note] InnoDB: Using CPU crc32 instructions
2016-12-12 13:24:13 4076 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-12-12 13:24:13 4076 [Note] InnoDB: Completed initialization of buffer pool
2016-12-12 13:24:13 4076 [Note] InnoDB: The first specified data file .\/ibdata1 did not exist: a new database to be created!
2016-12-12 13:24:13 4076 [Note] InnoDB: Setting file .\/ibdata1 size to 12 MB
2016-12-12 13:24:13 4076 [Note] InnoDB: Database physically writes the file full: wait...
2016-12-12 13:24:13 4076 [Note] InnoDB: Setting log file .\/ib_logfile101 size to 48 MB
2016-12-12 13:24:14 4076 [Note] InnoDB: Setting log file .\/ib_logfile1 size to 48 MB
2016-12-12 13:24:16 4076 [Note] InnoDB: Renaming log file .\/ib_logfile101 to .\/ib_logfile0
2016-12-12 13:24:16 4076 [Warning] InnoDB: New log files created, LSN=45781
2016-12-12 13:24:16 4076 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-12-12 13:24:16 4076 [Note] InnoDB: Doublewrite buffer created
2016-12-12 13:24:16 4076 [Note] InnoDB: 128 rollback segment(s) are active.
2016-12-12 13:24:16 4076 [Warning] InnoDB: C","orderid":"0","title":"RHEL 7.3 \u5b89\u88c5 MySQL 5.6 \u6559\u7a0b(\u4e00)","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"499","pages":"3","comments":"0","posttime":"2017-05-27 17:35:59","list":"1495877759","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"RHEL<\/A> 7.3<\/A> \u5b89\u88c5<\/A> MySQL<\/A> 5.6<\/A> \u6559\u7a0b<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"218.17.197.194","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"RHEL 7.3 \u5b89\u88c5 MySQL 5.6 \u6559\u7a0b","lastview":"1713611566","digg_num":"5126","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}