快速搭建博客系统 ubuntu+caddy+php+wordpress

安装请Caddy请参考 Ubuntu 安装最新版本 Caddy

add-apt-repository ppa:ondrej/php
apt install php-cli php-fpm php-mysql
php --version

php配置文件路径 /etc/php/8.1/fpm/pool.d/www.conf

cd /var/www
从这里找到下载地址 https://cn.wordpress.org/download/
wget https://cn.wordpress.org/latest-zh_CN.tar.gz
tar –xvzf latest.tar.gz

vim /etc/caddy/Caddyfile
blog.domain.com {

root * /var/www/wordpress
php_fastcgi unix//run/php/php8.1-fpm.sock    
file_server

}

systemctl restart php8.1-fpm
systemctl restart caddy

echo '<?php phpinfo() ?>' > /var/www/wordpress/info.php
https://blog.domain.com/info.php 应该可以访问了

chown -R www-data:www-data /var/www/wordpress
:set paste

删除MySql某个库的所有表：
select concat('drop table ',table_name,';') as sql from information_schema.TABLES where table_schema='myblog';
复制出来的信息执行即可