linux（centos7）源码安装系列-mysql

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.36.tar.gz

useradd -M -s /sbin/nologin mysql

mkdir -p /usr/local/mysql/data 
mkdir -p /usr/local/mysql/log
chown -R mysql:mysql /usr/local/mysql

tar -zxvf mysql-boost-5.7.36.tar.gz

yum install cmake gcc gcc-c++ 
yum install ncurses-devel openssl-devel

cd mysql-5.7.36
mkdir bld
cd bld
cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_USER=mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DDOWNLOAD_BOOST=1 -DWITH_BOOST=boost -DWITH_SSL=system

make -j 1

make install

vim /etc/my.cnf
datadir=/usr/local/mysql/data
log_error=/usr/local/mysql/log
socket=/tmp/mysql.sock
explicit_defaults_for_timestamp=1
#跳过验证，修改密码用
skip-grant-tables
read-only=0

vim /root/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin

source /root/.bash_profile

mysqld --initialize --user=mysql

cp support-files/mysql.server /etc/init.d/mysqld
vim /etc/init.d/mysqld
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

service mysqld restart
或者systemctl restart mysqld

ps aux | grep mysql*

mysql
set global read_only = 0;
执行 flush privileges; 立即生效

use mysql;
alter user 'root'@'localhost' identified by 'your_password';

#查看端口号
ss -ant

#查看进程号
ps aux | grep mysql*