1、搭建php-fpm工作方式的LAMP环境，实现wordpress正常访问

一、配置mariadb-server

二、配置httpd

1）配置web server

2）配置将php资源反代至php-fpm

三、配置php-fpm

四、布署php开发的开源动态应用程序

五、面临的问题整理

测试V1

测试V2

测试V3

测试V4

附上脚本：生成测试页面

https://github.com/slcnx/tools/blob/master/gen_index_phpinfo_php-mysql.sh

1

https://github.com/slcnx/tools/blob/master/gen_index_phpinfo_php-mysql.sh

2、什么是DML？常用SQL举例，每个命令至少1个例子，最多不超过3个例子

INSERT

添加YangGuo, 单行插入, 所有字段插件

MariaDB [hidb]> INSERT INTO students VALUES ('1','YangGuo','M','899-06-04',3);

1

MariaDB [hidb]> INSERT INTO students VALUES ('1','YangGuo','M','899-06-04',3);

添加Guo Jing, Ding Dian, 多行插入, 给定字段插入

MariaDB [hidb]> INSERT INTO students(name,gender) VALUES ('Guo Jing','M'),('Ding Dian','M');

1

MariaDB [hidb]> INSERT INTO students(name,gender) VALUES ('Guo Jing','M'),('Ding Dian','M');

添加与主键冲突的Ding Dang

MariaDB [hidb]> REPLACE INTO students VALUES ('3','Ding Dang','F','1001-09-10',5);

1

MariaDB [hidb]> REPLACE INTO students VALUES ('3','Ding Dang','F','1001-09-10',5);

SELECT

显示同学班级编号为空或不空的同学；

MariaDB [hidb]> SELECT * FROM students WHERE classid IS NULL;

1

MariaDB [hidb]> SELECT * FROM students WHERE classid IS NULL;

用户的名字以d开头的同学？

MariaDB [hidb]> SELECT * FROM students WHERE name LIKE 'd%';

1

MariaDB [hidb]> SELECT * FROM students WHERE name LIKE 'd%';

注意: VARCHAR类型不区分大小写

属于1、2、3班的同学且性别不是女性?

MariaDB [hidb]> SELECT * FROM students WHERE classid IN (1,2,3) AND NOT gender='F';

1

MariaDB [hidb]> SELECT * FROM students WHERE classid IN (1,2,3) AND NOT gender='F';

男同学人数?

MariaDB [hidb]> SELECT gender,count(*) AS nos FROM students GROUP BY gender HAVING gender='M';

1

MariaDB [hidb]> SELECT gender,count(*) AS nos FROM students GROUP BY gender HAVING gender='M';

DELETE

删除id大于2的用户

MariaDB [hidb]> DELETE FROM students WHERE stuid>=3;

1

MariaDB [hidb]> DELETE FROM students WHERE stuid>=3;

删除年龄从大到小排序的前100个用户

MariaDB [hidb]> DELETE FROM students ORDER BY age DESC LIMIT 100;

1

MariaDB [hidb]> DELETE FROM students ORDER BY age DESC LIMIT 100;

UPDATE

将所有classid设定为2

MariaDB [hidb]> UPDATE students SET classid=2;

1

MariaDB [hidb]> UPDATE students SET classid=2;

将Guo Jing班级设定为3

MariaDB [hidb]> UPDATE students SET classid=3 WHERE name='Guo Jing';

1

MariaDB [hidb]> UPDATE students SET classid=3 WHERE name='Guo Jing';

修改当前root@localhost用户的密码为magedu

MariaDB [hidb]> UPDATE mysql.user SET Password=PASSWORD('magedu') WHERE user='root' AND host='localhost'; MariaDB [hidb]> FLUSH PRIVILEGES;

1
2

MariaDB [hidb]> UPDATE mysql.user SET Password=PASSWORD('magedu') WHERE user='root' AND host='localhost';
MariaDB [hidb]> FLUSH PRIVILEGES;