Now getting "Access Denied" ??

Report · Sep 29, 2006

"Access Denied. The file may not exist, or there could be a permission problem" - this is the new error I get when trying to connect to my MySQL Database with DWMX. Is there anywhere to specify the database "host name" ? The company I'm setting this up for is using Yahoo for their hosting and Yahoo says the "host name" has to be set to "mysql" ??

Report · Sep 29, 2006

If this helps any- here is what Yahoo has listed for connecting to your database:

You can create custom PHP scripts to access your database. Below are a few lines of PHP code you can use to access your database.

<?php
$link = mysql_connect("mysql", "USERNAME", "PASSWORD");
mysql_select_db("DATABASE");

$query = "SELECT * FROM TABLE";
$result = mysql_query($query);

while ($line = mysql_fetch_array($result))
{
foreach ($line as $value)
{
print "$value\n";
}
}

mysql_close($link);
?>

Please note that you must replace USERNAME and PASSWORD with your database user name and password. You must also replace TABLE and DATABASE with the valid table and database names from your database. The address of the MySQL database server is simply mysql; it is not necessary to include a port number.

The downside is that I'm not sure how to convert the above information into the fields on the window from the Databases Tab in DreamweaverMX 😞

Report · Sep 29, 2006

mommatc wrote:
> Is there anywhere to specify the database "host name" ? The company I'm
> setting this up for is using Yahoo for their hosting and Yahoo says the "host
> name" has to be set to "mysql" ??

You set the hostname when creating a MySQL Connection in Dreamweaver. In
most cases, it's "localhost", but "mysql" is quite reasonable. Your main
problem, though, is the Yahoo hosting. Many people report problems with
connecting to MySQL on Yahoo. I think that local connections on the
remote server work OK, but you will have problems trying to do it remotely.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

Would privileges make a difference? Currently for the username/password I am using the privileges are set to:
Global Privileges: Usage
Grant: No

Report · Sep 29, 2006

mommatc wrote:
> Would privileges make a difference? Currently for the username/password I am using the privileges are set to:
> Global Privileges: Usage
> Grant: No

The only difference that Grant would make is to allow the user to create
a new database or tables. If the DB already exists, you should be able
to connect to it with a Dreamweaver MySQL Connection script. However, as
I said before, I believe there are problems in trying to use Yahoo
hosting as a remote testing server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

"You set the hostname when creating a MySQL Connection in Dreamweaver."

Where do I do this? Is this on the window that you get if you click the "plus sign" from the "Databases" tab? If so - which field in that window do they want the hostname in?

Thank you 🙂

Report · Sep 29, 2006

mommatc wrote:
> Is this on the window that you get if you click the "plus
> sign" from the "Databases" tab? If so - which field in that window do they
> want the hostname in?

Yes.

MySQL Server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

Should you be able to rectify this with a local server?

You might also be able to contact Yahoo (but I kinda doubt this) and have
them add your IP address to allow you to connect.

jon

"David Powers" <david@example.com> wrote in message
news:efjfh4$3mh$1@forums.macromedia.com...
> mommatc wrote:
>> Is there anywhere to specify the database "host name" ? The company I'm
>> setting this up for is using Yahoo for their hosting and Yahoo says the
>> "host name" has to be set to "mysql" ??
>
> You set the hostname when creating a MySQL Connection in Dreamweaver. In
> most cases, it's "localhost", but "mysql" is quite reasonable. Your main
> problem, though, is the Yahoo hosting. Many people report problems with
> connecting to MySQL on Yahoo. I think that local connections on the remote
> server work OK, but you will have problems trying to do it remotely.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

mommatc wrote:
> Is this on the window that you get if you click the "plus
> sign" from the "Databases" tab? If so - which field in that window do they
> want the hostname in?

Yes.

MySQL Server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

Should you be able to rectify this with a local server?

You might also be able to contact Yahoo (but I kinda doubt this) and have
them add your IP address to allow you to connect.

jon

