交代一下内核的信息
[root@localhost soft]# uname -r
2.6.32-71.el6.x86_64
创建mariadb用户组
[root@localhost mariadb-5.5.33a]# groupadd mariadb
[root@localhost mariadb-5.5.33a]# useradd -s /sbin/nologin -g mariadb mariadb
下载mariadb
[root@localhost soft]# wget http://mirrors.scie.in/mariadb/mariadb-5.5.33a/kvm-tarbake-jaunty-x86/mariadb-5.5.33a.tar.gz
[root@localhost soft]# ls
mariadb-5.5.33a.tar.gz
[root@localhost soft]# tar xf mariadb-5.5.33a.tar.gz -C /usr/src/
[root@localhost src]# cd mariadb-5.5.33a/
[root@localhost mariadb-5.5.33a]# ls
BUILD config.h.cmake randgen
BUILD-CMAKE configure.cmake regex
CMakeLists.txt dbug scripts
COPYING debian sql
COPYING.LESSER extra sql-bench
Docs include sql-common
INSTALL-SOURCE libmysql storage
INSTALL-WIN-SOURCE libmysqld strings
KNOWN_BUGS.txt libservices support-files
README man tests
VERSION mysql-test unittest
client mysys vio
cmake packaging win
cmd-line-utils plugin zlib
mariadb需要cmake安装，同时将需要的软件包一起安装了。
[root@localhost soft]# yum install cmake bison gcc* ncurses* -y
[root@localhost mariadb-5.5.33a]# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/maria -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_DEBUG=0 -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DMYSQL_DATADIR=/mariadb
[root@localhost mariadb-5.5.33a]# make
[root@localhost log]# chown mariadb.mariadb /mariadb -R
[root@localhost log]# chown mariadb.mariadb /var/log/maria -R
[root@localhost log]# /usr/local/maria/scripts/mysql_install_db --user=mariadb --basedir=/usr/local/maria --datadir=/mariadb
Installing MariaDB/MySQL system tables in '/mariadb' ...
OK
Filling help tables...
OK
初始化数据库成功
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
[root@localhost log]# yum install mysql 安装客户端
[root@localhost etc]# cd /usr/local/maria/etc/
[root@localhost etc]# cat my.cnf
[mysqld]
basedir=/usr/local/maria
datadir=/mariadb
socket=/mariadb/maria.sock
user=mariadb
port=3306
log_error=/var/log/maria/mariadb-error.log
pid-file=/mariadb/maria.pid
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[client]
port=3306
socket=/mariadb/maria.sock
[root@localhost etc]# mysql -S /mariadb/maria.sock
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.33a-MariaDB MariaDB Server
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql>