[root@cairui htdocs]# ps -ef | grep httpd

php              Mar03 ?        :: /opt/apache2.2.34/bin/httpd -k start

root             Mar03 ?        :: /opt/apache2.2.34/bin/httpd -k graceful

php          Mar03 ?        :: /opt/apache2.2.34/bin/httpd -k graceful

php          Mar03 ?        :: /opt/apache2.2.34/bin/httpd -k graceful

php          Mar03 ?        :: /opt/apache2.2.34/bin/httpd -k graceful

root         : pts/    :: grep httpd

[root@cairui htdocs]# ps -ef | grep mysql

root              Mar01 ?        :: /bin/sh /opt/mysql-5.7./bin/mysqld_safe --datadir=/opt/mysql-5.7./data --pid-file=/opt/mysql-5.7./data/cairui.pid

mysql          Mar01 ?        :: /opt/mysql-5.7./bin/mysqld --basedir=/opt/mysql-5.7. --datadir=/opt/mysql-5.7./data --plugin-dir=/opt/mysql-5.7./lib/plugin --user=mysql --log-error=cairui.err --pid-file=/opt/mysql-5.7./data/cairui.pid

root         : pts/    :: grep mysql

[root@cairui htdocs]# lsof -i tcp:

COMMAND     PID USER   FD   TYPE DEVICE SIZE/OFF NODE NAME

AliYunDun   root   18u  IPv4         0t0  TCP 120.25.255.87:->106.11.68.13:http (ESTABLISHED)

httpd      root    3u  IPv4       0t0  TCP *:http (LISTEN)

httpd       php    3u  IPv4       0t0  TCP *:http (LISTEN)

httpd       php    3u  IPv4       0t0  TCP *:http (LISTEN)

[root@cairui htdocs]# lsof -i tcp:

COMMAND  PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME

mysqld   mysql   29u  IPv4         0t0  TCP *:mysql (LISTEN)

WordPress是使用PHP语言开发的博客平台，用户可以在支持PHP和MySQL数据库的服务器上架设属于自己的网站。也可以把 WordPress当作一个内容管理系统（CMS）来使用。

WordPress是一款个人博客系统，并逐步演化成一款内容管理系统软件，它是使用PHP语言和MySQL数据库开发的。用户可以在支持 PHP 和 MySQL数据库的服务器上使用自己的博客。

WordPress有许多第三方开发的免费模板，安装方式简单易用。不过要做一个自己的模板，则需要你有一定的专业知识。比如你至少要懂的标准通用标记语言下的一个应用HTML代码、CSS、PHP等相关知识。

WordPress官方支持中文版，同时有爱好者开发的第三方中文语言包，如wopus中文语言包。WordPress拥有成千上万个各式插件和不计其数的主题模板样式。

[root@cairui software]# wget https://wordpress.org/latest.tar.gz

---- ::--  https://wordpress.org/latest.tar.gz

Resolving wordpress.org... 198.143.164.252

Connecting to wordpress.org|198.143.164.252|:... connected.

HTTP request sent, awaiting response...  OK

Length:  (8.2M) [application/octet-stream]

Saving to: “latest.tar.gz”

%[=========================================================>] ,,   2.83M/s   in .9s    

-- :: (2.83 MB/s) - “latest.tar.gz” saved [/]

[root@cairui software]# ls

cmake-3.9.         httpd-2.2.         latest.tar.gz  libiconv-1.15.tar.gz  php-7.2.

cmake-3.9..tar.gz  httpd-2.2..tar.gz  libiconv-1.15  mysql-5.7.          php-7.2..tar.gz

[root@cairui software]# tar zxf latest.tar.gz

[root@cairui software]# ls

cmake-3.9.         httpd-2.2..tar.gz  libiconv-1.15.tar.gz  php-7.2..tar.gz

cmake-3.9..tar.gz  latest.tar.gz        mysql-5.7.          wordpress

httpd-2.2.        libiconv-1.15        php-7.2.

[root@cairui software]# cd wordpress/

[root@cairui wordpress]# ls

index.php        wp-admin              wp-content         wp-load.php      wp-signup.php

license.txt      wp-blog-header.php    wp-cron.php        wp-login.php     wp-trackback.php

readme.html      wp-comments-post.php  wp-includes        wp-mail.php      xmlrpc.php

wp-activate.php  wp-config-sample.php  wp-links-opml.php  wp-settings.php

[root@cairui wordpress]# cd ..

[root@cairui software]# cp wordpress/* /opt/apache/htdocs/

cp: overwrite `/opt/apache/htdocs/index.php'? y

cp: omitting directory `wordpress/wp-admin'

cp: omitting directory `wordpress/wp-content'

cp: omitting directory `wordpress/wp-includes'

[root@cairui apache]# mv /home/cairui/software/wordpress/* /opt/apache/htdocs/

[Sun Mar  :: ] [error] [client 114.239.215.144] File does not exist: /opt/apache2.2.34/htdocs/favicon.ico, referer: http://120.25.255.87/

mysql> create database wordpress default character set gbk collate gbk_chinese_ci;　　#创建一个gbk数据库，默认是拉丁字符集

Query OK,  row affected (0.02 sec)

mysql> show databses;

ERROR  (): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'databses' at line

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| managerie          |

| mysql              |

| performance_schema |

| sys                |

| test               |

| wordpress          |

+--------------------+

 rows in set (0.00 sec)

mysql> grant select,delete,insert,update,create on wordpress.* to wordpress@localhost identified by'wordpress';　　#给用户wordpress设置权限

Query OK,  rows affected,  warning (0.08 sec)

mysql> flush privileges;　　#刷新权限

Query OK,  rows affected (0.00 sec)

mysql> select user,host from mysql.user;

+---------------+-----------+

| user          | host      |

+---------------+-----------+

| mysql.session | localhost |

| mysql.sys     | localhost |

| root          | localhost |

| wordpress     | localhost |

+---------------+-----------+

 rows in set (0.00 sec)

mysql> show grants for wordpress@localhost;

+------------------------------------------------------------------------------------------+

| Grants for wordpress@localhost                                                           |

+------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'wordpress'@'localhost'                                            |

| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON `wordpress`.* TO 'wordpress'@'localhost' |

+------------------------------------------------------------------------------------------+

 rows in set (0.00 sec)

SET PASSWORD FOR 'wordpress'@'localhost' = PASSWORD('wordpress')

[root@cairui apache]# chown -R php.php /opt/apache/htdocs/

[root@cairui apache]# cd htdocs/

[root@cairui htdocs]# ls

index.php        wp-admin              wp-content         wp-load.php      wp-signup.php

license.txt      wp-blog-header.php    wp-cron.php        wp-login.php     wp-trackback.php

readme.html      wp-comments-post.php  wp-includes        wp-mail.php      xmlrpc.php

wp-activate.php  wp-config-sample.php  wp-links-opml.php  wp-settings.php

[root@cairui htdocs]# ll

total

-rw-r--r--   php php    Sep    index.php

-rw-r--r--   php php  Jan   : license.txt

-rw-r--r--   php php   Dec    readme.html

-rw-r--r--   php php   Sep  : wp-activate.php

drwxr-xr-x   php php   Feb   : wp-admin

-rw-r--r--   php php    Dec    wp-blog-header.php

-rw-r--r--   php php   Aug    wp-comments-post.php

-rw-r--r--   php php   Dec    wp-config-sample.php

drwxr-xr-x   php php   Feb   : wp-content

-rw-r--r--   php php   Aug    wp-cron.php

drwxr-xr-x  php php  Feb   : wp-includes

-rw-r--r--   php php   Nov    wp-links-opml.php

-rw-r--r--   php php   Aug    wp-load.php

-rw-r--r--   php php  Oct  : wp-login.php

-rw-r--r--   php php   Jan    wp-mail.php

-rw-r--r--   php php  Oct   : wp-settings.php

-rw-r--r--   php php  Oct  : wp-signup.php

-rw-r--r--   php php   Oct  : wp-trackback.php

-rw-r--r--   php php   Sep     xmlrpc.php

mysql> use wordpress

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

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_termmeta           |

| wp_terms              |

| wp_usermeta           |

| wp_users              |

+-----------------------+

 rows in set (0.01 sec)