版本:MariaDB 10.1.11 Stable 2016-01-29
下载网址:https://downloads.mariadb.org/mariadb/10.1.11/
CentOS 6.5 环境安装
需要下载的rpm包:
MariaDB-10.1.11-centos6-x86_64-client.rpm
MariaDB-10.1.11-centos6-x86_64-common.rpm
MariaDB-10.1.11-centos6-x86_64-compat.rpm
MariaDB-10.1.11-centos6-x86_64-server.rpm
galera-25.3.12-1.rhel6.el6.x86_64.rpm
jemalloc-3.6.0-1.el6.x86_64.rpm
查看已安装的mysql包
rpm -qa | grep mysql
如果有,删除之前已安装的mysql包
rpm -e mysql-libs-5.1.71-1.el6.x86_64 --nodeps
安装common和compat包
rpm -ivh MariaDB-10.1.11-centos6-x86_64-common.rpm MariaDB-10.1.11-centos6-x86_64-compat.rpm
安装client包
rpm -ivh MariaDB-10.1.11-centos6-x86_64-client.rpm
安装galera包
rpm -ivh galera-25.3.12-1.rhel6.el6.x86_64.rpm
安装jemalloc包
rpm -ivh jemalloc-3.6.0-1.el6.x86_64.rpm
yum安装perl-DBI包
yum install perl-DBI
安装server包
rpm -ivh MariaDB-10.1.11-centos6-x86_64-server.rpm
启动mysql服务
service mysql start
设置root用户密码
/usr/bin/mysqladmin -u root password 'new-password'
设置utf8mb4编码,以支持emoji表情。
1.修改mysql配置文件
vi /etc/my.cnf.d/server.cnf
[mysqld]
character-set-server=utf8mb4
vi /etc/my.cnf.d/mysql-clients.cnf
[mysql]
default-character-set=utf8mb4
2.将已经建好的表也转换成utf8mb4
alter table TABLE_NAME convert to character set utf8mb4 collate utf8mb4_bin;
设置最大连接数
vi /etc/my.cnf.d/server.cnf
[mysqld]
max_connections=1000
设置root远程登录(%为任意ip都可以登录,如只能指定ip登录,将%替换成ip即可)
MySQL [(none)]> use mysql;
MySQL [mysql]> grant all privileges on *.* to 'root'@'%' identified by 'password';
MySQL [mysql]> flush privileges;