Centos7源码安装Mysql

systemctl disable firewalld
vim /etc/sysconfig/selinux   修改为disabled
rpm -qa | grep  mariadb
rpm -e --nodeps mariadb-libs

yum install gcc ncurses ncurses-devel libaio bison gcc-c++ git cmake openssl-devel make wget lrzsz -y

reboot

mysql-5.7.38    boost_1_59_0 

tar xf mysql-5.7.38.tar.gz 
tar xf boost_1_59_0.tar.gz

mv boost_1_59_0 /opt/boost

useradd -M -s /sbin/nolgin mysql

mkdir -p /var/run/mysql
mkdir /usr/local/mysql
mkdir /var/log/mysql

chown mysql:mysql /var/run/mysql -R
chown mysql:mysql /usr/local/mysql
chown mysql:mysql /var/log/mysql

编译安装
cmake  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql
-DSYSCONFDIR=/etc
-DMYSQL_DATADIR=/usr/local/mysql/data
-DINSTALL_MANDIR=/usr/share/man
-DMYSQL_TCP_PORT=3306
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock
-DDEFAULT_CHARSET=utf8
-DEXTRA_CHARSETS=all
-DDEFAULT_COLLATION=utf8_general_ci
-DWITH_READLINE=1
-DWITH_SSL=system
-DWITH_EMBEDDED_SERVER=1
-DENABLED_LOCAL_INFILE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_BOOST=/opt/boost/

make -j3
make instal

[mysqld]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
# 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

[mysqld_safe]
log-error=/var/log/mysql/mysql.log
pid-file=/var/run/mysql/mysql.pid

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

cd /usr/local/mysql

bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

记得保存密码 WDT6smCdhj_?

bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data

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

chkconfig mysqld on 加入开机启动

ln -s /usr/local/mysql/bin/mysql /usr/bin/  软连接方便启动

systemctl status mysqld
systemctl start mysqld

bin/mysql -uroot -p    登录

WDT6smCdhj_?      密码

 set password = password('123123');    修改密码

grant all privileges on 某个库*.*权限 to db用户@'登录的网段192.168.1.0' identified by '密码'
flush privileges;刷新权限