文章目录[隐藏]
本文主要和大家分享WordPress搭建个人博客,主要以图文和代码的形式和大家分享,希望能帮助到大家。
1 LNMP组合
1.1 验证Nginx到php的连通性
在前几篇博文中所有环境都已经配置好了,下面测试Nginx和php之间的连通
LNMP之Nginx服务搭建及三种类型虚拟主机
LNMP之二进制安装mysql-5.5.54
LNMP之源码编译安装php-5.5.32
# 修改/application/nginx/conf/extra/blog.conf[root@web01 extra]# cat blog.conf server { listen 80; server_name blog.rsq.com; location / { root html/blog; index index.html index.htm; } location ~ .*\.(php|php5)?$ { root html/blog; fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; include fastcgi.conf; } }# 重启nginx服务[root@web01 extra]# ../../sbin/nginx -tnginx: the configuration file /application/nginx-1.6.3//conf/nginx.conf syntax is oknginx: configuration file /application/nginx-1.6.3//conf/nginx.conf test is successful[root@web01 extra]# ../../sbin/nginx -s reload# 在/application/nginx/html/blog/目录中写一个phpinfo文件,测试连通性[root@web01 extra]# cd /application/nginx/html/blog/[root@web01 blog]# echo "<?php phpinfo(); ?>" >test_info.php[root@web01 blog]# cat test_info.php<?php phpinfo(); ?>
# windows浏览器中做访问测试,若出现以下页面则测试成功
1.2 验证php到mysql的连通性
# 写一个简单的数据库连接脚本[root@web01 blog]# cat test_mysql.php<?php $link_id=mysql_connect('localhost','root','oldboy123') or mysql_error(); if($link_id){ echo "Mysql successful by RSQ !"; }else{ echo mysql_error(); }?>
# 浏览器端测试
2 LNMP之wordpress个人博客搭建
2.1 创建wordpress数据库
# 先登录mysql,创建WordPress所需要的数据库[root@web01 ~]# mysql -uroot -poldboy123mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || test |+--------------------+4 rows in set (0.01 sec)mysql> drop database test; # 删除多余的test数据库Query OK, 0 rows affected (0.02 sec)mysql> show databases; #显示数据库+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema |+--------------------+3 rows in set (0.00 sec)mysql> create database wordpress; # 创建wordpress用户Query OK, 1 row affected (0.00 sec)mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || mysql || performance_schema || wordpress |+--------------------+4 rows in set (0.00 sec)mysql> select user();+----------------+| user() |+----------------+| root@localhost |+----------------+1 row in set (0.00 sec)mysql<strong>*本文来源gaodai#ma#com搞@代~码^网+</strong><strong>搞代gaodaima码</strong>> select user,host from mysql.user; #查看当前数据库用户+------+-----------+| user | host |+------+-----------+| root | 127.0.0.1 || root | ::1 || | localhost || root | localhost |+------+-----------+4 rows in set (0.00 sec)# 为wordpress数据库创建专门管理的wordpress用户并授予所有权限mysql> grant all on wordpress.* to wordpress@'localhost' identified by '123456'; Query OK, 0 rows affected (0.00 sec)mysql> select user,host from mysql.user; # 查看wordpress数据库用户是否创建+-----------+-----------+| user | host |+-----------+-----------+| root | 127.0.0.1 || root | ::1 || | localhost || root | localhost || wordpress | localhost |+-----------+-----------+5 rows in set (0.00 sec)mysql> show grants for wordpress@'localhost'; # 查看指定用户所具有的权限mysql> flush privileges; # 刷新一下,使用户权限生效Query OK, 0 rows affected (0.00 sec)
2.2 修改blog.conf配置文件
# blog.conf配置文件中index新增index.html[root@web01 extra]# cat blog.conf server { listen 80; server_name blog.rsq.com; location / { root html/blog; index index.php index.html index.htm; } location ~ .*\.(php|php5)?$ { root html/blog; fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; include fastcgi.conf; } }[root@web01 tools]# /application/nginx/sbin/nginx -t nginx: the configuration file /application/nginx-1.6.3//conf/nginx.conf syntax is oknginx: configuration file /application/nginx-1.6.3//conf/nginx.conf test is successful[root@web01 tools]# /application/nginx/sbin/nginx -s reload