首頁論壇分類作業系統LinuxCentOS 7.x 編譯安裝 MariaDB
CentOS 7.x 編譯安裝 MariaDB
   編 輯        刪 除      # 5c8224a791e54 發表: Odyssey     新增:2018-09-20 10:34:31     更新:2018-09-20 10:34:31

MariaDB.org - Supporting continuity and open collaboration
https://mariadb.org/

Downloads - MariaDB
https://downloads.mariadb.org/

CMake
https://cmake.org/

Download | CMake
https://cmake.org/download/

下載 CMake
cd /usr/local/src
lynx https://cmake.org/files/v3.12/cmake-3.12.2.tar.gz

安裝 CMake
tar zxf cmake-3.12.2.tar.gz
cd cmake-3.12.2
./configure
make
make test
make install
make clean

執行位置
/usr/local/bin/cmake

下載 MariaDB
cd /usr/local/src
lynx http://ftp.yz.yamagata-u.ac.jp/pub/dbms/mariadb//mariadb-5.5.61/source/mariadb-5.5.61.tar.gz

安裝 MariaDB
tar zxf mariadb-5.5.61.tar.gz
cd mariadb-5.5.61
/usr/local/bin/cmake . -LH
/usr/local/bin/cmake . -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNODB_MEMCACHED=1 -DENABLE_MEMCACHED_SASL=1 -DENABLE_MEMCACHED_SASL_PWDB=1
make
make test
make install
make clean

切換到目的目錄
cd /usr/local/mysql
新增 mysql 使用者和群組並禁止登入
useradd -r -s /sbin/nologin mysql
變更擁有者
chown -R mysql .
變更群組
chgrp -R mysql .
安裝預設資料
scripts/mysql_install_db --user=mysql
執行測試
cd mysql-test
perl mysql-test-run.pl
變更程式擁有者為 root
chown -R root .
變更資料擁有者為 mysql
chown -R mysql data
複製設定檔
cp support-files/my-huge.cnf /etc/my.cnf
複製啟動檔
cp support-files/mysql.server /etc/init.d/mysql.server
編輯設定檔
vi /etc/my.cnf
character-set-server = utf8
collation-server = utf8_general_ci
default_storage_engine = MyISAM
#default_storage_engine = InnoDB
skip-external-locking
thread_concurrency
skip-networking

啟動 MariaDB
/usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data &
設定 root 帳號密碼
/usr/local/mysql/bin/mysqladmin -u root password '新密碼'
/usr/local/mysql/bin/mysql_secure_installation
登入 MariaDB
/usr/local/mysql/bin/mysql -u root -p
use mysql;
delete from user where Host <> 'localhost' or User <> 'root';
exit;


夢幻奧德修斯 - OdysseusDream
Website:https://www.odysseusdream.com/
Discord:https://discord.gg/ht4mwMG
FB社團:https://www.facebook.com/groups/OdysseusDream/

我要回覆
CentOS 7.x 編譯安裝 MariaDB
首頁論壇分類作業系統LinuxCentOS 7.x 編譯安裝 MariaDB