It's slightly confusing - although mostly because it's been
doing my head in for so long.
Looking in the file manager, the tree structure starts off at
the highest level with :
/home/abcdefg/ - where abcdefg is my username for my hosting
account, and so my log in name for connecting.
Within there, there are folders including :
_mmServerScripts - this one is empty
public_html - This is what I have as the host directory in
DWs site manager for the site.
It also includes a _mmServerScripts sub folder - this one
containing :
MMHTTPDB.php - a blank file
mysql.php - connection type info, but nothing particular, eg
code starting :
<?php
class MySqlConnection
{
var $isOpen;
var $hostname;
var $database;
var $username;
var $password;
var $timeout;
var $connectionId;
function MySqlConnection($ConnectionString, $Timeout, $Host,
$DB, $UID, $Pwd)
{
$this->isOpen = false;
$this->timeout = $Timeout;
if( $Host ) {
$this->hostname = $Host;
}
elseif( ereg("host=([^;]+);", $ConnectionString, $ret) ) {
$this->hostname = $ret[1];
}
if( $DB ) {
$this->database = $DB;
}
elseif( ereg("db=([^;]+);", $ConnectionString, $ret) ) {
$this->database = $ret[1];
}
if( $UID ) {
$this->username = $UID;
}
elseif( ereg("uid=([^;]+);", $ConnectionString, $ret) ) {
$this->username = $ret[1];
}
if( $Pwd ) {
$this->password = $Pwd;
}
elseif( ereg("pwd=([^;]+);", $ConnectionString, $ret) ) {
$this->password = $ret[1];
}
}
function Open()
{
// if ($this->connectionId =
mysql_connect($this->hostname, $this->username,
$this->password) or die(mysql_error()))
if ($this->connectionId =
mysql_connect($this->hostname, $this->username,
$this->password))
{
$this->isOpen = ($this->database == "") ? true :
mysql_select_db($this->database, $this->connectionId);
}
else
{
------
What exactly is Dreamweaver trying to do - create those two
files above, with the connection details, and upload them to the
correct folder on the server?
With permissions, where should I be looking to set these?
I've been on to my host's support, and they've been talking
about IP addresses and entering them so that I can connect remotely
etc?
The really annoying thing is that a site I did previously
worked fine, without - I'm pretty sure - any of this IP stuff, ie I
just had 'localhost' as the mySQL server.
3
Replies
AdChoices