CentOS7.2通用二进制格式安装mariadb-5.5.46-linux-x86_64.tar.gz文档与启动时失败排查分析

CentOS7.2通用二进制格式安装mariadb-5.5.46-linux-x86_64.tar.gz@H_502_5@

提前准备好mariadb-5.5.46-linux-x86_64.tar.gz@H_502_5@

[root@localhost ~]# groupadd -r -g 306 MysqL###添加 MysqL 用户@H_502_5@

[root@localhost ~]# useradd -r -g 306 -u 306 MysqL ###添加 MysqL组@H_502_5@

[root@localhost dylan]# tar xf mariadb-5.5.46-linux-x86_64.tar.gz -C /usr/local/@H_502_5@

[root@localhost dylan]# cd /usr/local/@H_502_5@

[root@localhost local]# ln -sv mariadb-5.5.46-linux-x86_64/ MysqL###创建MysqL 链接@H_502_5@

[root@localhost local]# cd MysqL@H_502_5@

[root@localhost MysqL]# chown -R root.MysqL ./*###更改属组属组@H_502_5@

[root@localhost MysqL]# mkdir -pv /mydata/data###创建数据目录@H_502_5@

mkdir: 已创建目录 "/mydata"@H_502_5@

mkdir: 已创建目录 "/mydata/data"@H_502_5@

[root@localhost MysqL]# chown -R MysqL.MysqL /mydata/data/###更改数据目录权限@H_502_5@

[root@localhost MysqL]# mkdir /etc/MysqL@H_502_5@

###将选择的配置文件复制至/etc/MysqL/中，并重命名为my.cnf@H_502_5@

[root@localhost MysqL]# cp support-files/my-large.cnf /etc/MysqL/my.cnf@H_502_5@

[root@localhost MysqL]# vim /etc/MysqL/my.cnf###编辑添加@H_502_5@

thread_concurrency = 8@H_502_5@

datadir = /mydata/data ###设定数据文件目录@H_502_5@

innodb_file_per_table = ON@H_502_5@

skip_name_resolve = ON###跳过主机名解析@H_502_5@

###复制MysqLd的服务管理文件至/etc/rc.d/init.d并命名为MysqLd@H_502_5@

[root@localhost MysqL]# cp support-files/MysqL.server /etc/rc.d/init.d/MysqLd@H_502_5@

[root@localhost MysqL]# ls -l /etc/rc.d/init.d/MysqLd@H_502_5@

-rwxr-xr-x. 1 root root 12196 6月 20 22:28 /etc/rc.d/init.d/MysqLd@H_502_5@

[root@localhost MysqL]# chkconfig --add MysqLd###添加服务@H_502_5@

###程序初始化，指定用户为MysqL,数据目录为/mydata/data@H_502_5@

[root@localhost MysqL]# scripts/MysqL_install_db --user=MysqL --datadir=/mydata/data@H_502_5@

[root@localhost MysqL]# service MysqLd start@H_502_5@

Starting MysqL. ERROR! ###启动错误@H_502_5@

###编辑selinux，关闭selinux@H_502_5@

[root@localhost MysqL]# vim /etc/selinux/config@H_502_5@

SELINUX=disabled@H_502_5@

[root@localhost MysqL]# getenforce@H_502_5@

Enforcing@H_502_5@

[root@localhost MysqL]# setenforce 0@H_502_5@

[root@localhost MysqL]# getenforce@H_502_5@

Permissive@H_502_5@

###此时启动依然出错，MysqL读取配置文件不仅仅有一个，MysqL进程会以此去找很多个位置，并使用最后的作为最终的配置。@H_502_5@

[root@localhost /]# /usr/local/MysqL/bin/MysqL --help --verbose###查看读取次序@H_502_5@

/usr/local/MysqL/bin/MysqL Ver 15.1 Distrib 5.5.46-MariaDB,for Linux (x86_64) using read@H_502_5@

Usage: /usr/local/MysqL/bin/MysqL [OPTIONS] [database]@H_502_5@

Default options are read from the following files in the given order:@H_502_5@

/etc/my.cnf /etc/MysqL/my.cnf ~/.my.cnf###读取顺序@H_502_5@

###于是查看/etc/my.cnf文件，在log-error=/var/log/mariadb/mariadb.log中，于是查看/var/log/中不存在mariadb目录，需手动创建，或者将此注销掉，否则启动服务会失败。@H_502_5@

[root@localhost rc.d]# vim /etc/my.cnf@H_502_5@

[MysqLd_safe]@H_502_5@

log-error=/var/log/mariadb/mariadb.log ###错误日志路径@H_502_5@

pid-file=/var/run/mariadb/mariadb.pid@H_502_5@

###查看/var/log/下并没有mariadb目录，于是有三种方法解决：@H_502_5@

1.mv /etc/my.cnf /etc/my.cnf.bak ###使/etc/my.cnf失效@H_502_5@

2.vim /etc/my.cnf @H_502_5@

#log-error=/var/log/mariadb/mariadb.log ###注销掉@H_502_5@

3.mkdir /var/log/mariadb ###创建mariadb目录@H_502_5@

[root@localhost MysqL]# mkdir /var/log/mariadb ###此处使用第三种方法@H_502_5@

[root@localhost MysqL]# service MysqLd start@H_502_5@

Starting MysqL... SUCCESS! ###成功启动@H_502_5@

###修改环境变量@H_502_5@

[root@localhost rc.d]# vim /etc/profile.d/MysqL.sh@H_502_5@

export PATH=/usr/local/MysqL/bin:$PATH@H_502_5@

[root@localhost rc.d]# source /etc/profile.d/MysqL.sh ###重读此配置文件@H_502_5@

###导出头文件@H_502_5@

[root@localhost rc.d]# ln -sv /usr/local/MysqL/include/ /usr/include/MysqLd@H_502_5@

"/usr/include/MysqLd" -> "/usr/local/MysqL/include/"@H_502_5@

###导出库文件@H_502_5@

[root@localhost ld.so.conf.d]# vim /etc/ld.so.conf.d/MysqL.conf@H_502_5@

/usr/local/MysqL/lib@H_502_5@

[root@localhost ld.so.conf.d]# ldconfig ###系统重载入系统库@H_502_5@

[root@localhost ld.so.conf.d]# ldconfig -p |grep MysqL ###查看库文件读取@H_502_5@

libMysqLd.so.18 (libc6,x86-64) => /usr/local/MysqL/lib/libMysqLd.so.18@H_502_5@

libMysqLd.so (libc6,x86-64) => /usr/local/MysqL/lib/libMysqLd.so@H_502_5@

libMysqLclient.so.18 (libc6,x86-64) => /usr/lib64/MysqL/libMysqLclient.so.18@H_502_5@

libMysqLclient.so.18 (libc6,x86-64) => /usr/local/MysqL/lib/libMysqLclient.so.18@H_502_5@

libMysqLclient.so (libc6,x86-64) => /usr/local/MysqL/lib/libMysqLclient.so @H_502_5@

###MysqL安全加固@H_502_5@

[root@localhost bin]# MysqL_secure_installation ###运行此命令进行设置@H_502_5@

CentOS7.2通用二进制格式安装mariadb-5.5.46-linux-x86_64.tar.gz文档与启动时失败排查分析

猜你在找的CentOS相关文章