Linux CentOS6.5源码安装多个 mariadb10.0.15

Linux CentOS6.5源码安装多个 mariadb10.0.15

准备工作

1、安装依赖包

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

libtool-ltdl-devel* libaio-devel

2、创建目录，组，用户

groupadd mysql

useradd -g mysql mysql

--数据库1

-DCMAKE_INSTALL_PREFIX=/app/mysql1/mysql \

-DMYSQL_DATADIR=/app/mysql1/mysql/data \

-DSYSCONFDIR=/app/mysql1/mysql \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DMYSQL_UNIX_ADDR=/app/mysql1/mysql/mysql.sock \

-DMYSQL_TCP_PORT=3306 \

-DENABLED_LOCAL_INFILE=1 \

scripts/mysql_install_db --basedir=/app/mysql1/mysql --datadir=/app/mysql1/mysql/data --user=mysql

重命名/etc下的my.cnf文件，将源码包里的 support-files目录下的my-innodb-heavy-4G.cnf复制成/app/mysql1/mysql目录下的

my.cnf

cp support-files/my-innodb-heavy-4G.cnf /app/mysql1/mysql/my.cnf

设置环境变量增加数据库1的PATH

vi /etc/profile

PATH=/app/mysql1/mysql/bin:$PATH

export PATH

source /etc/profile

cd /app/mysql1/mysql/bin

设置本机登录密码和远程登录密码

mysql> SET PASSWORD = PASSWORD('123456');

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

资源由　ｗｗｗ．ｅｉｍｈｅ．ｃｏｍ　美河学习在线收集提供