建立完全属于自己的wordpress博客站点
@配置前环境准备,检查自己的LAMP环境@
[root@c601 extra]# pwd
/application/apache/conf/extra
[root@c601 extra]# netstat -lntup|grep -E "80|3306"
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1391/mysqld
tcp 0 0 :::80 :::* LISTEN 1410/httpd
[root@c601 extra]# egrep -v "^#|^$" httpd-vhosts.conf
NameVirtualHost *:80
<VirtualHost *:80>
ServerAdmin 31333741@qq.com
DocumentRoot "/var/blog"
ServerName blog.etiantian.org
ServerAlias etiantian.org
ErrorLog "logs/blog-error_log"
CustomLog "logs/blog-access_log" common
</VirtualHost>
<VirtualHost *:80>
ServerAdmin 31333741@qq.com
DocumentRoot "/var/bbs"
ServerName bbs.etiantian.org
ErrorLog "logs/bbs-error_log"
CustomLog "logs/bbs-access_log" common
</VirtualHost>
@确保虚拟主机blog能够访问@
2、打开wordpress官方站点,下载软件包。
官方中文站点:https://cn.wordpress.org
下载地址:https://wordpress.org/wordpress-3.3.1.zip
#下载站点包,解压,并把相关数据放到blog站点目录下。
命令参考如下:
699 wget https://wordpress.org/wordpress-3.3.1.zip
700 unzip wordpress-3.3.1.zip
702 mv wordpress/* /var/blog/
3、访问blog站点(本地),配置wordpress配置。
mysql> create database wordpress;
Query OK, 1 row affected (0.00 sec)
#在mysql中创建数据库,创建库的默认数据集是拉丁,可以指定数据集为拉丁。
mysql> create database wordpress DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
mysql> show databases like 'wordpress';
+----------------------+
| Database (wordpress) |
+----------------------+
| wordpress |
+----------------------+
1 row in set (0.01 sec)
#授权用户对数据wordpress的相关操作。
mysql> grant select,insert,delete,update,create on wordpress.* to wordpress@localhost identified by 'zxin10';
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host from mysql.user;
+-----------+-----------+
| user | host |
+-----------+-----------+
| root | 127.0.0.1 |
| root | localhost |
| wordpress | localhost |
+-----------+-----------+
3 rows in set (0.00 sec)
mysql> show grants for wordpress@localhost
-> ;
+------------------------------------------------------------------------------------------------------------------+
| Grants for wordpress@localhost |
+------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'wordpress'@'localhost' IDENTIFIED BY PASSWORD '*0D6B7449EE6C559A4821753A0869DD56083BF23A' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON `wordpress`.* TO 'wordpress'@'localhost' |
+------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
提示:在安装完blog后,记得撤销create权限。
4、创建完WordPress需要的数据库之后,就可以配置wordpress站点了。
访问相关站点我的是blog.etiantian.org,安装提示配置。
[root@c601 blog]# cp wp-config-sample.php wp-config.php
[root@c601 blog]# sz wp-config.php
设置完成后,发送到服务器端。
[root@c601 blog]# ll wp-config.php
-rw-r--r-- 1 root root 3157 Feb 14 14:40 wp-config.php
在配置完成后,在数据库端,查看表,可以看到有表了。
mysql> use wordpress
Database changed
mysql> show tables
-> ;
+-----------------------+
| Tables_in_wordpress |
+-----------------------+
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_terms |
| wp_usermeta |
| wp_users |
+-----------------------+
11 rows in set (0.00 sec)
补充:Apache和mysql开机子启动
[root@c601 blog]# echo "/application/apache/bin/apachectl start" >>/etc/rc.d/rc.local
[root@c601 blog]# echo "/etc/init.d/mysqld start" >>/etc/rc.d/rc.local
#安装WordPress站点时,有一些需要注意的地方。
1)数据库的权限符合要求。
2)站点不要设置成777权限,太危险。
3)正确的权限设置应该是,给root,755权限。需要用户修改的信息给apache.apache权限。
@配置前环境准备,检查自己的LAMP环境@
[root@c601 extra]# pwd
/application/apache/conf/extra
[root@c601 extra]# netstat -lntup|grep -E "80|3306"
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1391/mysqld
tcp 0 0 :::80 :::* LISTEN 1410/httpd
[root@c601 extra]# egrep -v "^#|^$" httpd-vhosts.conf
NameVirtualHost *:80
<VirtualHost *:80>
ServerAdmin 31333741@qq.com
DocumentRoot "/var/blog"
ServerName blog.etiantian.org
ServerAlias etiantian.org
ErrorLog "logs/blog-error_log"
CustomLog "logs/blog-access_log" common
</VirtualHost>
<VirtualHost *:80>
ServerAdmin 31333741@qq.com
DocumentRoot "/var/bbs"
ServerName bbs.etiantian.org
ErrorLog "logs/bbs-error_log"
CustomLog "logs/bbs-access_log" common
</VirtualHost>
@确保虚拟主机blog能够访问@
2、打开wordpress官方站点,下载软件包。
官方中文站点:https://cn.wordpress.org
下载地址:https://wordpress.org/wordpress-3.3.1.zip
#下载站点包,解压,并把相关数据放到blog站点目录下。
命令参考如下:
699 wget https://wordpress.org/wordpress-3.3.1.zip
700 unzip wordpress-3.3.1.zip
702 mv wordpress/* /var/blog/
3、访问blog站点(本地),配置wordpress配置。
mysql> create database wordpress;
Query OK, 1 row affected (0.00 sec)
#在mysql中创建数据库,创建库的默认数据集是拉丁,可以指定数据集为拉丁。
mysql> create database wordpress DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
mysql> show databases like 'wordpress';
+----------------------+
| Database (wordpress) |
+----------------------+
| wordpress |
+----------------------+
1 row in set (0.01 sec)
#授权用户对数据wordpress的相关操作。
mysql> grant select,insert,delete,update,create on wordpress.* to wordpress@localhost identified by 'zxin10';
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host from mysql.user;
+-----------+-----------+
| user | host |
+-----------+-----------+
| root | 127.0.0.1 |
| root | localhost |
| wordpress | localhost |
+-----------+-----------+
3 rows in set (0.00 sec)
mysql> show grants for wordpress@localhost
-> ;
+------------------------------------------------------------------------------------------------------------------+
| Grants for wordpress@localhost |
+------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'wordpress'@'localhost' IDENTIFIED BY PASSWORD '*0D6B7449EE6C559A4821753A0869DD56083BF23A' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON `wordpress`.* TO 'wordpress'@'localhost' |
+------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
提示:在安装完blog后,记得撤销create权限。
4、创建完WordPress需要的数据库之后,就可以配置wordpress站点了。
访问相关站点我的是blog.etiantian.org,安装提示配置。
[root@c601 blog]# cp wp-config-sample.php wp-config.php
[root@c601 blog]# sz wp-config.php
设置完成后,发送到服务器端。
[root@c601 blog]# ll wp-config.php
-rw-r--r-- 1 root root 3157 Feb 14 14:40 wp-config.php
在配置完成后,在数据库端,查看表,可以看到有表了。
mysql> use wordpress
Database changed
mysql> show tables
-> ;
+-----------------------+
| Tables_in_wordpress |
+-----------------------+
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_terms |
| wp_usermeta |
| wp_users |
+-----------------------+
11 rows in set (0.00 sec)
补充:Apache和mysql开机子启动
[root@c601 blog]# echo "/application/apache/bin/apachectl start" >>/etc/rc.d/rc.local
[root@c601 blog]# echo "/etc/init.d/mysqld start" >>/etc/rc.d/rc.local
#安装WordPress站点时,有一些需要注意的地方。
1)数据库的权限符合要求。
2)站点不要设置成777权限,太危险。
3)正确的权限设置应该是,给root,755权限。需要用户修改的信息给apache.apache权限。