LAMP架构---(Linux、Apache、mysql、php)

一.mysql源码安装

下载mysql源码数据包并解压
[root@server1 ~]# tar zxf mysql-boost-5.7.31.tar.gz 
[root@server1 ~]# ls
[root@server1 ~]# cd mysql-5.7.31/
[root@server1 mysql-5.7.31]# ls
[root@server1 mysql-5.7.31]# less INSTALL     ##查看文档
[root@server1 mysql-5.7.31]# yum install -y cmake

 

[root@server1 mysql-5.7.31]# cd Docs/
[root@server1 Docs]# ls
ChangeLog  INFO_SRC  myisam.txt  sp-imp-spec.txt
[root@server1 Docs]# cd ..
[root@server1 mysql-5.7.31]# cd BUILD/
[root@server1 BUILD]# ls
[root@server1 BUILD]# cd -
/root/mysql-5.7.31
[root@server1 mysql-5.7.31]# yum install -y gcc-c++  ##下载c++

[root@server1 mysql-5.7.31]# ls boost/boost_1_59_0/^C
[root@server1 mysql-5.7.31]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_unicode_ci -DWITH_BOOST=boost/boost_1_59_0
[root@server1 mysql-5.7.31]# yum install -y ncurses-devel
[root@server1 mysql-5.7.31]# rm -f CMakeCache.txt
[root@server1 mysql-5.7.31]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_EXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_unicode_ci -DWITH_BOOST=boost/boost_1_59_0
[root@server1 mysql-5.7.31]# yum install -y bison
[root@server1 mysql-5.7.31]# make
[root@server1 mysql-5.7.31]# 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
[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 10566 Dec 10 12:53 /etc/init.d/mysqld
[root@server1 support-files]# useradd -M -d /data/mysql -s /sbin/nologin mysql ##添加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