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、编译mariadbcmake -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb -DWITH_ARIA_S皈其拄攥TORAGE_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、安装mariadbmake && 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、设置mariadbln -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