Linux企业运维--LAMP架构---(Linux、Apache、mysql、php)

一.mysql源码安装

[root@server1 ~]# ls
mysql-boost-5.7.31.tar.gz  nginx-1.20.1  nginx-1.20.1.tar.gz

[root@server1 ~]# tar zxf mysql-boost-5.7.31.tar.gz
[root@server1 ~]# ls
mysql-5.7.31  mysql-boost-5.7.31.tar.gz  nginx-1.20.1  nginx-1.20.1.tar.gz
[root@server1 ~]# cd mysql-5.7.31

[root@server1 mysql-5.7.31]# cd Docs
[root@server1 Docs]# ls

[root@server1 Docs]# cd ..
[root@server1 mysql-5.7.31]# cd BUILD
[root@server1 BUILD]# ls

[root@server1 mysql-5.7.31]# yum install -y cmake

[root@server1 mysql-5.7.31]# cmake  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysq -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_unicode_ci

[root@server1 mysql-5.7.31]# yum install -y gcc-c++

[root@server1 mysql-5.7.31]# yum install -y ncurses-devel

[root@server1 mysql-5.7.31]# rm -fr CMakeCache.txt

[root@server1 mysql-5.7.31]# yum install -y bison

[root@server1 mysql-5.7.31]# make && make install

 二.mysql安装配置

 [root@server1 mysql-5.7.31]# cd /usr/local/mysql
[root@server1 mysql]# ls
[root@server1 mysql]# du -sh
1.9G    .
[root@server1 mysql]# cd support-files
[root@server1 support-files]# ls
magic  mysqld_multi.server  mysql-log-rotate  mysql.server
[root@server1 support-files]# cp mysql.server  /etc/init.d/mysqld  复制脚本内容到mysqld
[root@server1 support-files]# ll /etc/init.d/mysqld    
-rwxr-xr-x 1 root root 10565 Dec  9 23:49 /etc/init.d/mysqld
[root@server1 support-files]# useradd -M -d /data/mysql/ -s /sbin/nologin mysql
[root@server1 support-files]# id mysql
uid=1001(mysql) gid=1001(mysql) groups=1001(mysql)
[root@server1 support-files]# mkdir -p /data/mysql
[root@server1 support-files]# chown mysql.mysql /data/mysql

[root@server1 support-files]# cd ..
[root@server1 mysql]# ls
[root@server1 mysql]# pwd

 [root@server1 mysql]# echo $PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin

[root@server1 mysql]# ls

[root@server1 mysql]# cd bin

[root@server1 bin]# ls

[root@server1 bin]# pwd
/usr/local/mysql/bin

[root@server1 bin]# vim ~/.bash_profile

PATH=$PATH:$HOME/bin:/usr/local/mysql/bin

[root@server1 bin]# source ~/.bash_profile

[root@server1 bin]# cd
[root@server1 ~]# which mysql
/usr/local/mysql/bin/mysql
[root@server1 ~]# cd /usr/local
[root@server1 local]# cd mysql/
[root@server1 mysql]# ls
bin  docs  include  lib  LICENSE  man  mysql-test  README  README-test  share  support-files
[root@server1 mysql]# cd support-files/
[root@server1 support-files]# ls
magic  mysqld_multi.server  mysql-log-rotate  mysql.server
[root@server1 support-files]# cd ..

root@server1 mysql]# cd

[root@server1 ~]# cd mysql-5.7.31
[root@server1 mysql-5.7.31]# find -name my.cnf

[root@server1 mysql-5.7.31]# cat ./packaging/rpm-common/my.cnf

 [root@server1 mysql-5.7.31]# vim /etc/my.cnf

[mysqld]
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/data/mysql/mysql.sock
symbolic-links=0
log-error=/data/mysql/mysqld.log
pid-file=/data/mysql/mysqld.pid

mysql 初始化配置