自定义安装 mysql

一、下载并安装cmake

cd /server/package
wget https://cmake.org/files/v3.10/cmake-3.10.0-rc5.tar.gz
tar –zxvf cmake-3.10.0-rc5.tar.gz

二、以上命令完成下载和解压操作，接下来进行安装操作

cd cmake-3.10.0-rc5
./configure --prefix=/server/cmake
make
make install

三、下载并安装ncurses

cd /server/package
wget http://ftp.gnu.org/gnu/ncurses/ncurses-6.0.tar.gz
tar -zxvf  ncurses-6.0.tar.gz
cd ncurses-6.0.tar.gz
./configure --prefix=/server/ncurses
make && make install

四、安装libaio库

yum install libaio*

五、为MySQL添加用户及组

groupadd mysql
useradd -r -g mysql mysql

六、下载并安装MySQL

cd /server/package
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
tar –zxvf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.20-linux-glibc2.12-x86_64 /server/mysql/
chown -R mysql.mysql  /server/mysql/

七、设置mysql配置文件

[client]
port = 3306
socket = /server/mysql/tmp/mysql.sock

[mysqld]
basedir = /server/mysql
datadir=/server/mysql/data
socket=/server/mysql/tmp/mysql.sock

log-error = /logs/mysql/error.log
pid-file=/logs/mysql/mysql.pid

#skip-grant-tables

#Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#Settings user and group are ignored when systemd is used.
#If you need to run mysqld under a different user or group,
#customize your systemd unit file for mariadb according to the
#instructions in http://fedoraproject.org/wiki/Systemd

explicit_defaults_for_timestamp = true

[mysqld_safe]
log-error=/logs/mariadb/error.log
pid-file=//logs/mysql/mariadb.pid

#
#include all files from the config directory
#
!includedir /etc/my.cnf.d

八、将mysqld的启动脚本放入/etc/init.d/路径中

cp -a /server/mysql/support-files/mysql.server  /etc/init.d/mysql

九、修改/etc/init.d/mysqld中的basedir和datadir，确保其值与my.cnf文件中的内容相同

vim命令，修改/etc/init.d/mysqld
basedir=/server/mysql
datadir=/server/mysql/data

十、创建mysql log的文件夹

mkdir /logs/mysql
chown -R mysql.mysql /logs/mysql

十一、初始化MySQL

/server/mysql/bin/mysqld --initialize --user=mysql --basedir=/server/mysql/ --datadir=/server/mysql/data/
如果提示permission错误，直接给对应的文件夹或者文件赋权即可
如：chown -R mysql.mysql /logs/mysql
如若提示文件不存在的，就创建对应的文件并赋权

十二、使用安全模式启动MySQL

/server/mysql/bin/mysqld_safe  --user=mysql
/server/mysql/bin/mysql -uroot -p

/logs/mysql/error.log里会有mysql初始密码
重置mysql密码
执行
alter user user() identified by 'root@1234';

十三、设置mysql开机启动

cd /server/mysql/bin/
-bash-4.2# chkconfig --level 35 mysqld on
十四、正式启动mysql
ps aux|grep mysql
kill掉safe模式的mysql
执行
/etc/init.d/mysqld start