Debian系统编译安装和配置MariaDB 10.0.1数据库
先更新系统
aptitude update && aptitude -y full-upgrade
安装编译环境
aptitude -y install build-essential libcloog-ppl0
建立源文件存放目录
mkdir /opt/sources
chmod +X /opt/sources
安装编译MariaDB所需的库文件
aptitude -y install cmake libev-libevent-dev libncurses5-dev bison
创建运行数据库程序的用户及用户组
groupadd mysql
useradd -M -s /sbin/nologin -g mysql mysql
下面正式开始干活
cd /opt/sources
wget http://ftp.osuosl.org/pub/mariadb/mariadb-10.0.1/kvm-tarbake-jaunty-x86/mariadb-10.0.1.tar.gz
tar -zxvf mariadb-10.0.1.tar.gz
cd mariadb-10.0.1
CC=gcc
CXX=g++
CHOST="x86_64-pc-linux-gnu"
CFLAGS="-O3
-fomit-frame-pointer
-march=native
-pipe
-mmmx
-mfpmath=sse
-m128bit-long-double
-m64
-maccumulate-outgoing-args
-ftree-loop-linear
-fprefetch-loop-arrays
-fno-omit-frame-pointer
-freg-struct-return
-fgcse-sm
-fgcse-las
-fforce-addr
-fivopts
-ftree-vectorize
-ftracer
-frename-registers
-minline-all-stringops
-fbranch-target-load-optimize2"
CXXFLAGS="${CFLAGS}"
export CXX CFLAGS CXXFLAGS
cmake .
-DCMAKE_BUILD_TYPE:STRING=Release
-DCMAKE_INSTALL_PREFIX:PATH=/usr/local/mysql
-DENABLE_DEBUG_SYNC:BOOL=OFF
-DMYSQL_DATADIR:PATH=/var/lib/mysql
-DUSE_ARIA_FOR_TMP_TABLES:BOOL=ON
-DWITHOUT_PBXT_STORAGE_ENGINE:BOOL=ON
-DWITH_ARCHIVE_STORAGE_ENGINE:BOOL=ON
-DWITH_ARIA_STORAGE_ENGINE:BOOL=ON
-DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=OFF
-DWITH_EMBEDDED_SERVER:BOOL=OFF
-DWITH_EXTRA_CHARSETS:STRING=all
-DWITH_FEDERATEDX_STORAGE_ENGINE:BOOL=OFF
-DWITH_FEEDBACK:BOOL=OFF
-DWITH_INNOBASE_STORAGE_ENGINE:BOOL=ON
-DWITH_LIBWRAP:BOOL=OFF
-DWITH_PARTITION_STORAGE_ENGINE:BOOL=ON
-DWITH_PERFSCHEMA_STORAGE_ENGINE:BOOL=ON
-DWITH_SSL:STRING=system
-DWITH_ZLIB:STRING=system
make -j4
make install
创建数据库所需目录并更改所有权
mkdir /var/run/mysqld
mkdir /var/log/mysql
mkdir -p /var/lib/mysql
mkdir /etc/mysql
chown -R mysql:mysql /usr/local/mysql/
chown -R mysql:mysql /var/run/mysqld/
chown -R mysql:mysql /var/log/mysql/
chown -R mysql:mysql /var/lib/mysql/
复制配置文件
cp support-files/my-medium.cnf /etc/mysql/my.cnf
复制启动脚本并将其设置为系统服务
cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
insserv mysqld
安装数据库系统表
cd /usr/local/mysql/scripts
./mysql_install_db --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql
启动数据库程序
cd /usr/local/mysql
/usr/local/mysql/bin/mysqld_safe &
更改root用户密码
/usr/local/mysql/bin/mysqladmin -u root password 'MyTest@MyTEST'
测试root用户
/usr/local/mysql/bin/mysql -u root -p'MyTest@MyTEST'
q
Debian系统编译安装和配置MariaDB 10.0.1数据库
