国产激情自拍_国产9色视频_丁香花在线电影小说观看 _久久久久国产精品嫩草影院

首頁 > 數據庫 > 文庫 > 正文

MariaDB 10.1源碼安裝進程 CentOS 6.5

2024-09-07 22:12:36
字體:
來源:轉載
供稿:網友
         --安裝所需軟件包
        [root@localhost mariadb-10.1.14]# yum install bison bison-devel ncurses libxml2 libxml2-devel
 
      下載新版本的cmake工具
       [root@localhost install]# wget https://cmake.org/files/v3.5/cmake-3.5.2.tar.gz --no-check-certificate
       --2016-06-17 05:21:22--  https://cmake.org/files/v3.5/cmake-3.5.2.tar.gz
Resolving cmake.org... 66.194.253.19
Connecting to cmake.org|66.194.253.19|:443... connected.
WARNING: certificate common name “*.kitware.com” doesn’t match requested host name “cmake.org”.
HTTP request sent, awaiting response... 200 OK
Length: 6863498 (6.5M) [application/x-gzip]
Saving to: “cmake-3.5.2.tar.gz”
 
100%[===================================================================================================================>] 6,863,498    137K/s   in 65s    
2016-06-17 05:22:35 (104 KB/s) - “cmake-3.5.2.tar.gz” saved [6863498/6863498]
 
[root@localhost install]# tar fxvz cmake-3.5.2.tar.gz
[root@localhost install]# cd cmake-3.5.2
[root@localhost cmake-3.5.2]# ./bootstrap
 
編譯安裝cmake3.5.2
 
[root@localhost cmake-3.5.2]# make
.....
[ 98%] Building C object Tests/CMakeLib/PseudoMemcheck/NoLog/CMakeFiles/pseudonl_BC.dir/ret0.c.o
[ 99%] Linking C executable BC
[ 99%] Built target pseudonl_BC
Scanning dependencies of target pseudonl_purify
[ 99%] Building C object Tests/CMakeLib/PseudoMemcheck/NoLog/CMakeFiles/pseudonl_purify.dir/ret0.c.o
[ 99%] Linking C executable purify
[ 99%] Built target pseudonl_purify
Scanning dependencies of target pseudonl_valgrind
[ 99%] Building C object Tests/CMakeLib/PseudoMemcheck/NoLog/CMakeFiles/pseudonl_valgrind.dir/ret0.c.o
[ 99%] Linking C executable valgrind
[ 99%] Built target pseudonl_valgrind
Scanning dependencies of target pseudo_emulator
[ 99%] Building C object Tests/RunCMake/CMakeFiles/pseudo_emulator.dir/pseudo_emulator.c.o
[ 99%] Linking C executable pseudo_emulator
[ 99%] Built target pseudo_emulator
Scanning dependencies of target pseudo_iwyu
[100%] Building C object Tests/RunCMake/CMakeFiles/pseudo_iwyu.dir/pseudo_iwyu.c.o
[100%] Linking C executable pseudo_iwyu
[100%] Built target pseudo_iwyu
Scanning dependencies of target foo
[100%] Building CXX object Tests/FindPackageModeMakefileTest/CMakeFiles/foo.dir/foo.cpp.o
[100%] Linking CXX static library libfoo.a
[100%] Built target foo
 
[root@localhost cmake-3.5.2]# make install
.....
-- Installing: /usr/local/bin/ccmake
-- Installing: /usr/local/bin/cmake
-- Installing: /usr/local/bin/ctest
-- Installing: /usr/local/bin/cpack
-- Installing: /usr/local/share/cmake-3.5/include/cmCPluginAPI.h
-- Installing: /usr/local/share/cmake-3.5/editors/vim/cmake-help.vim
-- Installing: /usr/local/share/cmake-3.5/editors/vim/cmake-indent.vim
-- Installing: /usr/local/share/cmake-3.5/editors/vim/cmake-syntax.vim
-- Installing: /usr/local/share/cmake-3.5/editors/emacs/cmake-mode.el
-- Installing: /usr/local/share/aclocal/cmake.m4
-- Installing: /usr/local/share/cmake-3.5/completions/cmake
-- Installing: /usr/local/share/cmake-3.5/completions/cpack
-- Installing: /usr/local/share/cmake-3.5/completions/ctest
 
