MariaDB 10源码安装教程

1、上传安装包：

2、解压

tar xf mariadb-10.0.23.tar.gz

创建mariadb 用户

useradd mariadb -s /sbin/nologin

安装涛瞧依赖包

yum -y install make gcc-c++ cmake bison-devel ncurses-devel

3、编泉铲耍译mariadb

 cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb -DWITH_ARIA_STORAGE_ENGINE=1 -DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1

4、安装mariadb

make && make install

这个时间比较长，需等待半个小时。胆佛

5、初始化mariadb

/usr/local/mariadb/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mariadb --datadir=/usr/local/mariadb/var --user=mariadb

6、加入系统开机服务

cp support-files/mysql.server /etc/init.d/mariadb

    chmod 755 /etc/init.d/mariadb

7、设置mariadb

 ln -sf /usr/local/mariadb/bin/mysql /usr/bin/mysql

    ln -sf /usr/local/mariadb/bin/mysqldump /usr/bin/mysqldump

    ln -sf /usr/local/mariadb/bin/myisamchk /usr/bin/myisamchk

    ln -sf /usr/local/mariadb/bin/mysqld_safe /usr/bin/mysqld_safe

    ln -sf /usr/local/mariadb/bin/mysqlcheck /usr/bin/mysqlcheck