Forgive the brief notes I’ve not got a box handy with this set up.
On the WordPress side you can set the server to be on a different system in wp-config.php https://codex.wordpress.org/Editing_wp-config.php
. I cannot remember if the default install screen gives you the option or not (it may show 127.0.0.1 or local host)
MySQL or (MariaDB) by default does not allow remote connections for security but a small change to the configuration file and user settings will get you in.
Users need to be set along these lines:
Code: Select all
GRANT ALL ON WPData.* TO WPUser@'192.168.1.10' IDENTIFIED BY 'password';
where 192.168.1.10 is the web server IP address
The server itself needs to listen for requests from the web server and you edit my.cnf and set the bind-address = 192.168.1.10
(again the IP address of the web server)
Note migrating from this set up is more complex
I also recommend using static IP addresses for the servers
Im not sure of the speed impact on the Pi - WP is not the most compact of web pages.