The fact that I’m typing this means I’ve (somewhat) successfully installed WordPress on my Synology NAS! There are still some things to do (WP/plugin updating doesn’t work yet, haven’t done anything about styling, writing a decent post…) but the base is standing.
All of this should have only taken 5 minutes (as was promised on many places), but took way longer, of course because of my own stupidity. Here’s how it went:
- I downloaded the latest package from the WordPress site
- I unzipped and placed the content in the /web/daan/blog directory on the NAS
- I opened good ol’ Firefox and went to the website
- In a different tab I opened phpMyAdmin and created a database for WordPress
- First question was to give the root user + pass. My reaction: “Hell no, I’ll create a separate user for you, with only access to that table”. (Not that that was needed, WordPress was the only thing running in my database)
- WordPress: “Error establishing a database connection”.
This cannot be good… - Me: “Shit. Maybe I need to change ‘localhost’ to something else? Lets try.”
- WordPress: “Error establishing a database connection”.
- Me: “Dammit. Wait, what port is MySQL running on? Lets check that. Hmm, port 3307. Ah, yes, I have to use localhost:3307, now everything will work”.
- WordPress: “Error establishing a database connection”.
- Me: “Grr. OK, here is the bloody root user, I’ll change the password later”
- WordPress: “Error establishing a database connection”.
- Me: “Aargh!” [starts frantic googling] “Ok, let’s double check if the user rights are set correctly.”
- PHPMyAdmin: “Here are your users:”
-
Users in a new installation of MySQL. Certainly nothing wrong with this… Me: “Hmm, what is this warning about having any user from any location?” [googles some more].
- Google: “Having any user from any location can clash with users that have a stricter definition, but more priviliges”
- Me: “Aha! Bye-bye, any user”
- WordPress: “Welcome to WordPress, please fill in these details to begin!”
- Me: “Woooo!”
Tl;dr: Use the root user when installing WP. And make sure that the users in your DB are set properly, so no “Any” users. And don’t give up.
Next up: set up FTP, so I can update WordPress and install/update new shiny plugins…