Linux 源码安装MariaDB 10.0.16

cmake软件

tar -zxvf cmake-2.8.8.tar.gz

cd cmake-2.8.8

./bootstrap

make && make install

依赖包

yum install ncurses-devel -y

yum install pcre pcre-devel -y

yum install gcc* -y

创建用户

groupadd mysql

useradd -g mysql mysql

echo "oracle" |passwd --stdin mysql

创建目录

mkdir /application/mariadb10.0.16/{data,tmp} -p

chown -R mysql:mysql /application/mariadb10.0.16

解压编译MySQL

tar -zxvf mariadb-10.0.16.tar.gz

chown -R root:root mariadb-10.0.16

chmod -R 755 mariadb-10.0.16

cd mariadb-10.0.16

cmake . -DCMAKE_INSTALL_PREFIX=/application/mariadb10.0.16 -DMYSQL_DATADIR=/application/mariadb10.0.16/data -DMYSQL_UNIX_ADDR=/application/mariadb10.0.16/tmp/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1  -DWITH_ARCHIVE_STPRAGE_ENGINE=1  -DWITH_BLACKHOLE_STORAGE_ENGINE=1  -DWIYH_READLINE=1 -DWIYH_SSL=system -DVITH_ZLIB=system -DWITH_LOBWRAP=0 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

make && make install

创建软连接

ln -s /application/mariadb10.0.16 /application/mysql

初始化数据库

/application/mariadb10.0.16/scripts/mysql_install_db --basedir=/application/mysql --datadir=/application/mysql/data --user=mysql

添加/application/mysql/bin到环境变量

在/etc/profile中添加如下内容

export PATH=/application/mysql/bin:$PATH