在Debian上安装WordPress的注意事项。

Apache2 VirtualHost（HTTP/S）

启用Apache重写和ssl模块：

# a2enmod rewrite ssl

将以下配置添加到'/etc/apache2/httpd.conf'中。

<VirtualHost *:80>

ServerAdmin Hyman@theitroad

ServerName example.com

ServerAlias blog.example.com
	RewriteEngine On

RewriteCond %{HTTPS} off

RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI}

ErrorLog ${APACHE_LOG_DIR}/wordpress_error.log

CustomLog ${APACHE_LOG_DIR}/wordpress_access.log combined
</VirtualHost>
<VirtualHost *:443>

ServerAdmin Hyman@theitroad

ServerName example.com

ServerAlias blog.example.com

SSLEngine on

SSLProtocol all -SSLv2 -SSLv3

SSLCertificateFile

/etc/ssl/webserver/server.crt

SSLCertificateKeyFile   /etc/ssl/webserver/server.key

SSLCertificateChainFile /etc/ssl/webserver/server-ca-bundle.crt

LogLevel error

ErrorLog ${APACHE_LOG_DIR}/wordpress_error.log

CustomLog ${APACHE_LOG_DIR}/wordpress_access.log combined

DocumentRoot /data/ftp/wordpress

<Directory

Options FollowSymLinks MultiViews

AllowOverride All

Order allow,deny

allow from all

SSLRequireSSL

</Directory>
</VirtualHost>

MySQL数据库和用户

获取现有MySQL用户和主机的列表。

mysql> SELECT user,host FROM mysql.user;

使用新用户创建一个新的WordPress数据库。

mysql> CREATE DATABASE my_wp;
mysql> GRANT ALL PRIVILEGES ON my_wp.* TO "wpuser"@"localhost" IDENTIFIED BY "passwd";
mysql> FLUSH PRIVILEGES;

mysql> SHOW grants FOR 'wpuser'@'localhost';
+---------------------------------------------------------------------------------+
| Grants for Hyman@theitroad

|
+---------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'wpuser'@'localhost' IDENTIFIED BY PASSWORD '*4502000000' |
| GRANT ALL PRIVILEGES ON `my_wp`.* TO 'wpuser'@'localhost'

|
+---------------------------------------------------------------------------------+

从MySQL删除用户。

mysql> DELETE FROM mysql.user WHERE user='username';

ProFTPd用户

Web服务器的组ID：

# grep www-data /etc/group
www-data:x:33:

FTP根目录位于'/data/ftp /'下。
添加新的ProFTPd用户：

# ftpasswd --passwd --file=/etc/proftpd/auth/users.passwd --name=ftpuser --home=/data/ftp/wordpress --shell=/bin/false --uid=33 --gid=33

如何设置ProFTPd。

或者，将以下行添加到“ wp-config.php”以更新不带ftp的wordpress：

define('FS_METHOD','direct');

WordPress的安装和配置

下载并安装：

# wget http://wordpress.org/latest.tar.gz
# tar xf ./latest.tar.gz -C /data/ftp
# chown -R root:root /data/ftp/wordpress
# chmod 0755 /data/ftp/wordpress
# chown -R www-data:root /data/ftp/wordpress/wp-content 
# cd ./wordpress
# cp ./wp-config-sample.php ./wp-config.php
# chown root:www-data ./wp-config.php
# chmod 0640 ./wp-config.php

打开“ wp-config.php”并进行适当配置。

//MySQL settings
define('DB_NAME', 'my_wp');
define('DB_USER', 'wpuser');
define('DB_PASSWORD', 'wppasswd');
define('DB_HOST', 'localhost');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
//FTP config
define('FS_METHOD', 'direct');
define('FTP_BASE', '/data/ftp/wordpress');
define('FTP_USER', 'ftpuser');
define('FTP_PASS', 'ftppasswd');
define('FTP_HOST', 'localhost');
define('FTP_SSL', false);
//Get keys from: https://api.wordpress.org/secret-key/1.1/salt/
define('AUTH_KEY',

'Hyman@theitroad*54');
define('SECURE_AUTH_KEY',  ',fL!xtyZ=');
define('LOGGED_IN_KEY',    '_uYlu&amp');
define('NONCE_KEY',

'DB|pL_,L0');
define('AUTH_SALT',

'HSCA^k)1i');
define('SECURE_AUTH_SALT', 'PHzO#OZgE');
define('LOGGED_IN_SALT',   '6b,8ymis)');
define('NONCE_SALT',

'Q<~d=?');
//WordPress database table prefix
$table_prefix  = 'wp_';
define('WPLANG', '');
define('WP_DEBUG', false);
if ( !defined('ABSPATH') )

define('ABSPATH', dirname(__FILE__) . '/');
require_once(ABSPATH . 'wp-settings.php');

导航到https：//localhost/wp-admin/install.php并完成安装。

在MySQL数据库中更改WordPress站点名称

要获取现有值：

mysql> SELECT * from wp_options WHERE option_name = 'siteurl';
mysql> SELECT * from wp_options WHERE option_name = 'home';

放置新值：

mysql> UPDATE wp_options SET option_value = 'http://example.com' WHERE option_name = 'siteurl';

mysql> UPDATE wp_options SET option_value = 'http://example.com' WHERE option_name = 'home';