"David Powers" <david@example.com> wrote in message
news:efjfh4$3mh$1@forums.macromedia.com...
> mommatc wrote:
>> Is there anywhere to specify the database "host name" ? The company I'm
>> setting this up for is using Yahoo for their hosting and Yahoo says the
>> "host name" has to be set to "mysql" ??
>
> You set the hostname when creating a MySQL Connection in Dreamweaver. In
> most cases, it's "localhost", but "mysql" is quite reasonable. Your main
> problem, though, is the Yahoo hosting. Many people report problems with
> connecting to MySQL on Yahoo. I think that local connections on the remote
> server work OK, but you will have problems trying to do it remotely.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

mommatc wrote:
> Is this on the window that you get if you click the "plus
> sign" from the "Databases" tab? If so - which field in that window do they
> want the hostname in?

Yes.

MySQL Server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

Should you be able to rectify this with a local server?

You might also be able to contact Yahoo (but I kinda doubt this) and have
them add your IP address to allow you to connect.

jon

"David Powers" <david@example.com> wrote in message
news:efjfh4$3mh$1@forums.macromedia.com...
> mommatc wrote:
>> Is there anywhere to specify the database "host name" ? The company I'm
>> setting this up for is using Yahoo for their hosting and Yahoo says the
>> "host name" has to be set to "mysql" ??
>
> You set the hostname when creating a MySQL Connection in Dreamweaver. In
> most cases, it's "localhost", but "mysql" is quite reasonable. Your main
> problem, though, is the Yahoo hosting. Many people report problems with
> connecting to MySQL on Yahoo. I think that local connections on the remote
> server work OK, but you will have problems trying to do it remotely.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

mommatc wrote:
> Is this on the window that you get if you click the "plus
> sign" from the "Databases" tab? If so - which field in that window do they
> want the hostname in?

Yes.

MySQL Server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

Should you be able to rectify this with a local server?

You might also be able to contact Yahoo (but I kinda doubt this) and have
them add your IP address to allow you to connect.

jon

"David Powers" <david@example.com> wrote in message
news:efjfh4$3mh$1@forums.macromedia.com...
> mommatc wrote:
>> Is there anywhere to specify the database "host name" ? The company I'm
>> setting this up for is using Yahoo for their hosting and Yahoo says the
>> "host name" has to be set to "mysql" ??
>
> You set the hostname when creating a MySQL Connection in Dreamweaver. In
> most cases, it's "localhost", but "mysql" is quite reasonable. Your main
> problem, though, is the Yahoo hosting. Many people report problems with
> connecting to MySQL on Yahoo. I think that local connections on the remote
> server work OK, but you will have problems trying to do it remotely.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

mommatc wrote:
> Is this on the window that you get if you click the "plus
> sign" from the "Databases" tab? If so - which field in that window do they
> want the hostname in?

Yes.

MySQL Server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

Should you be able to rectify this with a local server?

You might also be able to contact Yahoo (but I kinda doubt this) and have
them add your IP address to allow you to connect.

jon

"David Powers" <david@example.com> wrote in message
news:efjfh4$3mh$1@forums.macromedia.com...
> mommatc wrote:
>> Is there anywhere to specify the database "host name" ? The company I'm
>> setting this up for is using Yahoo for their hosting and Yahoo says the
>> "host name" has to be set to "mysql" ??
>
> You set the hostname when creating a MySQL Connection in Dreamweaver. In
> most cases, it's "localhost", but "mysql" is quite reasonable. Your main
> problem, though, is the Yahoo hosting. Many people report problems with
> connecting to MySQL on Yahoo. I think that local connections on the remote
> server work OK, but you will have problems trying to do it remotely.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

mommatc wrote:
> Is this on the window that you get if you click the "plus
> sign" from the "Databases" tab? If so - which field in that window do they
> want the hostname in?

Yes.

MySQL Server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

Should you be able to rectify this with a local server?

You might also be able to contact Yahoo (but I kinda doubt this) and have
them add your IP address to allow you to connect.

jon

