I've been doing some work on the Wordpress setup process, as I've botched it up a few times now, but luckily tagadab easily allow me to re-image my server which only takes about 5 minutes.
I've now switched to using a Ubuntu 12-04 LTS version (64 bit) instead of Debian, and this is easy to select.
I'm not a total fan of the command line, but I can see it is needed and it is handy to know how to use it.
I like the Nautilus SSH "connect to server" facility, but there were a few hiccups here with "SSH known hosts" - I had to delete the /.ssh/known_hosts file in my home directory for it to work.
I downloaded the latest Wordpress install file and unzipped it on my local PC, and then copied it over to /var/www/ on my remote server using Nautilus SSH client.
I then installed webmin on my remote server using this handy tutorial:
and the installed phpmyadmin using this tutorial:
these are 2 very handy GUI tools that mean I can do things without command line only.
Webmin is handy for enabling "mod rewrite" on apache, as this allows me to use "pretty" permalinks.
Webmin also allows me to change the password of the administrative user, as when I was installing phpmyadmin I was asked for the password and I did not know what it was! At first I got the password wrong and phpmyadmin sort of worked BUT there are error messages displayed at the bottom of each screen - very annoying.
I used phpmyadmin to backup and restore my sql wordpress database. When restoring my sql database I got an error as I had not flushed out the demo data from the database prior to doing a restore, so dropping the contents of all the tables in the wordpress database prior to doing a restore avoided any errors.