centos6.5下編譯安裝mariadb-10.0.20
原始碼編譯安裝mariadb-10.0.20.tar.gz
# yum install -y gcc*
# yum install -y cmake
解決依賴關係
# yum install -y readline-devel zlib-devel openssl-devel
# yum install -y libaio perl perl-DBI perl-Module-Pluggable perl-Pod-Escapes perl-Pod-Simple perl-libs perl-version
# yum install -y ncurses ncurses libxml2 libxml2-devel bison bison-devel
# tar xf mariadb-10.0.20.tar.gz
# cd mariadb-10.0.20
# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mydata -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
# make && make install
建立mysql資料儲存的目錄
# mkdir -pv /data/mydata
劃分一個大小為10G的邏輯卷儲存mysql資料,將該卷掛載在/data/mydata目錄下
# lvcreate -n mylv -L 10G /dev/myvg
# mke2fs -t ext4 /dev/myvg/mylv
# groupadd -r -g 306 mysql
# useradd -g mysql -r -g 306 -s /sbin/nologin mysql
驗證
# id mysql
改變資料儲存目錄和安裝目錄的許可權
# cd /usr/local/mysql
# chown -R :mysql ./*
# chown -R mysql.mysql /data/mydata
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# cp support-files/my-large.cnf /etc/my.cnf
加入到伺服器啟動項
# chkconfig --add mysqld
# chkconfig --list mysqld
將mysql命令加入環境變數中
vim /etc/profile.d/mysql.sh
加入
export PATH=/usr/local/mysql/bin:$PATH
# service mysqld start
一.安裝cmake編譯工具
跨平臺編譯器# yum install -y gcc*
# yum install -y cmake
解決依賴關係
# yum install -y readline-devel zlib-devel openssl-devel
# yum install -y libaio perl perl-DBI perl-Module-Pluggable perl-Pod-Escapes perl-Pod-Simple perl-libs perl-version
# yum install -y ncurses ncurses libxml2 libxml2-devel bison bison-devel
二、編譯安裝mariadb-10.0.20
# tar xf mariadb-10.0.20.tar.gz
# cd mariadb-10.0.20
# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mydata -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
# make && make install
建立mysql資料儲存的目錄
# mkdir -pv /data/mydata
劃分一個大小為10G的邏輯卷儲存mysql資料,將該卷掛載在/data/mydata目錄下
# lvcreate -n mylv -L 10G /dev/myvg
# mke2fs -t ext4 /dev/myvg/mylv
三、建立Mysql使用者
//制定組id和使用者id為306# groupadd -r -g 306 mysql
# useradd -g mysql -r -g 306 -s /sbin/nologin mysql
驗證
# id mysql
改變資料儲存目錄和安裝目錄的許可權
# cd /usr/local/mysql
# chown -R :mysql ./*
# chown -R mysql.mysql /data/mydata
四、啟動指令碼初始化資料庫
# scripts/mysql_install_db --user=mysql --datadir=/data/mydata# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# cp support-files/my-large.cnf /etc/my.cnf
編輯/etc/my.cnf加入
innodb_file_per_table = ON
datadir = /data/mydata
log-bin=/data/binlogs/mysql-bin
加入到伺服器啟動項
# chkconfig --add mysqld
# chkconfig --list mysqld
將mysql命令加入環境變數中
vim /etc/profile.d/mysql.sh
加入
export PATH=/usr/local/mysql/bin:$PATH
# service mysqld start
# ss -tnl
初始化
MariaDB [(none)]> use mysql;
刪除匿名使用者:
MariaDB [mysql]> delete from user where host='localhost' and user='';
MariaDB [mysql]> delete from user where host='centossz008' and user='';
MariaDB [mysql]> delete from user where host='::1' and user='root';
相關文章
- Linux CentOS6.5下編譯安裝MySQL 5.6LinuxCentOS編譯MySql
- CentOS6.5編譯安裝最新MySQL 5.7.11CentOS編譯MySql
- Mysql5.6 for Centos6.5原始碼編譯安裝MySqlCentOS原始碼編譯
- CentOS6.5下Hadoop的編譯CentOSHadoop編譯
- CentOS 下編譯安裝 NginxCentOS編譯Nginx
- CentOS 下編譯安裝 apacheCentOS編譯Apache
- windows下編譯安裝thriftWindows編譯
- ubuntu下 編譯安裝swftoolsUbuntu編譯
- Centos 下編譯安裝RedisCentOS編譯Redis
- CentOS6.5下安裝mongodbCentOSMongoDB
- Windows下CMake編譯安裝OpenCVWindows編譯OpenCV
- Linux下編譯安裝BOOSTLinux編譯
- centos6.5下安裝配置hudsonCentOS
- 【MySQL安裝】Linux下安裝MySQL(預編譯)MySqlLinux編譯
- [BBED]Oracle 11.2.0.4 Centos6.5下編譯bbedOracleCentOS編譯
- CentOS 下編譯安裝 PHP7.2CentOS編譯PHP
- Linux Centos下編譯安裝RedisLinuxCentOS編譯Redis
- centos7下編譯安裝lnmpCentOS編譯LNMP
- 在solrais下編譯安裝MySQL(轉)SolrAI編譯MySql
- CentOS6.5下安裝Open vSwitchCentOS
- Centos下Sphinx的下載與編譯安裝CentOS編譯
- Linux 環境下編譯安裝 RedisLinux編譯Redis
- CentOS 6.4下編譯安裝MySQL 5.6.14CentOS編譯MySql
- linux下編譯安裝perl(5.10.0)Linux編譯
- 在Centos5.2下編譯安裝LAMPCentOS編譯LAMP
- CentOS6.5下MySQL5.6的安裝CentOSMySql
- centos6.5下安裝fpm打包工具CentOS
- 4、CentOS6.5下安裝php5.3CentOSPHP
- 編譯安裝zabbix編譯
- apache編譯安裝Apache編譯
- 編譯安裝nmon編譯
- swoole 編譯安裝編譯
- 編譯安裝Nginx編譯Nginx
- 編譯安裝mysql編譯MySql
- nginx編譯安裝Nginx編譯
- Linux下nginx編譯安裝教程和編譯引數詳解LinuxNginx編譯
- Elam的caffe筆記之配置篇(一):CentOS6.5編譯安裝gcc4.8.2筆記CentOS編譯GC
- CentOS 下編譯安裝 PHP7.2(nginx 版)CentOS編譯PHPNginx