MYSQL 编译安装

编译安装：
1，解压 tar
2，生成 ./configure cmake gmake
3, 编译 make
4，make install

用yum安装 命令在/usr/bin，程序在/usr/share下面，配置在/etc下面
用源码安装，都可以放在一个路径下
用二进制的挺多的

[root@db02 ~]# wget -q https://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.36.tar.gz
[root@db02 ~]# wget -O /etc/yum.repos.d/epel.repo https://mirrors.aliyun.com/repo/epel-6.repo
[root@db02 ~]# yum install -y ncurses-devel libaio-devel gcc-c++ gcc
[root@db02 ~]# yum install -y cmake
解压包：tar xf mysql-5.6.40.tar.gz
创建用户：useradd mysql -s /sbin/nologin -M
生成cmke

cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.6.40 \
-DMYSQL_DATADIR=/application/mysql-5.6.40/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.6.40/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITH_ZLIB=bundled \
-DWITH_SSL=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLE_DOWNLOADS=1 \
-DWITH_DEBUG=0

看见success就可以
make
make install

软连接：[root@localhost mysql-5.6.40]# ln -s /application/mysql-5.6.40 /application/mysql
拷配置文件：[root@localhost support-files]# cp my-default.cnf /etc/my.cnf
cp: overwrite ‘/etc/my.cnf’? y
pwd：/application/mysql-5.6.40/support-files
拷贝启动脚本：[root@localhost support-files]# cp mysql.server /etc/init.d/mysqld
对目录授权：chown -R /
编译安装不用替换路径，在编译的时候，都编译好的，可以把完事安装好的，打一个tar包，到别的上用。

创建socket目录:[root@localhost support-files]# mkdir /application/mysql-5.6.40/tmp

找不到PID，去日志里找
[root@localhost support-files]# tail -100 /application/mysql-5.6.40/data/db04.err
tail: cannot open ‘/application/mysql-5.6.40/data/db04.err’ for reading: No such file or directory
[root@localhost support-files]# tail -100 /application/mysql-5.6.40/data/localhost.localdomain.err
2020-07-06 02:04:17 75475 [Note] Plugin 'FEDERATED' is disabled.
/application/mysql-5.6.40/bin/mysqld: Table 'mysql.plugin' doesn't exist
2020-07-06 02:04:17 75475 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

是没有做初始化：[root@localhost scripts]# ./mysql_install_db --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data
环境变量：export PATH="/application/mysql/bin:$PATH"-------------vi /etc/profile.d/mysql.sh
[root@localhost scripts]# source /etc/profile
启动：[root@localhost scripts]# /etc/init.d/mysqld start
加入开机启动：即加入systemd管理
vi /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=https://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/application/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000

停mysql/启动mysql
[root@localhost scripts]# /etc/init.d/mysqld stop
[root@localhost scripts]# systemctl start mysqld
[root@localhost scripts]# systemctl enable mysqld

[root@localhost ~]# getenforce ---------selinux-----vi /etc/sysconfig/selinux---disables

如果启动不了，没有进程的话，可以用systemctl daemon-reload,加载一下