Cheers pinkpoliceman! I had a feeling it must be possible.
I've asked the hosting company to allow access for the for the websites IP address and domain and have also updated the details in the _config.php, but when installing silverstripe (mydomain.com/silverstripe/install.php) and after re-checking the requirements I am presented with a blank white page that doesn't do anything.
I'd just like to check that the 'localhost' line I need to change is:
no not that part here is an example of the _config.php in the mysite folder.
$project = 'mysite';
$databaseConfig = array(
"type" => "MySQLDatabase",
"server" => "yourdomain.com",
"username" => "your_username_for_that_db",
"password" => "your_password_for_that_user",
"database" => "your_MySQL_DB",
// Sites running on the following servers will be
// run in development mode. See
// for a description of what dev mode does.
// This line set's the current theme. More themes can be
// downloaded from http://www.silverstripe.com/themes/
When you installed SS, you should have entered the details as above, (if that corresponds I don't the install screen to look at right now), the part you said just leave as is. Im not sure if you need the 'www.' when you enter the server address I haven't so far.
This includes some debug stuff which i find helpful.
I'm still unable to get Silverstripe to install and connect to the remote MySQL database, but I think it could be something to do with the hosting company not adding the IP address and domain name properly. I will check with them once they're back from holidays.
Just to double check - the database server name I'm connecting to is 'mysql.designalt.co.nz' and the database name is 'jacksmachinery'. I have connected to this before perfectly using a silverstripe installation that is hosted on the same domain (designalt.co.nz). Perhaps I should make another MySQL database alongside the 'jacksmachinery' one?