--查看cmake的版本
[root@localhost cmake-3.5.2]# cmake --version
cmake version 3.5.2
 
CMake suite maintained and supported by Kitware (kitware.com/cmake).
 
--下載MariaDB 10.1源碼包
[root@localhost install]# wget http://mirrors.tuna.tsinghua.edu.cn/mariadb//mariadb-10.1.14/source/mariadb-10.1.14.tar.gz
--2016-06-15 23:47:38--  http://mirrors.tuna.tsinghua.edu.cn/mariadb//mariadb-10.1.14/source/mariadb-10.1.14.tar.gz
Resolving mirrors.tuna.tsinghua.edu.cn... 166.111.206.63, 2402:f000:1:416:166:111:206:63
Connecting to mirrors.tuna.tsinghua.edu.cn|166.111.206.63|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 55341017 (53M) [application/octet-stream]
Saving to: “mariadb-10.1.14.tar.gz”
 
100%[===================================================================================================================>] 55,341,017   576K/s   in 64s     
2016-06-15 23:48:44 (843 KB/s) - “mariadb-10.1.14.tar.gz” saved [55341017/55341017]
 
[root@localhost install]# tar -zxvf mariadb-10.1.14.tar.gz
[root@localhost install]# cd mariadb-10.1.14
[root@localhost mariadb-10.1.14]# ls
BUILD           config.h.cmake      CREDITS            extra               libmysql     mysys      README      storage        VERSION
BUILD-CMAKE     configure.cmake     dbug               include             libmysqld    mysys_ssl  scripts     strings        vio
client          COPYING             debian             INSTALL-SOURCE      libservices  pcre       sql         support-files  win
cmake           COPYING.LESSER      Docs               INSTALL-WIN-SOURCE  man          plugin     sql-bench   tests          wsrep
CMakeLists.txt  COPYING.thirdparty  EXCEPTIONS-CLIENT  KNOWN_BUGS.txt      mysql-test   randgen    sql-common  unittest       zlib
 
--創建MariaDB軟件安裝目錄、數據文件和日志文件目錄
[root@localhost storage]# mkdir /maria
[root@localhost storage]# mkdir -p /maria_data/cnf
[root@localhost maria_data]# mkdir -p /log/maria
[root@localhost maria_data]# chown -R mysql:mysql /log/maria/
 
--開始編譯安裝
[root@localhost mariadb-10.1.14]# cmake . -DCMAKE_INSTALL_PREFIX=/maria /
-DDEFAULT_CHARSET=utf8 /
-DDEFAULT_COLLATION=utf8_general_ci /
-DENABLED_LOCAL_INFILE=ON /
-DWITH_XTRADB_STORAGE_ENGINE=1 /
-DWITH_MYISAM_STORAGE_ENGINE=1 /
-DWITH_INNOBASE_STORAGE_ENGINE=1 /
-DWITH_FEDERATEDX_STORAGE_ENGINE=1 /
-DWITH_PARTITION_STORAGE_ENGINE=1 /
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 /
-DCOMPILATION_COMMENT='MariaDB 10.1 production environment' /
-DWITH_READLINE=ON /
-DSYSCONFDIR=/maria_data/cnf /
-DMYSQL_UNIX_ADDR=/maria_data/maria.sock /
-DMYSQL_DATADIR=/maria_data
 
-- Running cmake version 3.5.2
-- MariaDB 10.1.14
-- Packaging as: mariadb-10.1.14-Linux-x86_64
-- OPENSSL_INCLUDE_DIR = /usr/include
-- OPENSSL_LIBRARIES = /usr/lib64/libssl.so
-- CRYPTO_LIBRARY = /usr/lib64/libcrypto.so
-- OPENSSL_MAJOR_VERSION = 1
-- SSL_LIBRARIES = /usr/lib64/libssl.so;/usr/lib64/libcrypto.so;dl
-- Checking for one of the modules 'libsystemd;libsystemd-daemon'
-- Systemd features not enabled
-- Found LibXml2: /usr/lib64/libxml2.so (found version "2.7.6")
-- Configuring done
-- Generating done
-- Build files have been written to: /install/mariadb-10.1.14
 
