2021-05-11

安装mysql

上传压缩包mysql-5.7.34-linux-glibc2.12-x86_64.tar.gz

卸载mariadb

rpm -qa | grep mariadb

rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

切换目录：cd /opt

解压：tar zxf mysql-5.7.34-linux-glibc2.12-x86_64.tar.gz

安装依赖：yum install ncurses-devel autoconf –y

创建mysql用户组：groupadd mysql

创建用户：useradd -g mysql -s /sbin/nologin -d /usr/local/mysql -MN mysql

创建目录：mkdir /data/mysql/data -p

赋权：chown -R mysql:mysql /data/mysql

移动mysql到/usr/local/目录下：mv mysql-5.7.34-linux-glibc2.12-x86_64 /usr/local/

创建软链接：ln -s /usr/local/mysql-5.7.34-linux-glibc2.12-x86_64 /usr/local/mysql

赋权：chown -R mysql:mysql /usr/local/mysql

切换目录：cd /usr/local/mysql

编辑配置文件：vi  /etc/my.cnf

添加：

[client]

port            = 3306

socket          = /tmp/mysql.sock

 

[mysql]

no-auto-rehash

 

[mysqld]

user = mysql

basedir = /usr/local/mysql

datadir = /data/mysql/data

port = 3306

socket = /tmp/mysql.sock

log-error = error.log

slow_query_log_file = slow.log

character-set-server = utf8

open_files_limit = 65535

max_connections = 100

max_connect_errors = 100000

lower_case_table_names =1

复制：cp /etc/my.cnf /etc/my.cnf.bak

>/etc/my.cnf

初始化MYSQL：/usr/local/mysql/bin/mysqld –initialize

查看密码：grep 'temporary password' /data/mysql/data/error.log

复制启动脚本文件：cp support-files/mysql.server /etc/init.d/mysql

添加环境变量：echo "export PATH=/usr/local/mysql/bin:$PATH">>/etc/profile

 source /etc/profile

启动MYSQL：service mysql start

查看mysql的进程：ps –ef|grep mysql

登录MYSQL：mysql –uroot –p             

修改mysql密码：alter user user() identified by 'test';

退出：exit

登录MYSQL：mysql –uroot –ptest

安装Nginx

切换到yum源：Cd /etc/yum.repos.d/

查看镜像：ls

配置yum源：Vi nginx.repo

添加：

[nginx]

name=nginx     repo

baseurl=http://nginx.org/packages/centos/7/$basearch/

gpgcheck=0

enabled=1

查看：cat /etc/yum.repos.d/nginx.repo

清缓存：yum clean all

查看：yum repolist

Nginx安装：yum install nginx –y

Nginx开启：systemctl start nginx

Nginx自动开启：systemctl enable nginx

切换目录：cd /etc/nginx/conf.d/

查看：ls

修改配置文件：vi default.conf   

 在第三行后添加：server_tokens off;  

    

刷新：nginx –t

重启：nginx -s reload

wget安装：yum install –y wget

在虚拟机上查看：wget 192.168.10.10

修改配置文件：vi /etc/nginx/conf.d/default.conf

在“server_tokens off;”后添加：

if ($http_user_agent ~* LMP::Simple|BBBike|wget){

return 403;

}

刷新：nginx -t

重启：nginx -s reload

查看：ls

PhP安装

使用第三方扩展epel源安装php7.2

yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm

yum install yum-utils

yum-config-manager --enable remi-php72

yum search php72

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

清除版本：yum -y remove php*

查看：yum repolist

PHP安装：

yum -y install php72w php72w-cli php72w-fpm php72w-common php72w-devel php72w-embedded php72w-gd php72w-mbstring php72w-mysqlnd php72w-opcache php72w-pdo php72w-xml php72w-redis

使php-fpm服务自动启动：systemctl enable php-fpm.service

启动php-fpm服务：systemctl start php-fpm.service

php-fpm启动：service php-fpm start

查看php是否运行：systemctl status php-fpm

配置nginx支持PHP

切换目录：cd /etc/nginx/conf.d/

查看：cat /etc/nginx/conf.d/default.conf

           cat default.conf

修改配置文件：vi default.conf

修改：location / {

        root   /soft/code;

        index  index.php index.html index.htm;

        location ~ \.php$ {

            fastcgi_pass    127.0.0.1:9000;

            fastcgi_index   index.php;

            fastcgi_param  SCRIPT_FILENAME  /soft/code$fastcgi_script_name;

            include  fastcgi_params;

}

刷新：nginx -t

重启：nginx -s reload

新建目录：mkdir –p /soft/code

配置文件：vi /soft/code/info.php

添加：

<?php         

    phpinfo();

?>

浏览网页：http://192.168.10.10/info.php

wordpress

上传压缩包wordpress-5.7.1-zh_CN.tar.gz

切换目录：cd /soft/code

查看：ls

Rz

查看：ls

解压：tar xf wordpress-5.7.1-zh_CN.tar.gz

打开数据库：mysql –uroot –ptest

创建数据库：create database wordpress;     （红色的是库名可自行设置）

查看数据库：show databases;

赋权：grant all on wordpress.* to ‘wpuser’@’localhost’ identified by ‘password’;

刷新：flush privileges;

退出数据库：exit

查看：ls

切换目录：cd wordpress

备份：cp wp-config-sample.php wp-config.php:

修改配置文件：vi wp-config.php

改为：

Wordpress

Wpuser

Password

127.0.0.1

搜索网址：http://192.168.10.10/wordpress

用户：abcde （自设）

密码：abcde （自设）

邮箱：admin@163.com （自设）

\