Ubuntu (Debian) 编译安装Mariadb过程，亲测，有坑！

百度到的教程都是基于centos的，今天在ubuntu17.10上编译了下，发现大部分教程都有坑，在此记录下

首先准备环境

sudo apt-get install build-essential libcloog-ppl0

sudo apt-get install libssl-dev build-essential zlibc zlib-bin libidn11-dev libidn11

sudo apt-get install libcurl4-gnutls-dev

sudo apt-get install libexpat1-dev cmake libev-libevent-dev libncurses5-dev bison

建立源文件存放目录

mkdir /opt/sources

chmod +X /opt/sources

创建运行数据库程序的用户及用户组

groupadd mysql

useradd -M -s /sbin/nologin -g mysql mysql

开始

先下载源码文件，病拷贝到/opt/sources下

下载地址：https://downloads.mariadb.org/interstitial/mariadb-10.2.10/source/mariadb-10.2.10.tar.gz/from/http%3A//mariadb.nethub.com.hk/

或者进入官网自行下：https://downloads.mariadb.org/

cd /opt/sources

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/

chmod +x /etc/init.d/mysql.service

update-rc.d mysql defaults

安装数据库系统表

cd /usr/local/mysql/scripts

./mysql_install_db --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql

启动数据库程序

vim /etc/profile

在最后一行添加

export PATH=/usr/local/mysql/bin:$PATH

service mysql start

更改root用户密码

/usr/local/mysql/bin/mysqladmin -u root password '你的密码'

测试root用户

mysql -u root -p

然后输入你的密码

最后附图，如果对你有帮助，请给个赞