免编译安装mariadb

1.下载mysql

wget https://downloads.mariadb.com/MariaDB/mariadb-10.2.6/bintar-linux-glibc_214-x86_64/mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz

2.解压

tar -zxvf https://downloads.mariadb.com/MariaDB/mariadb-10.2.6/bintar-linux-glibc_214-x86_64/mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz

3.移动到指定目录下

mv mariadb-10.2.6-linux-glibc_214-x86_64 /usr/local/mariadb

4.创建mysql用户，不允许登录，不创建家目录

useradd -s /sbin/nologin -M mysql

5.创建数据库目录，并改为mysql属主

mkdir /data/mysql -pv
chown -R mysql：mysql /data/mysql

6.初始化mysql

cd /usr/local/mariadb

./scripts/mysql_install_db \

>--user=mysql \ #指定用户mysql

>--datadir=/data/mysql; #指定数据库目录

echo $? 验证，0为正确

7.mysql配置文件

cp /usr/local/mariadb/support-files/my-large.cnf /etc/my.cnf

vim /etc/my.cnf

[mysqld]

port = 3306 #监听端口

socket = /tmp/mysql.sock #socket


log-bin=mysql-bin #修改mysql数据库时，记录日志

8.mysql启动脚本

cp /usr/local/mariadb/support-files/mysql.server /etc/init.d/mysqld ##目录/etc/init.d下的保存服务的启动脚本

vim /etc/init.d/mysqld

basedir=/usr/local/mariadb 指定安装目录

datadir=/data/mysql 指定数据库目录



chkconfig --add mysqld；chkconfig mysqld on 开机启动

编译安装mysql时编译参数记录在cat /usr/local/mysql/bin/mysqlbug |grep -i configure

9.启动服务

service mysqld start