[root@localhost mariadb-10.1.14]# make
.....
Scanning dependencies of target bug25714
[100%] Building C object tests/CMakeFiles/bug25714.dir/bug25714.c.o
[100%] Linking CXX executable bug25714
[100%] Built target bug25714
Scanning dependencies of target mysql_client_test
[100%] Building C object tests/CMakeFiles/mysql_client_test.dir/mysql_client_test.c.o
[100%] Linking CXX executable mysql_client_test
[100%] Built target mysql_client_test
Scanning dependencies of target mysqld
[100%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o
[100%] Linking CXX executable mysqld
[100%] Built target mysqld
Scanning dependencies of target udf_example
[100%] Building C object sql/CMakeFiles/udf_example.dir/udf_example.c.o
[100%] Linking C shared module udf_example.so
[100%] Built target udf_example
Scanning dependencies of target mysql_tzinfo_to_sql
[100%] Building CXX object sql/CMakeFiles/mysql_tzinfo_to_sql.dir/tztime.cc.o
[100%] Linking CXX executable mysql_tzinfo_to_sql
[100%] Built target mysql_tzinfo_to_sql
Scanning dependencies of target my_safe_process
[100%] Building CXX object mysql-test/lib/My/SafeProcess/CMakeFiles/my_safe_process.dir/safe_process.cc.o
[100%] Linking CXX executable my_safe_process
[100%] Built target my_safe_process
 
[root@localhost mariadb-10.1.14]# make install
.....
-- Installing: /maria/bin/mytop
-- Installing: /maria/bin/mysqlhotcopy
-- Installing: /maria/bin/mysqldumpslow
-- Installing: /maria/bin/mysqld_multi
-- Installing: /maria/bin/mysqld_safe
-- Installing: /maria/bin/wsrep_sst_common
-- Installing: /maria/bin/wsrep_sst_mysqldump
-- Installing: /maria/bin/wsrep_sst_rsync
-- Installing: /maria/bin/wsrep_sst_xtrabackup
-- Installing: /maria/bin/wsrep_sst_xtrabackup-v2
-- Installing: /maria/share/maria_add_gis_sp.sql
-- Installing: /maria/share/maria_add_gis_sp_bootstrap.sql
-- Installing: /maria/support-files/my-huge.cnf
-- Installing: /maria/support-files/my-innodb-heavy-4G.cnf
-- Installing: /maria/support-files/my-large.cnf
-- Installing: /maria/support-files/my-medium.cnf
-- Installing: /maria/support-files/my-small.cnf
-- Installing: /maria/support-files/wsrep.cnf
-- Installing: /maria/support-files/mysqld_multi.server
-- Installing: /maria/support-files/mysql-log-rotate
-- Installing: /maria/support-files/binary-configure
-- Installing: /maria/support-files/wsrep_notify
-- Installing: /maria/support-files/magic
-- Installing: /maria/support-files/policy
-- Installing: /maria/support-files/policy/apparmor
-- Installing: /maria/support-files/policy/apparmor/usr.sbin.mysqld
-- Installing: /maria/support-files/policy/apparmor/README
-- Installing: /maria/support-files/policy/apparmor/usr.sbin.mysqld.local
-- Installing: /maria/support-files/policy/selinux
-- Installing: /maria/support-files/policy/selinux/mariadb-server.te
-- Installing: /maria/support-files/policy/selinux/README
-- Installing: /maria/support-files/policy/selinux/mariadb-server.fc
-- Installing: /maria/share/pkgconfig/mariadb.pc
-- Installing: /maria/share/aclocal/mysql.m4
-- Installing: /maria/support-files/mysql.server
 
--更改MariaDB數據文件的權限為mysql
[root@localhost cnf]# chown -R mysql:mysql /maria_data/
 
--創建MySQL數據庫的系統表
[root@localhost maria]# /maria/scripts/mysql_install_db --user=mysql  --datadir=/maria_data/
.....
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-17 17:37:16 139707541080032 [Note] InnoDB: Waiting for purge to start
2016-06-17 17:37:16 139707541080032 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.29-76.2 started; log sequence number 1616819
2016-06-17 17:37:16 139706685712128 [Note] InnoDB: Dumping buffer pool(s) not yet started
OK
 
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
 
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
 
'./bin/mysqladmin' -u root password 'new-password'
'./bin/mysqladmin' -u root -h localhost.localdomain password 'new-password'
 
Alternatively you can run:
'./bin/mysql_secure_installation'
 
which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.
 
See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.
 
You can start the MariaDB daemon with:
cd '.' ; ./bin/mysqld_safe --datadir='/maria_data/'
 
You can test the MariaDB daemon with mysql-test-run.pl
cd './mysql-test' ; perl mysql-test-run.pl
 
Please report any problems at http://mariadb.org/jira
 
The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from MariaDB
Corporation Ab. You can contact us about this at sales@mariadb.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/
 
--拷貝配置文件模板到配置文件目錄
[root@localhost maria]# cp ./support-files/my-medium.cnf /maria_data/cnf/my.cnf
 
--啟動數據庫
[root@localhost maria]# ./bin/mysqld_safe --defaults-file=/maria_data/cnf/my.cnf &
[1] 14633
[root@localhost maria]# 160617 18:55:09 mysqld_safe Logging to '/log/maria/err.log'.
160617 18:55:09 mysqld_safe Starting mysqld daemon with databases from /maria_data
 
--修改root用戶密碼
[root@localhost maria]# ./bin/mysqladmin -uroot password 'root'
 
--連接數據庫
[root@localhost maria]# ./bin/mysql -uroot -p'root'
Welcome to the MariaDB monitor.  Commands end with ; or /g.
Your MariaDB connection id is 6
Server version: 10.1.14-MariaDB MariaDB 10.1 production environment
 
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
 
Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.
 
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| cnf                |
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.00 sec)
 
