安装源码mysql和php

安装mysql、php7.3需要用到cmake

yum -y install libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel MySQL pcre-devel curl-devel libxslt-devel openssl-devel

安装cmake

CMake 3.4.3 or higher is required

下载地址：https://cmake.org/download/
tar -zxvf cmake-3.14.3.tar.gz

cd cmake-3.14.3

./bootstrap

gmake && make install

 

安装php7.3

//以前的版本不需要这个步骤 
安装libzip
下载地址：https://libzip.org/download/libzip-1.5.2.tar.gz
tar -zxvf libzip-1.5.2.tar.gz
cd libzip-1.5.2
mkdir build && cd build && cmake .. && make && make install
说明：新版cmake不能在源代码下面编译，只能创建个文件夹build，在build下来make

./configure --prefix=/usr/local/php7.3 \
--with-curl \
--with-freetype-dir \
--with-gd \
--with-gettext \
--with-iconv-dir \
--with-kerberos \
--with-libdir=lib64 \
--with-libxml-dir \
--with-mysqli \
--with-openssl \
--with-pcre-regex \
--with-pdo-mysql \
--with-pdo-sqlite \
--with-pear \
--with-png-dir \
--with-xmlrpc \
--with-xsl \
--with-zlib \
--enable-fpm \
--enable-bcmath \
--enable-libxml \
--enable-inline-optimization \
--enable-gd-native-ttf \
--enable-mbregex \
--enable-mbstring \
--enable-opcache \
--enable-pcntl \
--enable-shmop \
--enable-soap \
--enable-sockets \
--enable-sysvsem \
--enable-xml \
--enable-zip \
--with-apxs2=/usr/local/apache2/bin/apxs

 

make && make install
配置文件
cp php.ini-development /usr/local/php/lib/php.ini
cp /usr/local/php/etc/php-fpm.conf.default /usr/local/php/etc/php-fpm.conf
cp /usr/local/php/etc/php-fpm.d/www.conf.default /usr/local/php/etc/php-fpm.d/www.conf
cp -R ./sapi/fpm/php-fpm /etc/init.d/php-fpm

#查看php版本

/usr/local/php7.3/bin/php -v

#启动 如果是nginx服务需要启动

/usr/local/php7.3/sbin/php-fpm  // 默认端后：9000

 

安装mysql

依赖库

下载地址：http://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

tar zxvf boost_1_59_0.tar.gz
mv boost_1_59_0 /usr/local/boost

tar -zxvf mysql-5.7.4.tar.gz

cd mysql-5.7.4-m14/

cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306 \
-DENABLE_DOWNLOADS=1 \
-DWITH_BOOST=/usr/local/boost \
-DDOWNLOAD_BOOST=1 

make && make install

#添加mysql成员

useraddd mysql

chown -R mysql:mysql  /usr/local/mysql

//初始化 必须
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

vim /etc/my.cnf
修改
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

#启动mysql

/use/local/mysql/bin/mysql.server start //默认端口：3306

#查看mysql初始密码

cat /root/.mysql_secret //比如初始密码为：}b4w1IY_rakso[pN

#进入客户端

/usr/local/mysql/bin/mysql -uroot -p}b4w1IY_rakso[pN

#修改mysql登录密码

mysql> SET PASSWORD = PASSWORD('123456');