领导怕mysql以后收费,现在有几个系统开始使用mariadb了。但与msql没有什么区别。
要求5.x版本,下载的源码包,根据规范安装如下:
1)安装cmake
编译安装,需要cmake编译,所以先下载安装cmake(http://download.csdn.net/detail/u010587433/9187285)
tar xzf cmake-2.8.11.2.tar.gz
cd cmake-2.8.11.2
./configure
make && make install
2)创建组、用户及目录
groupadd mysql
useradd -g mysql -d /var/lib/mysql mysql
mkdir -p /home/mariadb/product/5.5/mariadb-1
mkdir -p /home/mariadb/data
mkdir -p /home/mariadb/run
3)编译安装mariadb
下载:http://download.csdn.net/detail/u010587433/9187299
<pre name="code" class="sql">tar zxvf mariadb-5.5.45.tar.gz
cd mariadb-5.5.45
cmake \
-DCMAKE_INSTALL_PREFIX=/home/mariadb/product/5.5/mariadb-1 \
-DMYSQL_DATADIR=/home/mariadb/data \
-DMYSQL_UNIX_ADDR=/home/mariadb/run/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DMYSQL_TCP_PORT=3306 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_ARIA_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATEDX_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DWITH_SPHINX_STORAGE_ENGINE=1 \
-DWITH_XTRADB_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS=all \
-DEXTRA_CHARSETS=all \
-DWITH_BIG_TABLES=1 \
-DSYSCONFDIR=/etc \
-DMYSQL_USER=mysql \
-DWITH_DEBUG=0
make && make install
4)授权
chown -R mysql:mysql /home/mariadb/data/
chown -R mysql:mysql /home/mariadb/run/
chown -R root:mysql /home/mariadb/product/
5)初始化
cd /home/mariadb/product/5.5/mariadb-1/scripts
./mysql_install_db --basedir=/home/mariadb/product/5.5/mariadb-1 --datadir=/home/mariadb/data --user=mysql
6)配置my.cnf
<pre name="code" class="sql"><pre name="code" class="sql">[mysqld]
basedir=/home/mariadb/product/5.5/mariadb-1
datadir=/home/mariadb/data
socket=/home/mariadb/run/mysql.sock
pid-file=/home/mariadb/run/mysqld.pid
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
server-id = 1
log-bin=mysql-bin
log-bin-index=binlogs.index
binlog_format = mixed
skip-host-cache
skip-name-resolve
character-set-server=utf8
max_connections=1000
lower_case_table_names=1
[client]
default-character-set=utf8
[mysqld_safe]
log-error=/var/log/mysqld.log
7)配置环境变量
/root/.bash_profile中添加
#MySQL Env
export MYSQL_BASE=/home/mariadb
export MYSQL_HOME=$MYSQL_BASE/product/5.5/mariadb-1
export DATADIR=$MYSQL_BASE/data
export LD_LIBRARY_PATH=$MYSQL_HOME/lib:/lib:/usr/lib:/usr/local/lib
export TMPDIR=/tmp
export PATH=$MYSQL_HOME/bin:$PATH
/root/.bashrc中添加
alias mysql='mysql --socket=/home/mariadb/run/mysql.sock'
8)配置系统服务
cp /home/mariadb/product/5.5/mariadb-1/support-files/mysql.server /etc/init.d/mariadbd
service mariadb start
chkconfig --add mariadbd
9)连接mysql
</pre><pre name="code" class="sql"><pre name="code" class="sql">mysql -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 21
Server version: 5.5.45-MariaDB Source distribution
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
说明:设置root密码之前连接,需要加-p,让输入密码时直接回车即可。
10)设置密码
MariaDB [(none)]> grant all privileges on *.* to root@localhost identified by '123456';