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
创建数据库1的目录
mkdir -p /app/mysql1/mysql
修改目录权限给mysql用户
chown -R mysql:mysql /app
编译安装
cmake \
-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 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
make && make install
创建系统自带的数据库和表
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
添加服务,拷贝服务脚本到init.d目录
cp support-files/mysql.server /etc/init.d/mysql1
service mysql1 start --启动MySQL
初始登陆数据库1
mysql -uroot -S /app/mysql1/mysql/mysql.sock
设置本机登录密码和远程登录密码
mysql> SET PASSWORD = PASSWORD('123456');
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
资源由 www.eimhe.com 美河学习在线收集提供
评论0