3334人阅读
服务器技术（7）
系统环境：Centos6.6(Final)
mariadb端口：3309 (因为本机原先已经装的有mysql了，还不想删除mysql)
#wget .hk//mariadb-10.0.20/source/mariadb-10.0.20.tar.gz
建立mariadb用户
# groupadd -r mariadb
# useradd -g mariadb -r -M -s /sbin/nologin mariadb //这个mariadb用户不能登录
# yum -y install gcc gcc-c++ make cmake ncurses ncurses libxml2 libxml2-devel openssl-devel bison bison-devel
# tar zxvf mariadb-10.0.20.tar.gz
# cd mariadb-10.0.20
# cmake . -DMYSQL_UNIX_ADDR=/tmp/mariadb.sock -DSYSCONFDIR=/home/local/mariadb -DMYSQL_TCP_PORT=3309 -DEXTRA_CHARSETS=all -DMYSQL_USER=mariadb -DCMAKE_INSTALL_PREFIX=/home/local/mariadb -DMYSQL_DATADIR=/home/data/mariadb& -DWITH_XTRADB_STORAGE_ENGINE=1 -DWITH_FEDERATEDX_STORAGE_ENGINE=1
-DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -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 -j 4
# make install
把MariaDB服务加入系统环境变量：在最后添加下面这一行
# vim /etc/profile &
export PATH=$PATH:/home/local/mariadb/bin
# source /etc/profile
复制配置文件
# cp /home/local/mariadb/support-files/f /home/local/f
初始化数据库
# /home/local/mariadb/scripts/mysql_install_db --basedir=/home/local/mariadb --datadir=/home/data/mariadb --user=mariadb --defaults-file=/home/local/f
复制服务启动脚本
# cp /home/local/mariadb/support-files/mysql.server /etc/init.d/mariadb
# vim /etc/init.d/mariadb
$bindir/mysqld_safe --datadir=&$datadir& --pid-file=&$mysqld_pid_file_path& $other_args &/dev/null 2&&1 &
$bindir/mysqld_safe --defaults-file=/home/local/f --datadir=&$datadir& --pid-file=&$mysqld_pid_file_path& $other_args &/dev/null 2&&1 &
即添加了--defaults-file=/home/local/f
# chmod +x /etc/init.d/mariadb
# chkconfig mariadb on
配置/home/local/f
在[mysqld]模块添加下面的几行：
log-error = /home/logs/mariadb_error.log
pid-file = /home/local/mariadb/mariadb.pid
user=mariadb
datadir = /home/data/mariadb
basedir = /home/local/mariadb
新增加mysqld_safe块
[mysqld_safe]
log-error= /home/logs/mariadb_error.log
pid-file=/home/local/mariadb/mariadb.pid
启动前修下目录权限
# chown -R mariadb:mariadb /home/data/mariadb
# chown -R mariadb:mariadb /home/data/mariadb/.
# chown -R mariadb:mariadb /home/local/mariadb
# chown -R mariadb:mariadb /home/local/mariadb/.
启动MariaDB:
# /etc/init.d/mariadb start
注：如果启动失败，查看下/home/logs/mariadb_error.log文件看报什么错，修正即可。
设置root的密码
#/home/local/mariadb/bin/mysqladmin -u root password '123456'
进入MariaDB的shell下
[root@localhost mariadb]# /home/local/mariadb/bin/mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.& C or \g.
Your MariaDB connection id is 4
Server version: 10.0.20-MariaDB Source distribution
Copyright (c) , Oracle, MariaDB Corporation Ab and others.
Type '' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]& show engines\G;
*************************** 1. row ***************************
&&&&& Engine: InnoDB
&&&& Support: DEFAULT
&&&& Comment: Percona-XtraDB, Supports transactions, row-level locking, and foreign keys
Transactions: YES
&&&&&&&&& XA: YES
& Savepoints: YES
*************************** 2. row ***************************
&&&&& Engine: MRG_MyISAM
&&&& Support: YES
&&&& Comment: Collection of identical MyISAM tables
Transactions: NO
&&&&&&&&& XA: NO
& Savepoints: NO
*************************** 3. row ***************************
&&&&& Engine: CSV
&&&& Support: YES
&&&& Comment: CSV storage engine
Transactions: NO
&&&&&&&&& XA: NO
& Savepoints: NO
*************************** 4. row ***************************
&&&&& Engine: BLACKHOLE
&&&& Support: YES
&&&& Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
&&&&&&&&& XA: NO
& Savepoints: NO
*************************** 5. row ***************************
&&&&& Engine: MyISAM
&&&& Support: YES
&&&& Comment: MyISAM storage engine
Transactions: NO
&&&&&&&&& XA: NO
& Savepoints: NO
*************************** 6. row ***************************
&&&&& Engine: MEMORY
&&&& Support: YES
&&&& Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
&&&&&&&&& XA: NO
& Savepoints: NO
*************************** 7. row ***************************
&&&&& Engine: ARCHIVE
&&&& Support: YES
&&&& Comment: Archive storage engine
Transactions: NO
&&&&&&&&& XA: NO
& Savepoints: NO
*************************** 8. row ***************************
&&&&& Engine: PERFORMANCE_SCHEMA
&&&& Support: YES
&&&& Comment: Performance Schema
Transactions: NO
&&&&&&&&& XA: NO
& Savepoints: NO
*************************** 9. row ***************************
&&&&& Engine: FEDERATED
&&&& Support: YES
&&&& Comment: FederatedX pluggable storage engine
Transactions: YES
&&&&&&&&& XA: NO
& Savepoints: YES
*************************** 10. row ***************************
&&&&& Engine: Aria
&&&& Support: YES
&&&& Comment: Crash-safe tables with MyISAM heritage
Transactions: NO
&&&&&&&&& XA: NO
& Savepoints: NO
10 rows in set (0.00 sec)
ERROR: No query specified
MariaDB [mysql]& //选择系统数据库mysql& &
MariaDB [mysql]&select Host,User,P //查看所有用户& &
MariaDB [mysql]&delete from user where password=&&;
MariaDB [mysql]&GRANT ALL PRIVILEGES ON *.* TO root@&%& IDENTIFIED BY '123456'; //为root添加远程连接的能力
MariaDB [mysql]&& &
MariaDB [mysql]&select Host,User,P //确认密码为空的用户是否已全部删除& &
MariaDB [mysql]&
设置防火墙，以便局域网内的其它服务器可以访问
vi /etc/sysconfig/iptables
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3309 -j ACCEPT
/etc/init.d/iptables restart
参考知识库
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：235948次
积分：3178
积分：3178
排名：第8990名
原创：72篇
转载：44篇
评论：47条
(1)(3)(2)(2)(2)(1)(1)(1)(1)(4)(7)(5)(1)(2)(7)(1)(1)(3)(2)(1)(1)(1)(1)(1)(1)(5)(12)(32)(8)(8)CentOS6.5安装MariaDB10.0.15编译安装和多实例管理配置
CentOS6.5 x86_64 系统 [root@e3 ~]# wget https://downloads.mariadb.org/interstitial/mariadb-10.0.15/source/mariadb-10.0.15.tar.gz/from/http%3A//mirrors./mariadbgroupadd -r mysqluseradd -r -g mysql -s /sbin/nologin mysqlmkdir /
6.5 x86_64 系统
[root@e3 ~]# wget https://downloads.mariadb.org/interstitial/mariadb-10.0.15/source/mariadb-10.0.15.tar.gz/from/http%3A//mirrors./mariadb
groupadd -r mysql
useradd -r -g mysql -s /sbin/nologin mysql
mkdir /data/mydata{1..3}
-R mysql:mysql
yum -y install gcc gcc-c++ make cmake ncurses ncurses libxml2 libxml2-devel openssl-devel bison bison-devel #依赖组件
解压源码包
tar xf mariadb
cd mariadb-10.0.15/
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mydata
-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 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock
-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
-j 4 表示4核处理 能快点编译
make install
输出环境变量
[root@e3 ~]# vim /etc/pro.d/mysql.sh
export PATH=$PATH:/usr/local/mysql/bin/
[root@e3 mariadb-10.0.15]# . /etc/profile.d/mysql.sh
输出头文件库文件man帮助文档
vim /etc/ld.so.conf.d/mysql.conf
/usr/local/mysql/lib
[root@e3 mariadb-10.0.15]# vim /etc/man.config
MANPATH /usr/local/mysql/man
[root@e3 mariadb-10.0.15]# man -M
/usr/local/mysql/man/ mysqld
[root@e3 tmp]# /usr/local/mysql/scripts/mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/mydata1 --user=mysql
提供配置文件和启动脚本
[root@e3 mariadb-10.0.15]# cp /usr/local/mysql/support-files/f /f
[root@e3 mariadb-10.0.15]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@e3 mariadb-10.0.15]#
+x /etc/init.d/mysqld ^C
[root@e3 mariadb-10.0.15]# chkconfig mysqld on^C
[root@e3 mariadb-10.0.15]# /etc/init.d/mysqld start
直接输入mysql
多实例配置运行于不同的端口08
配置文件如/f
= your_password
= /tmp/mysql.sock
default-character-set = utf8
# Here follows entries for some specific programs
[mysqld_multi]
= /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
log = /var/log/mysql/mysqld.multi.log
#如果你的mysql实例有密码这一项就要启动，并且写上密码，不然管理脚本可以启动，不能停止
socket=/tmp/mysql3306.sock
pid-file=/tmp/mysql3306.pid
max_allowed_packet=1M
net_buffer_length=2k
table_open_cache=4
sort_buffer_size=64k
thread_stack=128k
basedir=/usr/local/mysql
datadir=/data/mydata1
server-id=1
socket=/tmp/mysql3307.sock
pid-file=/tmp/mysql3307.pid
max_allowed_packet=1M
net_buffer_length=2k
table_open_cache=4
sort_buffer_size=64k
thread_stack=128k
basedir=/usr/local/mysql
datadir=/data/mydata2
server-id=1
socket=/tmp/mysql3308.sock
pid-file=/tmp/mysql3308.pid
max_allowed_packet=1M
net_buffer_length=2k
table_open_cache=4
sort_buffer_size=64k
thread_stack=128k
basedir=/usr/local/mysql
datadir=/data/mydata3
server-id=1
# The MariaDB server
多实例管理脚本
[root@e3 mariadb-10.0.15]# cp /usr/local/mysql/support-files/mysqld_multi.server /etc/init.d/mysqld.multi
[root@e3 mariadb-10.0.15]# chmod +x /etc/init.d/mysqld.multi
修改多实例脚本来同时启动，关闭3个实例
[root@e3 mariadb-10.0.15]# vim /etc/init.d/mysqld.multi 编辑修改
# A simple startup script for mysqld_multi by Tim Smith and Jani Tolonen.
# This script assumes f file exists either in /f or
# /root/.my.cnf and has groups [mysqld_multi] and [mysqldN]. See the
# mysqld_multi documentation for detailed instructions.
# This script can be used as /etc/init.d/mysql.server
# Comments to support chkconfig on RedHat
# chkconfig:
# description: A very fast and reliable SQL database engine.
# Version 1.0
basedir=/usr/local/mysql
bindir=/usr/local/mysql/bin
export PATH=$PATH:$bindir
if test -x $bindir/mysqld_multi
mysqld_multi=&$bindir/mysqld_multi&;
echo &Can't execute $bindir/mysqld_multi from dir $basedir&;
case &$1& in
'start' )
&$mysqld_multi& --defaults-extra-file=$conf start $2
's' )
&$mysqld_multi& --defaults-extra-file=$conf stop $2
'report' )
&$mysqld_multi&
--defaults-extra-file=$conf report $2
'restart' )
&$mysqld_multi& --defaults-extra-file=$conf stop $2
&$mysqld_multi& --defaults-extra-file=$conf start $2
echo &Usage: $0 {start|stop|report|restart}& &&2
[root@e3 mariadb-10.0.15]# /etc/init.d/mysqld.multi start 1,2,3
[root@e3 mariadb-10.0.15]# netstat -antlp |grep mysqld
20628/mysqld
20630/mysqld
20619/mysqld
[root@e3 mariadb-10.0.15]# /etc/init.d/mysqld.multi stop 1,2,3
[root@e3 mariadb-10.0.15]# netstat -antlp |grep mysqld
[root@e3 tmp]# mysql -S /tmp/mysql3307.sock
这样可以连接
Welcome to the MariaDB monitor.
Your MariaDB connection id is 2
Server version: 10.0.15-MariaDB Source distribution
Copyright (c) , Oracle, SkySQL Ab and others.
Type '' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]&
[root@e3 tmp]# mysql -uroot -h127.0.0.1 -P3306 -p
这样也可以连接
Enter password:
Welcome to the MariaDB monitor.
Your MariaDB connection id is 3
Server version: 10.0.15-MariaDB Source distribution
Copyright (c) , Oracle, SkySQL Ab and others.
Type '' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]&
转载请保留固定链接：
------分隔线----------------------------
评论列表（网友评论仅供网友表达个人看法，并不表明本站同意其观点或证实其描述）
高仿奢侈品?Maison Martin Margiela(梅森●马丁●马吉拉) 精仿 安娜苏（彩妆品牌） 威信 LoveMeJck
领58元现金 YY娱乐?注册送88元 中信国际 注册立送58元 澳门金丽华 彩金派发专员QQ：
redis是一款高性能的内存数据库，本文侧重描述redis在主从模式下...
复制集简介 Mongodb复制集由一组Mongod实例（进程）组成，包含一...
没有什么东西是一成不变的，包含我们的理想和生活！MySQL作为...
一、集群复制状态检查 1、SHOW GLOBAL STATUS LIKE wsrep_%;+-------------...
1. 什么是表分区？ 表分区，是指根据一定规则，将数据库中的一...
在你原来的网站服务商处利用phpmyadmin导出数据库为sql文件，这个...linux下cmake
mariaDB时报错，该怎么解决 - Linux/Unix当前位置:& &&&linux下cmake
mariaDB时报错，该怎么解决linux下cmake
mariaDB时报错，该怎么解决&&网友分享于：&&浏览：111次linux下cmake
mariaDB时报错，该如何解决cmake&-DCMAKE_INSTALL_PREFIX=/software/mariaDB/mariadb/server&-DWITH_FEDERATED_STORAGE_ENGINE=1&-DWITH_SSL=system
---------------------结果------------------如下
CMake&Error:&The&following&variables&are&used&in&this&project,&but&they&are&set&to&NOTFOUND.
Please&set&them&or&make&sure&they&are&set&and&tested&correctly&in&the&CMake&files:
OPENSSL_INCLUDE_DIR
&&&used&as&include&directory&in&directory&/software/mariaDB/mariadb-10.0.4/CMakeFiles/CMakeTmp
CMake&Error:&Internal&CMake&error,&TryCompile&configure&of&cmake&failed
--&Check&size&of&wchar_t&-&failed
--&Check&size&of&wctype_t
CMake&Error:&The&following&variables&are&used&in&this&project,&but&they&are&set&to&NOTFOUND.
Please&set&them&or&make&sure&they&are&set&and&tested&correctly&in&the&CMake&files:
OPENSSL_INCLUDE_DIR
&&&used&as&include&directory&in&directory&/software/mariaDB/mariadb-10.0.4/CMakeFiles/CMakeTmp
CMake&Error:&Internal&CMake&error,&TryCompile&configure&of&cmake&failed
--&Check&size&of&wctype_t&-&failed
--&Check&size&of&wint_t
CMake&Error:&The&following&variables&are&used&in&this&project,&but&they&are&set&to&NOTFOUND.
Please&set&them&or&make&sure&they&are&set&and&tested&correctly&in&the&CMake&files:
OPENSSL_INCLUDE_DIR
&&&used&as&include&directory&in&directory&/software/mariaDB/mariadb-10.0.4/CMakeFiles/CMakeTmp
CMake&Error:&Internal&CMake&error,&TryCompile&configure&of&cmake&failed
CMake&Error:&The&following&variables&are&used&in&this&project,&but&they&are&set&to&NOTFOUND.
Please&set&them&or&make&sure&they&are&set&and&tested&correctly&in&the&CMake&files:
OPENSSL_INCLUDE_DIR
&&&used&as&include&directory&in&directory&/software/mariaDB/mariadb-10.0.4/CMakeFiles/CMakeTmp
CMake&Error:&Internal&CMake&error,&TryCompile&configure&of&cmake&faile
------解决方案--------------------没有安装openssl的开发包，安装下openssl-devel类似的。
12345678910
12345678910
12345678910 上一篇：下一篇：文章评论相关解决方案 12345678910 Copyright & &&版权所有