Setting up WordPress on the Raspberry Pi is not hugely complicated. Once you have Apache, PHP and the MYSQL server set up, it is smooth sailing.<\/p>\n\n\n\n
Before you go too far ahead in this tutorial, make sure that you have your MYSQL root password ready. We will be running through the steps to setting up a database for WordPress and showing you how to set up an SQL user to interact with the database all by using the MYSQL Command line.<\/p>\n\n\n\n
If you\u2019re interested then now is the time to set up WordPress on the Raspberry Pi.<\/p>\n<\/blockquote>\n\n\n\n
Equipment List<\/h3>\n\n\n\n\nBelow are all the bits and pieces that I made use of for this Raspberry Pi WordPress tutorial.<\/p>\n\n\n\n
Recommended<\/h3>\n\n\n\n\n- Raspberry Pi<\/li>\n\n\n\n
- Micro SD Card<\/li>\n\n\n\n
- Power Supply<\/li>\n\n\n\n
- Ethernet Cable\u00a0or\u00a0Wi-Fi<\/li>\n<\/ul>\n\n\n\n
Optional<\/h3>\n\n\n\n\n- Raspberry Pi Case<\/li>\n\n\n\n
- USB Keyboard<\/li>\n\n\n\n
- USB Mouse<\/li>\n\n\n\n
- HDMI Cable<\/li>\n\n\n\n
- Monitor<\/li>\n<\/ul>\n<\/blockquote>\n\n\n\n
Setting up WordPress on a Raspberry Pi<\/strong><\/h4>\n\n\n\nBefore you start this tutorial make sure you have setup Apache and PHP<\/a>. You will also need to have a MYSQL server running<\/a> and accessible. As I mentioned earlier, you will need to have your MYSQL root password ready.<\/p>\n\n\n\n1.<\/strong> To start, we need to download and extract WordPress to our \u201c\/var\/www\/<\/code>your_domain\/public_html\u201d directory on our Raspberry Pi.<\/p>\n\n\n\nWe will also need to take ownership of the \u201c\/var\/www<\/code>\/your_domain\/public_html\u201d folder with the \u201c<\/strong>www-data<\/code>\u201d user and group. Doing this will allow PHP to process WordPress without running into any permission errors.<\/p>\n\n\n\nTo achieve all of this, we will run a few commands, just type each line below into the terminal.<\/p>\n\n\n\n
cd \/var\/www<\/code>\/your_domain\/public_html<\/p>\n\n\n\nsudo wget http:\/\/wordpress.org\/latest.tar.gz <\/p>\n\n\n\n
sudo tar xzf latest.tar.gz <\/p>\n\n\n\n
sudo mv wordpress\/* .\/ <\/p>\n\n\n\n
sudo rm -rf wordpress latest.tar.gz <\/p>\n\n\n\n
sudo usermod -a -G www-data user <\/p>\n\n\n\n
sudo chown -R -f www-data:www-data \/var\/www<\/code>\/your_domain\/public_html<\/p>\n\n\n\n<\/p>\n\n\n\n
Now that WordPress is downloaded and extracted to our Raspberry Pi, we will also need to set up a database within MYSQL for WordPress to store its information.<\/p>\n\n\n\n
We need to first use the MySQL command to login. Use the \u201c\u2013p<\/code>\u201d flag for the password<\/strong> and \u201c\u2013u<\/code>\u201d for the username<\/strong>. Make sure your password is written right next to the \u201c-p<\/code>\u201c tag<\/strong> with no space<\/strong>.<\/p>\n\n\n\nNote:<\/strong> Replace password<\/strong> with the one you set up for the root user when you setup MySQL<\/p>\n\n\n\nsudo mysql -u root -p<\/p>\n\n\n\n
Now that we have logged into the MYSQL server, we can issue a command to create a database for WordPress using this simple line:<\/p>\n\n\n\n
CREATE DATABASE wordpress;<\/p>\n\n\n\n
Now we will create a separate user for this database, this is far safer from a security perspective.<\/p>\n\n\n\n
While still in MYSQL issue the following command:<\/p>\n\n\n\n
CREATE USER ‘new_user’@’localhost’ IDENTIFIED BY ‘new_password’;<\/p>\n\n\n\n
Note:<\/strong> Make sure you replace new_user<\/code> and new_password<\/code> with details of your choosing, just remember what you choose as you will need to know both when we setup WordPress.<\/p>\n\n\n\n5.<\/strong> Once we have a new user, we will need to give it permissions to manage our new database.<\/p>\n\n\n\nWe can do that with the command below, make sure you swap new_user<\/code>, with whatever you entered in the previous step.<\/p>\n\n\n\nGRANT ALL ON wordpress.* TO ‘new_user’@’localhost’;<\/p>\n\n\n\n
Now we have created our database and our user that we want to interact with it. We need to quit out of the MYSQL command interface.<\/p>\n\n\n\n
We can do that by pressing CTRL<\/kbd> + D<\/kbd>.<\/p>\n\n\n\n With that all done, we can now finally finish setting up WordPress, we can start this process by going to your Raspberry Pi\u2019s IP address in a web browser.<\/p>\n\n\n\n![\"\"](\"https:\/\/koner.mywire.org\/wp-content\/uploads\/2022\/11\/wordpress1.png\")
<\/figure>\n\n\n\nYou will now need to enter various details so that WordPress can connect to the MySQL database we setup.<\/p>\n\n\n\n
\n- Database Name<\/strong> \u2013 This is the database WordPress will connect to. Earlier in this tutorial we created a database called
wordpress<\/code>.<\/li>\n\n\n\n- Username<\/strong> \u2013 This is the user we created in step 4<\/strong>, make sure you get this detail correct as it needs to connect to the above database.<\/li>\n\n\n\n
- Password<\/strong> \u2013 This is the password we set while creating the MYSQL user in step 4<\/strong>, again make sure you enter this correctly as it\u2019s needed to connect to the database.<\/li>\n\n\n\n
- Database Host<\/strong> \u2013 Keep this to the default setting, we only need it to connect locally.<\/li>\n\n\n\n
- Table Prefix<\/strong> \u2013 Keep this to the default setting as well, there is no real need to change this<\/li>\n\n\n\n
- <\/li>\n<\/ul>\n\n\n\n
Assuming you entered all the correct details, you will now be able to press \u201cSubmit<\/strong>\u201d to successfully install the software, follow the rest of the prompts to finalize the installation.<\/p>\n\n\n\nThere is quite a bit more to learn about WordPress such as installing a WordPress theme or setting up plugins. Using a Raspberry Pi is a great way to learn all the basics without investing in an expensive web server.<\/p>\n\n\n\n
You should now have WordPress setup on the Raspberry Pi and accessible. <\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
For those who do not know,\u00a0WordPress is a content management system\u00a0that is used by over 60 million websites. It is very popular amongst bloggers, but is also used by large websites such as TechCrunch. I currently have WordPress running on my Raspberry Pi to act as a development server as it\u2019s faster than using something […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-2","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/comments?post=2"}],"version-history":[{"count":14,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/media?parent=2"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Below are all the bits and pieces that I made use of for this Raspberry Pi WordPress tutorial.<\/p>\n\n\n\n
Recommended<\/h3>\n\n\n\n\n- Raspberry Pi<\/li>\n\n\n\n
- Micro SD Card<\/li>\n\n\n\n
- Power Supply<\/li>\n\n\n\n
- Ethernet Cable\u00a0or\u00a0Wi-Fi<\/li>\n<\/ul>\n\n\n\n
Optional<\/h3>\n\n\n\n\n- Raspberry Pi Case<\/li>\n\n\n\n
- USB Keyboard<\/li>\n\n\n\n
- USB Mouse<\/li>\n\n\n\n
- HDMI Cable<\/li>\n\n\n\n
- Monitor<\/li>\n<\/ul>\n<\/blockquote>\n\n\n\n
Setting up WordPress on a Raspberry Pi<\/strong><\/h4>\n\n\n\nBefore you start this tutorial make sure you have setup Apache and PHP<\/a>. You will also need to have a MYSQL server running<\/a> and accessible. As I mentioned earlier, you will need to have your MYSQL root password ready.<\/p>\n\n\n\n1.<\/strong> To start, we need to download and extract WordPress to our \u201c\/var\/www\/<\/code>your_domain\/public_html\u201d directory on our Raspberry Pi.<\/p>\n\n\n\nWe will also need to take ownership of the \u201c\/var\/www<\/code>\/your_domain\/public_html\u201d folder with the \u201c<\/strong>www-data<\/code>\u201d user and group. Doing this will allow PHP to process WordPress without running into any permission errors.<\/p>\n\n\n\nTo achieve all of this, we will run a few commands, just type each line below into the terminal.<\/p>\n\n\n\n
cd \/var\/www<\/code>\/your_domain\/public_html<\/p>\n\n\n\nsudo wget http:\/\/wordpress.org\/latest.tar.gz <\/p>\n\n\n\n
sudo tar xzf latest.tar.gz <\/p>\n\n\n\n
sudo mv wordpress\/* .\/ <\/p>\n\n\n\n
sudo rm -rf wordpress latest.tar.gz <\/p>\n\n\n\n
sudo usermod -a -G www-data user <\/p>\n\n\n\n
sudo chown -R -f www-data:www-data \/var\/www<\/code>\/your_domain\/public_html<\/p>\n\n\n\n<\/p>\n\n\n\n
Now that WordPress is downloaded and extracted to our Raspberry Pi, we will also need to set up a database within MYSQL for WordPress to store its information.<\/p>\n\n\n\n
We need to first use the MySQL command to login. Use the \u201c\u2013p<\/code>\u201d flag for the password<\/strong> and \u201c\u2013u<\/code>\u201d for the username<\/strong>. Make sure your password is written right next to the \u201c-p<\/code>\u201c tag<\/strong> with no space<\/strong>.<\/p>\n\n\n\nNote:<\/strong> Replace password<\/strong> with the one you set up for the root user when you setup MySQL<\/p>\n\n\n\nsudo mysql -u root -p<\/p>\n\n\n\n
Now that we have logged into the MYSQL server, we can issue a command to create a database for WordPress using this simple line:<\/p>\n\n\n\n
CREATE DATABASE wordpress;<\/p>\n\n\n\n
Now we will create a separate user for this database, this is far safer from a security perspective.<\/p>\n\n\n\n
While still in MYSQL issue the following command:<\/p>\n\n\n\n
CREATE USER ‘new_user’@’localhost’ IDENTIFIED BY ‘new_password’;<\/p>\n\n\n\n
Note:<\/strong> Make sure you replace new_user<\/code> and new_password<\/code> with details of your choosing, just remember what you choose as you will need to know both when we setup WordPress.<\/p>\n\n\n\n5.<\/strong> Once we have a new user, we will need to give it permissions to manage our new database.<\/p>\n\n\n\nWe can do that with the command below, make sure you swap new_user<\/code>, with whatever you entered in the previous step.<\/p>\n\n\n\nGRANT ALL ON wordpress.* TO ‘new_user’@’localhost’;<\/p>\n\n\n\n
Now we have created our database and our user that we want to interact with it. We need to quit out of the MYSQL command interface.<\/p>\n\n\n\n
We can do that by pressing CTRL<\/kbd> + D<\/kbd>.<\/p>\n\n\n\n With that all done, we can now finally finish setting up WordPress, we can start this process by going to your Raspberry Pi\u2019s IP address in a web browser.<\/p>\n\n\n\n<\/figure>\n\n\n\nYou will now need to enter various details so that WordPress can connect to the MySQL database we setup.<\/p>\n\n\n\n
\n- Database Name<\/strong> \u2013 This is the database WordPress will connect to. Earlier in this tutorial we created a database called
wordpress<\/code>.<\/li>\n\n\n\n- Username<\/strong> \u2013 This is the user we created in step 4<\/strong>, make sure you get this detail correct as it needs to connect to the above database.<\/li>\n\n\n\n
- Password<\/strong> \u2013 This is the password we set while creating the MYSQL user in step 4<\/strong>, again make sure you enter this correctly as it\u2019s needed to connect to the database.<\/li>\n\n\n\n
- Database Host<\/strong> \u2013 Keep this to the default setting, we only need it to connect locally.<\/li>\n\n\n\n
- Table Prefix<\/strong> \u2013 Keep this to the default setting as well, there is no real need to change this<\/li>\n\n\n\n
- <\/li>\n<\/ul>\n\n\n\n
Assuming you entered all the correct details, you will now be able to press \u201cSubmit<\/strong>\u201d to successfully install the software, follow the rest of the prompts to finalize the installation.<\/p>\n\n\n\nThere is quite a bit more to learn about WordPress such as installing a WordPress theme or setting up plugins. Using a Raspberry Pi is a great way to learn all the basics without investing in an expensive web server.<\/p>\n\n\n\n
You should now have WordPress setup on the Raspberry Pi and accessible. <\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
For those who do not know,\u00a0WordPress is a content management system\u00a0that is used by over 60 million websites. It is very popular amongst bloggers, but is also used by large websites such as TechCrunch. I currently have WordPress running on my Raspberry Pi to act as a development server as it\u2019s faster than using something […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-2","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/comments?post=2"}],"version-history":[{"count":14,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/media?parent=2"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Optional<\/h3>\n\n\n\n\n- Raspberry Pi Case<\/li>\n\n\n\n
- USB Keyboard<\/li>\n\n\n\n
- USB Mouse<\/li>\n\n\n\n
- HDMI Cable<\/li>\n\n\n\n
- Monitor<\/li>\n<\/ul>\n<\/blockquote>\n\n\n\n
Setting up WordPress on a Raspberry Pi<\/strong><\/h4>\n\n\n\nBefore you start this tutorial make sure you have setup Apache and PHP<\/a>. You will also need to have a MYSQL server running<\/a> and accessible. As I mentioned earlier, you will need to have your MYSQL root password ready.<\/p>\n\n\n\n1.<\/strong> To start, we need to download and extract WordPress to our \u201c\/var\/www\/<\/code>your_domain\/public_html\u201d directory on our Raspberry Pi.<\/p>\n\n\n\nWe will also need to take ownership of the \u201c\/var\/www<\/code>\/your_domain\/public_html\u201d folder with the \u201c<\/strong>www-data<\/code>\u201d user and group. Doing this will allow PHP to process WordPress without running into any permission errors.<\/p>\n\n\n\nTo achieve all of this, we will run a few commands, just type each line below into the terminal.<\/p>\n\n\n\n
cd \/var\/www<\/code>\/your_domain\/public_html<\/p>\n\n\n\nsudo wget http:\/\/wordpress.org\/latest.tar.gz <\/p>\n\n\n\n
sudo tar xzf latest.tar.gz <\/p>\n\n\n\n
sudo mv wordpress\/* .\/ <\/p>\n\n\n\n
sudo rm -rf wordpress latest.tar.gz <\/p>\n\n\n\n
sudo usermod -a -G www-data user <\/p>\n\n\n\n
sudo chown -R -f www-data:www-data \/var\/www<\/code>\/your_domain\/public_html<\/p>\n\n\n\n<\/p>\n\n\n\n
Now that WordPress is downloaded and extracted to our Raspberry Pi, we will also need to set up a database within MYSQL for WordPress to store its information.<\/p>\n\n\n\n
We need to first use the MySQL command to login. Use the \u201c\u2013p<\/code>\u201d flag for the password<\/strong> and \u201c\u2013u<\/code>\u201d for the username<\/strong>. Make sure your password is written right next to the \u201c-p<\/code>\u201c tag<\/strong> with no space<\/strong>.<\/p>\n\n\n\nNote:<\/strong> Replace password<\/strong> with the one you set up for the root user when you setup MySQL<\/p>\n\n\n\nsudo mysql -u root -p<\/p>\n\n\n\n
Now that we have logged into the MYSQL server, we can issue a command to create a database for WordPress using this simple line:<\/p>\n\n\n\n
CREATE DATABASE wordpress;<\/p>\n\n\n\n
Now we will create a separate user for this database, this is far safer from a security perspective.<\/p>\n\n\n\n
While still in MYSQL issue the following command:<\/p>\n\n\n\n
CREATE USER ‘new_user’@’localhost’ IDENTIFIED BY ‘new_password’;<\/p>\n\n\n\n
Note:<\/strong> Make sure you replace new_user<\/code> and new_password<\/code> with details of your choosing, just remember what you choose as you will need to know both when we setup WordPress.<\/p>\n\n\n\n5.<\/strong> Once we have a new user, we will need to give it permissions to manage our new database.<\/p>\n\n\n\nWe can do that with the command below, make sure you swap new_user<\/code>, with whatever you entered in the previous step.<\/p>\n\n\n\nGRANT ALL ON wordpress.* TO ‘new_user’@’localhost’;<\/p>\n\n\n\n
Now we have created our database and our user that we want to interact with it. We need to quit out of the MYSQL command interface.<\/p>\n\n\n\n
We can do that by pressing CTRL<\/kbd> + D<\/kbd>.<\/p>\n\n\n\n With that all done, we can now finally finish setting up WordPress, we can start this process by going to your Raspberry Pi\u2019s IP address in a web browser.<\/p>\n\n\n\n<\/figure>\n\n\n\nYou will now need to enter various details so that WordPress can connect to the MySQL database we setup.<\/p>\n\n\n\n
\n- Database Name<\/strong> \u2013 This is the database WordPress will connect to. Earlier in this tutorial we created a database called
wordpress<\/code>.<\/li>\n\n\n\n- Username<\/strong> \u2013 This is the user we created in step 4<\/strong>, make sure you get this detail correct as it needs to connect to the above database.<\/li>\n\n\n\n
- Password<\/strong> \u2013 This is the password we set while creating the MYSQL user in step 4<\/strong>, again make sure you enter this correctly as it\u2019s needed to connect to the database.<\/li>\n\n\n\n
- Database Host<\/strong> \u2013 Keep this to the default setting, we only need it to connect locally.<\/li>\n\n\n\n
- Table Prefix<\/strong> \u2013 Keep this to the default setting as well, there is no real need to change this<\/li>\n\n\n\n
- <\/li>\n<\/ul>\n\n\n\n
Assuming you entered all the correct details, you will now be able to press \u201cSubmit<\/strong>\u201d to successfully install the software, follow the rest of the prompts to finalize the installation.<\/p>\n\n\n\nThere is quite a bit more to learn about WordPress such as installing a WordPress theme or setting up plugins. Using a Raspberry Pi is a great way to learn all the basics without investing in an expensive web server.<\/p>\n\n\n\n
You should now have WordPress setup on the Raspberry Pi and accessible. <\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
For those who do not know,\u00a0WordPress is a content management system\u00a0that is used by over 60 million websites. It is very popular amongst bloggers, but is also used by large websites such as TechCrunch. I currently have WordPress running on my Raspberry Pi to act as a development server as it\u2019s faster than using something […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-2","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/comments?post=2"}],"version-history":[{"count":14,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/media?parent=2"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Setting up WordPress on a Raspberry Pi<\/strong><\/h4>\n\n\n\nBefore you start this tutorial make sure you have setup Apache and PHP<\/a>. You will also need to have a MYSQL server running<\/a> and accessible. As I mentioned earlier, you will need to have your MYSQL root password ready.<\/p>\n\n\n\n1.<\/strong> To start, we need to download and extract WordPress to our \u201c\/var\/www\/<\/code>your_domain\/public_html\u201d directory on our Raspberry Pi.<\/p>\n\n\n\nWe will also need to take ownership of the \u201c\/var\/www<\/code>\/your_domain\/public_html\u201d folder with the \u201c<\/strong>www-data<\/code>\u201d user and group. Doing this will allow PHP to process WordPress without running into any permission errors.<\/p>\n\n\n\nTo achieve all of this, we will run a few commands, just type each line below into the terminal.<\/p>\n\n\n\n
cd \/var\/www<\/code>\/your_domain\/public_html<\/p>\n\n\n\nsudo wget http:\/\/wordpress.org\/latest.tar.gz <\/p>\n\n\n\n
sudo tar xzf latest.tar.gz <\/p>\n\n\n\n
sudo mv wordpress\/* .\/ <\/p>\n\n\n\n
sudo rm -rf wordpress latest.tar.gz <\/p>\n\n\n\n
sudo usermod -a -G www-data user <\/p>\n\n\n\n
sudo chown -R -f www-data:www-data \/var\/www<\/code>\/your_domain\/public_html<\/p>\n\n\n\n<\/p>\n\n\n\n
Now that WordPress is downloaded and extracted to our Raspberry Pi, we will also need to set up a database within MYSQL for WordPress to store its information.<\/p>\n\n\n\n
We need to first use the MySQL command to login. Use the \u201c\u2013p<\/code>\u201d flag for the password<\/strong> and \u201c\u2013u<\/code>\u201d for the username<\/strong>. Make sure your password is written right next to the \u201c-p<\/code>\u201c tag<\/strong> with no space<\/strong>.<\/p>\n\n\n\nNote:<\/strong> Replace password<\/strong> with the one you set up for the root user when you setup MySQL<\/p>\n\n\n\nsudo mysql -u root -p<\/p>\n\n\n\n
Now that we have logged into the MYSQL server, we can issue a command to create a database for WordPress using this simple line:<\/p>\n\n\n\n
CREATE DATABASE wordpress;<\/p>\n\n\n\n
Now we will create a separate user for this database, this is far safer from a security perspective.<\/p>\n\n\n\n
While still in MYSQL issue the following command:<\/p>\n\n\n\n
CREATE USER ‘new_user’@’localhost’ IDENTIFIED BY ‘new_password’;<\/p>\n\n\n\n
Note:<\/strong> Make sure you replace new_user<\/code> and new_password<\/code> with details of your choosing, just remember what you choose as you will need to know both when we setup WordPress.<\/p>\n\n\n\n5.<\/strong> Once we have a new user, we will need to give it permissions to manage our new database.<\/p>\n\n\n\nWe can do that with the command below, make sure you swap new_user<\/code>, with whatever you entered in the previous step.<\/p>\n\n\n\nGRANT ALL ON wordpress.* TO ‘new_user’@’localhost’;<\/p>\n\n\n\n
Now we have created our database and our user that we want to interact with it. We need to quit out of the MYSQL command interface.<\/p>\n\n\n\n
We can do that by pressing CTRL<\/kbd> + D<\/kbd>.<\/p>\n\n\n\n With that all done, we can now finally finish setting up WordPress, we can start this process by going to your Raspberry Pi\u2019s IP address in a web browser.<\/p>\n\n\n\n<\/figure>\n\n\n\nYou will now need to enter various details so that WordPress can connect to the MySQL database we setup.<\/p>\n\n\n\n
\n- Database Name<\/strong> \u2013 This is the database WordPress will connect to. Earlier in this tutorial we created a database called
wordpress<\/code>.<\/li>\n\n\n\n- Username<\/strong> \u2013 This is the user we created in step 4<\/strong>, make sure you get this detail correct as it needs to connect to the above database.<\/li>\n\n\n\n
- Password<\/strong> \u2013 This is the password we set while creating the MYSQL user in step 4<\/strong>, again make sure you enter this correctly as it\u2019s needed to connect to the database.<\/li>\n\n\n\n
- Database Host<\/strong> \u2013 Keep this to the default setting, we only need it to connect locally.<\/li>\n\n\n\n
- Table Prefix<\/strong> \u2013 Keep this to the default setting as well, there is no real need to change this<\/li>\n\n\n\n
- <\/li>\n<\/ul>\n\n\n\n
Assuming you entered all the correct details, you will now be able to press \u201cSubmit<\/strong>\u201d to successfully install the software, follow the rest of the prompts to finalize the installation.<\/p>\n\n\n\nThere is quite a bit more to learn about WordPress such as installing a WordPress theme or setting up plugins. Using a Raspberry Pi is a great way to learn all the basics without investing in an expensive web server.<\/p>\n\n\n\n
You should now have WordPress setup on the Raspberry Pi and accessible. <\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
For those who do not know,\u00a0WordPress is a content management system\u00a0that is used by over 60 million websites. It is very popular amongst bloggers, but is also used by large websites such as TechCrunch. I currently have WordPress running on my Raspberry Pi to act as a development server as it\u2019s faster than using something […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-2","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/comments?post=2"}],"version-history":[{"count":14,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/media?parent=2"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
1.<\/strong> To start, we need to download and extract WordPress to our \u201c We will also need to take ownership of the \u201c To achieve all of this, we will run a few commands, just type each line below into the terminal.<\/p>\n\n\n\n cd sudo wget http:\/\/wordpress.org\/latest.tar.gz <\/p>\n\n\n\n sudo tar xzf latest.tar.gz <\/p>\n\n\n\n sudo mv wordpress\/* .\/ <\/p>\n\n\n\n sudo rm -rf wordpress latest.tar.gz <\/p>\n\n\n\n sudo usermod -a -G www-data user <\/p>\n\n\n\n sudo chown -R -f www-data:www-data <\/p>\n\n\n\n Now that WordPress is downloaded and extracted to our Raspberry Pi, we will also need to set up a database within MYSQL for WordPress to store its information.<\/p>\n\n\n\n We need to first use the MySQL command to login. Use the \u201c Note:<\/strong> Replace password<\/strong> with the one you set up for the root user when you setup MySQL<\/p>\n\n\n\n sudo mysql -u root -p<\/p>\n\n\n\n Now that we have logged into the MYSQL server, we can issue a command to create a database for WordPress using this simple line:<\/p>\n\n\n\n CREATE DATABASE wordpress;<\/p>\n\n\n\n Now we will create a separate user for this database, this is far safer from a security perspective.<\/p>\n\n\n\n While still in MYSQL issue the following command:<\/p>\n\n\n\n CREATE USER ‘new_user’@’localhost’ IDENTIFIED BY ‘new_password’;<\/p>\n\n\n\n Note:<\/strong> Make sure you replace 5.<\/strong> Once we have a new user, we will need to give it permissions to manage our new database.<\/p>\n\n\n\n We can do that with the command below, make sure you swap GRANT ALL ON wordpress.* TO ‘new_user’@’localhost’;<\/p>\n\n\n\n Now we have created our database and our user that we want to interact with it. We need to quit out of the MYSQL command interface.<\/p>\n\n\n\n We can do that by pressing CTRL<\/kbd> + D<\/kbd>.<\/p>\n\n\n\n With that all done, we can now finally finish setting up WordPress, we can start this process by going to your Raspberry Pi\u2019s IP address in a web browser.<\/p>\n\n\n\n You will now need to enter various details so that WordPress can connect to the MySQL database we setup.<\/p>\n\n\n\n Assuming you entered all the correct details, you will now be able to press \u201cSubmit<\/strong>\u201d to successfully install the software, follow the rest of the prompts to finalize the installation.<\/p>\n\n\n\n There is quite a bit more to learn about WordPress such as installing a WordPress theme or setting up plugins. Using a Raspberry Pi is a great way to learn all the basics without investing in an expensive web server.<\/p>\n\n\n\n You should now have WordPress setup on the Raspberry Pi and accessible. <\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" For those who do not know,\u00a0WordPress is a content management system\u00a0that is used by over 60 million websites. It is very popular amongst bloggers, but is also used by large websites such as TechCrunch. I currently have WordPress running on my Raspberry Pi to act as a development server as it\u2019s faster than using something […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-2","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/comments?post=2"}],"version-history":[{"count":14,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/pages\/2\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/koner.mywire.org\/index.php\/wp-json\/wp\/v2\/media?parent=2"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\/var\/www\/<\/code>your_domain\/public_html\u201d directory on our Raspberry Pi.<\/p>\n\n\n\n\/var\/www<\/code>\/your_domain\/public_html\u201d folder with the \u201c<\/strong>www-data<\/code>\u201d user and group. Doing this will allow PHP to process WordPress without running into any permission errors.<\/p>\n\n\n\n\/var\/www<\/code>\/your_domain\/public_html<\/p>\n\n\n\n\/var\/www<\/code>\/your_domain\/public_html<\/p>\n\n\n\n\u2013p<\/code>\u201d flag for the password<\/strong> and \u201c\u2013u<\/code>\u201d for the username<\/strong>. Make sure your password is written right next to the \u201c-p<\/code>\u201c tag<\/strong> with no space<\/strong>.<\/p>\n\n\n\nnew_user<\/code> and new_password<\/code> with details of your choosing, just remember what you choose as you will need to know both when we setup WordPress.<\/p>\n\n\n\nnew_user<\/code>, with whatever you entered in the previous step.<\/p>\n\n\n\n<\/figure>\n\n\n\n\n
wordpress<\/code>.<\/li>\n\n\n\n