LNMP
MySQL安装（二进制方式）
创建用户
useradd -s /sbin/nologin -M mysql创建目录及下载软件包
cd /server/tools/
wget http://mirrors.163.com/mysql/Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz解压及移动
tar -xf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
mkdir /application
mv mysql-5.7.26-linux-glibc2.12-x86_64 /application/mysql-5.7.26
ln -s /application/mysql-5.7.26/ /application/mysql配置配置文件
rpm -qa mariadb-libs
ls -l /etc/my.cnf
rpm -e --nodeps mariadb-libs
# 卸载mariadb-libs，不卸载依赖，卸载完后 /etc/my.cnf 将不存在cat > /etc/my.cnf <<EOF
[mysqld]
basedir = /application/mysql/
datadir = /application/mysql/data
socket = /tmp/mysql.sock
server_id = 1
port = 3306
log_error = /application/mysql/log/mysqld.log
[mysql]
socket = /tmp/mysql.sock
prompt = will [\\d]>
EOF初始化数据库
yum install libaio-devel -ymkdir -p /application/mysql/data
mkdir -p /application/mysql/log
chown -R mysql.mysql /application/mysql/
# 注意：经常在生产环境中会将数据目录和软件目录分离，故需要将软件和数据目录都进行修改用户/application/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/application/mysql/ --datadir=/application/mysql/data配置启动服务
cat > /etc/systemd/system/mysqld.service << EOF
[Unit]
Description=MySQL Server by Will
Documentation=man:mysqld(8)
Documentation=http://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
EOF启动
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld
# CentOS6 启动方式如下：
cd /application/mysql/support-files/
./mysql.server start
# start stop restart status 都可执行
# sys-v 方式启动
cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld
service mysqld start配置环境变量登录
echo 'export PATH=/application/mysql/bin:$PATH' >> /etc/profile
. /etc/profile
echo $PATHmysql
> quit有问题可看错误日志
cat /application/mysql/log/mysqld.log
# 此日志在配置文件中设置 /etc/my.cnf修改密码
mysqladmin -u root password '123456'登录
mysql -u root -p
# 交互式
mysql -uroot -p123456
# 非交互式MySQL YUM安装
安装清华MySQL yum源
cat > /etc/yum.repos.d/mysql57-community-el7-tsinghua.repo << EOF
[mysql57-community]
name=MySQL 5.7 Community Server Tsinghua
#baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/\$basearch/
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql57-community-el7/
enabled=1
gpgcheck=1
gpgkey=http://repo.mysql.com/RPM-GPG-KEY-mysql
EOF
yum install mysql-community-server -y# 安装后临时默认密码查看方式：
# grep "temporary password" /var/log/mysqld.log
# 可使用 mysql_secure_installation 进行安全初始化yum方式安装的MySQL配置文件如下
cat /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pidls -l /etc/systemd/system/multi-user.target.wants/mysqld.service
# lrwxrwxrwx 1 root root 38 Feb 9 12:50 /etc/systemd/system/multi-user.target.wants/mysqld.service -> /usr/lib/systemd/system/mysqld.service
ls -l | grep mysql
# -rw-r--r-- 1 root root 2033 Dec 18 21:25 mysqld.service
# -rw-r--r-- 1 root root 2064 Dec 18 21:25 [email protected]cat /etc/systemd/system/multi-user.target.wants/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://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
Type=forking
PIDFile=/var/run/mysqld/mysqld.pid
# Disable service start and stop timeout logic of systemd for mysqld service.
TimeoutSec=0
# Execute pre and post scripts as root
PermissionsStartOnly=true
# Needed to create system tables
ExecStartPre=/usr/bin/mysqld_pre_systemd
# Start main service
ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS
# Use this to switch malloc implementation
EnvironmentFile=-/etc/sysconfig/mysql
# Sets open_files_limit
LimitNOFILE = 5000
Restart=on-failure
RestartPreventExitStatus=1
PrivateTmp=falsePHP编译安装
创建用户
useradd -s /sbin/nologin -M www
# 此用户在安装nginx时已经创建，若没有则在此处创建，用于启动php-fpm安装PHP调用的库
yum install zlib-devel libxml2-devel libjpeg-devel libjpeg-turbo-devel libiconv-devel -y
yum install freetype-devel libpng-devel gd-devel libcurl-devel libxslt-devel libxslt-devel -y
yum install libmcrypt-devel mhash mcrypt -y # 编译安装 libiconv
cd /server/tools/
wget http://ftp.gnu.org/gnu/libiconv/libiconv-1.16.tar.gz
tar -xf libiconv-1.16.tar.gz
cd libiconv-1.16
./configure --prefix=/application/libiconv
make && make install下载及编译PHP
cd /server/tools/
wget http://mirrors.sohu.com/php/php-7.3.5.tar.gz
tar xf php-7.3.5.tar.gz
cd php-7.3.5/
./configure \
--prefix=/application/php-7.3.5 \
--enable-mysqlnd \
--with-mysqli=mysqlnd \
--with-pdo-mysql=mysqlnd \
--with-iconv-dir=/application/libiconv \
--with-freetype-dir \
--with-jpeg-dir \
--with-png-dir \
--with-zlib \
--with-libxml-dir=/usr \
--enable-xml \
--disable-rpath \
--enable-bcmath \
--enable-shmop \
--enable-sysvsem \
--enable-inline-optimization \
--with-curl \
--enable-mbregex \
--enable-fpm \
--enable-mbstring \
--with-gd \
--with-openssl \
--with-mhash \
--enable-pcntl \
--enable-sockets \
--with-xmlrpc \
--enable-soap \
--enable-short-tags \
--enable-static \
--with-xsl \
--with-fpm-user=www \
--with-fpm-group=www \
--enable-ftp \
--enable-opcache=no
# 需注意此处使用的用户，需要跟nginx一样，如果nginx是yum安装则用nginx
# 如果是编译安装时手动指定的则需与之一致
echo $?
make && make install
echo $?ln -s /application/php-7.3.5/ /application/php
ls -l /application/php配置php.ini (php解析器配置文件)
cd /server/tools/php-7.3.5/
cp php.ini-development /application/php/lib/php.ini配置php fpm
cd /application/php/etc/
cp php-fpm.conf.default php-fpm.conf
cd php-fpm.d/
cp www.conf.default www.conf启动php
/application/php/sbin/php-fpm
netstat -ntlp | grep php-fpm写入开机自启动
vim /etc/rc.d/rc.local
/application/nginx/sbin/nginx
/application/php/sbin/php-fpm
chmod u+x /etc/rc.d/rc.local配置nginx转发php请求
server {
listen 80;
server_name blog.will.com;
root /usr/share/nginx/html/blog;
location / {
index index.php index.html index.htm;
}
location ~ \.php$ {
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
}
}
# location中root相同可提取出来放到外面mkdir -p /usr/share/nginx/html/blog
cd /usr/share/nginx/html/blog
echo "hello php index" > index.php
echo "<?php phpinfo(); ?>" > info.php访问测试php
使用浏览器访问：
blog.will.com
blog.will.com/info.php测试php连接MySQL
vim /usr/share/nginx/html/blog/test_mysql.php
<?php
//$link_id=mysqli_connect('主机名','用户','密码');
$link_id=mysqli_connect('localhost','root','123456') or mysql_error();
if($link_id){
echo "mysql successful by Will.\n";
}else{
echo mysql_error();
}
?># 使用浏览器访问
http://blog.will.com/test_mysql.phpLast updated