MariaDB [(none)]> use test
Database changed
MariaDB [test]> show tables;
Empty set (0.00 sec)
 
MariaDB [test]> create table test(a int);
Query OK, 0 rows affected (0.08 sec)
 
MariaDB [test]> show create table test;
+-------+---------------------------------------------------------------------------------------+
| Table | Create Table                                                                          |
+-------+---------------------------------------------------------------------------------------+
| test  | CREATE TABLE `test` (
  `a` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+---------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
 
MariaDB [test]> insert into test values(100);
Query OK, 1 row affected (0.00 sec)
 
MariaDB [test]> select * from test;
+------+
| a    |
+------+
|  100 |
+------+
1 row in set (0.00 sec)
 
MariaDB [test]> show engines;
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                                                          | Transactions | XA   | Savepoints |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
| MRG_MyISAM         | YES     | Collection of identical MyISAM tables                                                            | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                                                            | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                                                               | NO           | NO   | NO         |
| FEDERATED          | YES     | FederatedX pluggable storage engine                                                              | YES          | NO   | YES        |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                                        | NO           | NO   | NO         |
| Aria               | YES     | Crash-safe tables with MyISAM heritage                                                           | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                                               | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | YES          | YES  | YES        |
| SEQUENCE           | YES     | Generated tables filled with sequential values                                                   | YES          | NO   | YES        |
+--------------------+---------+--------------------------------------------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)

