3、编译安装mysql
#yum -y install gcc gcc-devel gcc-c++ gcc-c++-devel autoconf* automake* zlib* libxml*ncurses-devel ncurses libgcrypt* libtool* cmake openssl openssl-devel bisonbison-devel perl-Data-Dumper boost boost-doc boost-devel
//**删除Mariadb的遗留配置文件**
#rm -rf /etc/my.cnf
#groupadd mysql
#useradd -g mysql -s /sbin/nologin mysql
或者 # useradd -M -s /bin/false -r -g mysql mysql
#mkdir -pv /usr/local/mysql57
#mkdir -pv /usr/local/mysql57/conf
#mkdir -pv /usr/local/mysql57/tmp
#mkdir -pv /usr/local/mysql57/data
#chown -R mysql:mysql /usr/local/mysql57
Cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql57
-DMYSQL_DATADIR=/usr/local/mysql57/data
-DSYSCONFDIR=/usr/local/mysql57/conf
-DMYSQL_UNIX_ADDR=/usr/local/mysql57/tmp/mysql.sock
-DSYSTEMD_PID_DIR=/usr/local/mysql57/
-DMYSQL_USER=mysql
-DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_ARCHIVE_STORAGE_ENGINE=1
-DWITH_MEMORY_STORAGE_ENGINE=1
-DWITH_READLINE=1
-DMYSQL_TCP_PORT=3306
-DENABLED_LOCAL_INFILE=1
-DENABLE_DOWNLOADS=1
-DWITH_PARTITION_STORAGE_ENGINE=1
-DEXTRA_CHARSETS=all
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DWITH_DEBUG=0
-DMYSQL_MAINTAINER_MODE=0
-DWITH_SSL:STRING=bundled
-DWITH_ZLIB:STRING=bundled
-DDOWNLOAD_BOOST=1
-DWITH_BOOST=./boost
# make -j\$(cat /proc/cpuinfo| grep "processor"| wc -l) && make install
[mysqld]
basedir=/usr/local/mysql57
datadir=/usr/local/mysql57/data
port=3306
socket=/usr/local/mysql57/tmp/mysql.sock
character-set-server=utf8
log-error=/usr/local/mysql57/log/mysqld.log
pid-file=/usr/local/mysql57/tmp/mysqld.pid
explicit_defaults_for_timestamp=true
[mysql]
socket=/usr/local/mysql57/tmp/mysql.sock
[client]
socket=/usr/local/mysql57/tmp/mysql.sock
//**添加httpd到环境变量内**
#echo 'export PATH=\$PATH:/usr/local/mysql57/bin' > /etc/profile.d/mysqld.sh
//**设置为可执行文件**
#chmod +x /etc/profile.d/mysqld.sh
//**生效mysqld服务**
#source /etc/profile.d/mysqld.sh
//**复制启动文件到系统启动项**
#cp /usr/local/mysql57/support-files/mysql.server /etc/init.d/mysqld
#chmod +x /etc/init.d/mysqld
//**添加到chkconfig中**
#chkconfig --add mysqld
//**查看chkconfig是否有该服务**
#chkconfig --list
#chkconfig mysqld on
//**修改安装目录所属主和所属组**
#chown -R mysql:mysql /usr/local/mysql57
/log/mysqld.pid
/tmp/mysqld.pid
/tmp/mysql.sock
/tmp/mysql.sock.lock
ps -ef|**grep mysqld**
//**初始化mysqld && 获得mysql初始密码:ZMjL!4Cfflfr**
#/usr/local/mysql57/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql57 --datadir=/usr/local/mysql57/data
#service mysqld start
//**启动mysql**
# systemctl enable mysqld.service
# systemctl daemon-reload
#systemctl start mysqld.service
//**产生./mysqld.pid和./tmp/mysql.sock ./tmp/mysql.sock.lock**
#systemctl status mysqld.service
#**忘记临时密码可以使用这个设置新密码**
mysql_secure_installation
//**修改root 默认密码**
#ALTER USER 'root'@'localhost' IDENTIFIED BY '******';
或者:
#set password for 'root'@'localhost'=password('******');