"David Powers" <david@example.com> wrote in message
news:efjfh4$3mh$1@forums.macromedia.com...
> mommatc wrote:
>> Is there anywhere to specify the database "host name" ? The company I'm
>> setting this up for is using Yahoo for their hosting and Yahoo says the
>> "host name" has to be set to "mysql" ??
>
> You set the hostname when creating a MySQL Connection in Dreamweaver. In
> most cases, it's "localhost", but "mysql" is quite reasonable. Your main
> problem, though, is the Yahoo hosting. Many people report problems with
> connecting to MySQL on Yahoo. I think that local connections on the remote
> server work OK, but you will have problems trying to do it remotely.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

mommatc wrote:
> Is this on the window that you get if you click the "plus
> sign" from the "Databases" tab? If so - which field in that window do they
> want the hostname in?

Yes.

MySQL Server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

Should you be able to rectify this with a local server?

You might also be able to contact Yahoo (but I kinda doubt this) and have
them add your IP address to allow you to connect.

jon

"David Powers" <david@example.com> wrote in message
news:efjfh4$3mh$1@forums.macromedia.com...
> mommatc wrote:
>> Is there anywhere to specify the database "host name" ? The company I'm
>> setting this up for is using Yahoo for their hosting and Yahoo says the
>> "host name" has to be set to "mysql" ??
>
> You set the hostname when creating a MySQL Connection in Dreamweaver. In
> most cases, it's "localhost", but "mysql" is quite reasonable. Your main
> problem, though, is the Yahoo hosting. Many people report problems with
> connecting to MySQL on Yahoo. I think that local connections on the remote
> server work OK, but you will have problems trying to do it remotely.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

mommatc wrote:
> Is this on the window that you get if you click the "plus
> sign" from the "Databases" tab? If so - which field in that window do they
> want the hostname in?

Yes.

MySQL Server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

Should you be able to rectify this with a local server?

You might also be able to contact Yahoo (but I kinda doubt this) and have
them add your IP address to allow you to connect.

jon

"David Powers" <david@example.com> wrote in message
news:efjfh4$3mh$1@forums.macromedia.com...
> mommatc wrote:
>> Is there anywhere to specify the database "host name" ? The company I'm
>> setting this up for is using Yahoo for their hosting and Yahoo says the
>> "host name" has to be set to "mysql" ??
>
> You set the hostname when creating a MySQL Connection in Dreamweaver. In
> most cases, it's "localhost", but "mysql" is quite reasonable. Your main
> problem, though, is the Yahoo hosting. Many people report problems with
> connecting to MySQL on Yahoo. I think that local connections on the remote
> server work OK, but you will have problems trying to do it remotely.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 29, 2006

mommatc wrote:
> Is this on the window that you get if you click the "plus
> sign" from the "Databases" tab? If so - which field in that window do they
> want the hostname in?

Yes.

MySQL Server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Sep 29, 2006

Should you be able to rectify this with a local server?

You might also be able to contact Yahoo (but I kinda doubt this) and have
them add your IP address to allow you to connect.

jon

"David Powers" <david@example.com> wrote in message
news:efjfh4$3mh$1@forums.macromedia.com...
> mommatc wrote:
>> Is there anywhere to specify the database "host name" ? The company I'm
>> setting this up for is using Yahoo for their hosting and Yahoo says the
>> "host name" has to be set to "mysql" ??
>
> You set the hostname when creating a MySQL Connection in Dreamweaver. In
> most cases, it's "localhost", but "mysql" is quite reasonable. Your main
> problem, though, is the Yahoo hosting. Many people report problems with
> connecting to MySQL on Yahoo. I think that local connections on the remote
> server work OK, but you will have problems trying to do it remotely.
>
> --
> David Powers
> Adobe Community Expert
> Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
> http://foundationphp.com/

Report · Sep 30, 2006

mommatc wrote:
> Is this on the window that you get if you click the "plus
> sign" from the "Databases" tab? If so - which field in that window do they
> want the hostname in?

Yes.

MySQL Server.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/