(編輯:武林網)

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
国产激情自拍_国产9色视频_丁香花在线电影小说观看 _久久久久国产精品嫩草影院
国产精品美女一区二区三区四区| 日本天堂影院在线视频| 久草在线视频网| 日韩黄色成人| 黄色毛片在线看| 2018中文字幕在线| 天天激情综合| 中文字幕在线第一页| 国产高清av| 日本国产在线| www.综合网.com| 中文字幕在线免费观看| 中文字幕4区| 精品中文字幕不卡在线视频| 国产精品9区| 人xxxx性xxxxx欧美| 中文字幕毛片| 免费看的av| 中文在线观看视频| 午夜视频在线| www在线观看播放免费视频日本| 成人精品一区二区三区免费| 91av福利| 中文字幕一区免费| 日本一级理论片在线大全| 另类综合图区| 精品欧美不卡一区二区在线观看| 免费a在线观看| av网站在线播放| 777电影在线观看| 中文字幕乱在线伦视频乱在线伦视频| 永久免费在线观看| 2021av天天| 国产精品99爱免费视频| 九九在线观看免费视频| 日本不卡1区2区3区| www.99av| 九九热在线播放| 成人欧美精品久久久久影院| 老师我好爽再深一点的视频| 在线免费观看黄色片| 91视频久色| 四虎成年永久免费网站| 日本不卡视频一区二区| 国产福利热线视频| 国产成人精品实拍在线| 国产馆av播放| av在线免费播放| 欧美精品久久久久久久小说| 爱福利在线视频| 国产真实伦在线观看| 国产美女自拍视频| 国产人成在线观看| 18激情网站| 免费三级毛片| 黄色av免费在线| 国产精品欧美韩国日本久久| av福利在线播放| 嫩草在线播放| 国产香蕉在线| 亚洲网站视频在线观看| 超碰在线国产| 国产精品18久久久久网站| 在线中文字幕资源| 麻豆国产在线视频| 国产精品777一区二区| av网址在线看| 国产午夜精品一区理论片| 精品一区二区观看| 好男人社区在线视频| 91sp网站在线观看入口| 在线播放黄色网址| 国产一区二区影视| 青青草原国产在线| 国产95在线|亚洲| 九色成人在线| 在线中文字幕视频观看| 青草青在线视频| 中文在线观看视频| 国产精品一卡二卡三卡| 天天插天天操| 一区二区精品区| 中文字幕在线影院| 亚洲精品xxxxx| 在线一二三区| 国产精品外围在线观看| av三级在线观看| 伊人网在线视频| 国产三级av在线| 国产在线二区| 激情丁香在线| 超碰人人在线| 久久久久久久久亚洲精品| 一区二区三区免费视频网站| 国产网红在线| 国产网站免费看| 国产一区二区三区四区尤物| 国产精品㊣新片速递bt| 老司机精品视频一区二区| 日本三级在线视频| 在线色视频网| 伊人伊人av电影| 亚洲人成电影| 日本视频二区| 青青草免费在线视频| 青青草中文字幕| 免费三级毛片| 99视频资源网| 精品美女视频在线观看免费软件| 国产精品久久麻豆| 9色在线视频网站| 九九热视频精品在线观看| 福利视频在线看| 国产一二三区在线| 国产精品入口麻豆高清| 国产欧美日韩精品综合| 国产精品伦理一区二区三区| 精品国语对白精品自拍视| 亚洲成人电视网| 国产免费麻豆视频| 国产二区视频| 久久国产热视频| 国产激情三区| 欧美精品小视频| 国产三级在线免费观看| 在线免费看黄| 丁香花高清在线观看完整版| 国产精品被窝福利一区| gogo在线观看| 国产区视频在线观看| 夜夜嗨yeyeh| 五月伊人六月| eeuss影院网站免费观看| 综合激情亚洲| 亚洲91av| 精品国内一区二区三区免费视频| 青青草观看免费视频在线| 国产毛片视频| 日本久久网站| 99久久免费精品国产免费| 国产剧情在线一区| 欧美xxxx黑人又粗又长| 国产网站在线免费观看| jizz在线视频| a视频免费看| 91中文字幕| 中文字幕在线永久在线视频| 女同一区二区免费aⅴ| 永久免费av网站| 国产极品一区二区三区| 国产美女在线看| 久久er视频| 狠狠色综合久久婷婷| 四虎精品视频| 四虎免费播放| 天天激情综合| 欧美亚洲系列| 超碰人人在线| 久草网在线视频| 黄色网址在线免费播放| 操人视频91| 狠狠操天天操夜夜操| 男人天堂v视频| 国产在线高清| 国产乱子视频| 国产三区四区在线观看| 国产人成在线视频| 国产成人综合亚洲欧美在| 国产黄在线看| 伊人免费视频| 免费国产阿v视频在线观看| 欧洲有码在线视频| 久蕉依人在线视频| 国产精品一卡二卡三卡| 中文字幕乱在线伦视频乱在线伦视频| 九色精品视频在线观看| 成人超碰在线| 国产粉嫩一区二区三区在线观看| 中文在线视频| 免费观看一二区视频网站| 黄色国产网站在线播放| 中文字幕人成高视频| 国产黄色免费网| 性国产高清在线观看| 在线久久视频| 最近最好的中文字幕2019免费 | 四虎成人欧美精品在永久在线 | 亚洲欧美日韩成人网| 四虎免费播放| 国产精品毛片一区二区三区四区| 亚洲精品国自产拍在线观看| 天天av综合网| 免费精品国产自产拍在| 国产黄网站在线观看| 三级小说一区| 在线中文视频| 国产三级视频在线| 男女羞羞视频在线观看| 尤物视频在线观看视频| 国产女主播在线观看|