linux yum 搭建 apache+php+mysql 环境

1. 安装apache

安装apache
yum -y install httpd

安装apache扩展
yum -y install httpd-manual mod_ssl mod_perl mod_auth_mysql

apache 常用指令

1. 启动apache
   service httpd start
2. 停止apache
   service httpd stop
3. 重启apache
   service httpd restart

2. 安装php

安装php
yum -y install php php-mysql

安装php扩展
yum -y install php-gd php-xml php-mbstring php-ldap php-pear php-xmlrpc

注意： 安装指定版本php请按照如下步骤
不同的系统安装不同的PHP需要先更新包，下面三个地址根据情况去选择
CentOS/RHEL 7.x:
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm

CentOS/RHEL 6.x:
rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm

1. 卸载php
   yum remove php
   yum remove php-*

2. 安装php7
   yum install php70w php70w-opcache php70w-mysql php70w-mcrypt php70w-mbstring

3. 安装其他插件（选装）
   php70w
   php70w-bcmath
   php70w-cli
   php70w-common
   php70w-dba
   php70w-devel
   php70w-embedded
   php70w-enchant
   php70w-fpm
   php70w-gd
   php70w-imap
   php70w-interbase
   php70w-intl
   php70w-ldap
   php70w-mbstring
   php70w-mcrypt
   php70w-mysql
   php70w-mysqlnd
   php70w-odbc
   php70w-opcache
   php70w-pdo
   php70w-pdo_dblib
   php70w-pear
   php70w-pecl-apcu
   php70w-pecl-imagick
   php70w-pecl-xdebug
   php70w-pgsql
   php70w-phpdbg
   php70w-process
   php70w-pspell
   php70w-recode
   php70w-snmp
   php70w-soap
   php70w-tidy
   php70w-xml
   php70w-xmlrpc

3. 安装mysql

安装mysql
yum -y install mysql mysql-server

安装mysql扩展
yum -y install mysql-connector-odbc mysql-devel libdbi-dbd-mysql

注意： 如果想要安装指定版本mysql请按照如下步骤

1. 卸载以前安装的mysql
   yum remove mysql
2. 查看mysql可用版本
   yum repolist enabled | grep “mysql.-community.”
3. 安装指定版本mysql
   yum仓库下载MySQL
   sudo yum localinstall https://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm
   https://repo.mysql.com/ (这个域名下面有很多mysql版本可以选择)
4. yum安装MySQL：
   sudo yum install mysql-community-server

mysql 常用指令

1. 检查mysql 服务状态
   sudo service mysqld status
2. 启动mysql
   service mysqld start
3. 重启mysql
   service mysqld restart
4. 停机mysql服务
   service mysqld stop

报错解决方案：
 -  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
启动mysql ： service mysqld start

 - ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
登录mysql需要密码： mysql -uroot -proot

查看mysql初始密码步骤：
 - 1. more  /etc/my.cnf (查看log-error=/var/log/mysqld.log 的配置路径)
 - 2. more /var/log/mysqld.log |grep 'temporary password'
 - 2019-07-20T10:00:51.966304Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 3Dl#nl,/wa.y
 - 3Dl#nl,/wa.y   就是初始密码（特别注意：如果查看密码为空，需要先启动mysql才会生成哟）

 命令行连接mysql：  mysql -uroot -p3Dl#nl,/wa.y

5. 重置mysql密码

• use mysql
  update user set password = password(“root”) where user =
  “root”;
  flush privileges;

• alter user ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password
  by ‘你的mysql密码’;

报错解决方案：

 - ERROR 1820 (HY000): You must reset your password using ALTER USER
   statement before executing this statement.
 - ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

设置策略：set global validate_password.policy=0;
然后使用：alter user 'root'@'localhost' IDENTIFIED WITH mysql_native_password by '你的mysql密码';  修改密码

配置apache

1. cd /etc/httpd/conf.d
2. 新建一个文件 vi test.conf

    <VirtualHost *:80>
        AddDefaultCharset UTF-8
        ServerAdmin wangchun159753@gmail.com
        DocumentRoot "/home/www/test"
        ServerName www.huaban1314.com
        php_admin_value open_basedir .:/home/www/:/home/data:/home/logs:/home/www/test/logs/*:/var/tmp:/tmp:
        
        ErrorLog logs/test_error_log
        TransferLog logs/test_access_log
    
        CustomLog logs/test \
              "%t %h %{SSL_PROTOCOL}x %{SSL_CIPHER}x \"%r\" %b"
    
        <Directory "/home/www/test">
            AllowOverride None
            Options None
            Order allow,deny
            Allow from all
        </Directory>
    
    </VirtualHost>

3. 重启apache
   service httpd restart