Meethong
<< Back
Mariadb 10.0.38 编译安装

Mariadb 10.0.38 编译安装基于 Centos Ubuntu类似 就不贴具体操作了,基本一样 安装相关依赖包即可。

Mariadb 10.0.38 编译安装

1、下载源码包Mariadb源码包下载

2、安装基础环境

yum  groupinstall -y Development Tools
yum -y install ncurses-devel zlib-devel

3、编译

cmake \
-DCMAKE_INSTALL_PREFIX=/opt/ops/mariadb \
-DMYSQL_DATADIR=/opt/ops/mariadb/data \
-DSYSCONFDIR=/opt/ops/mariadb \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/opt/ops/mariadb/data/mysql.sock \
-DMYSQL_TCP_PORT=8105 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci

#编译并且安装
make && make install

4、生成mysql的配置文件

cp /opt/ops/mariadb/support-files/my-medium.cnf /opt/ops/mariadb/my.cnf

5、修改mysql配置文件

vim /opt/ops/mariadb/my.cnf   #在mysqld标签下加上以下内容


lower_case_table_names = 1
character-set-server=utf8
key_buffer_size = 64M
max_allowed_packet = 10M
table_open_cache = 256
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 1M
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 16M
max_connections=3000
thread_cache_size=1000
max_connect_errors=200
interactive_timeout=600
wait_timeout=3600
innodb_buffer_pool_size=1000M
read_buffer_size = 256K
query_cache_type = 1
query_cache_limit = 512K
query_cache_min_res_unit = 2k
query_cache_size=32M
tmp_table_size=64M
open_files_limit = 65535

6、初始化数据库

 /opt/ops/mariadb/scripts/mysql_install_db --user=mysql --datadir=/opt/ops/mariadb/data/

7、生成Mariadb的启动脚本

 cp  /opt/ops/mariadb/support-files/mysql.server  /opt/ops/mariadb/mysqld

8、将安装目录授权给mysql用户

 chown -R mysql:mysql /opt/ops/mariadb

9、启动 Mariadb

 /opt/ops/mariadb/mysqld start

10、设置用户密码

 /opt/ops/mariadb/bin/mysqladmin -u root password 'ops123'

11、授权在任意地方登陆

grant all on *.* to  'root'@'%' identified by 'ops123';

12、刷新授权

 flush privileges;