I created a database in PHPMyAdmin for my site and when I try to connect to the
DB from Dreamweaver I receive the error message # 2002

"Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'(s)"

Does anyone have any idea how to fix that problem? I was able to get it works
before but since I reformat my harddrive I keep getting this error message.

Can anyone help me please? I'm running Win XP Pro SP2

chunkeung wrote:
> "Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock'(s)"

That's a message that should appear only on a Mac or Linux.

> Can anyone help me please? I'm running Win XP Pro SP2

If you're running XP and using a local testing environment, something is
seriously wrong. Your setup seems to have an OS identity problem.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

chunkeung wrote:
> "Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock'(s)"

That's a message that should appear only on a Mac or Linux.

> Can anyone help me please? I'm running Win XP Pro SP2

If you're running XP and using a local testing environment, something is
seriously wrong. Your setup seems to have an OS identity problem.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

ok now another message came up
HTTP Error Code 404 file not found.

1) there's no testing server running on the server machine
2) the testing server specified for this site does not map to the
http://mysite.com/public_html/_mmSer...s/MMHTTPDB.php url. Verify that
the URL prefix maps to the root of the site.


the _mmServerScripts/MMHTTPDB.php is on the server as well as in my local
machine. What is the problem? It had worked previously. I really don't
understand. Can someone help me please??

ok now another message came up
HTTP Error Code 404 file not found.

1) there's no testing server running on the server machine
2) the testing server specified for this site does not map to the
http://mysite.com/public_html/_mmSer...s/MMHTTPDB.php url. Verify that
the URL prefix maps to the root of the site.


the _mmServerScripts/MMHTTPDB.php is on the server as well as in my local
machine. What is the problem? It had worked previously. I really don't
understand. Can someone help me please??

chunkeung wrote:
> 2) the testing server specified for this site does not map to the
> http://mysite.com/public_html/_mmSer...s/MMHTTPDB.php url. Verify that
> the URL prefix maps to the root of the site.

The URL prefix in the testing server definition should be this:

http://mysite.com/

NOT this:

http://mysite.com/public_html/

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

chunkeung wrote:
> 2) the testing server specified for this site does not map to the
> http://mysite.com/public_html/_mmSer...s/MMHTTPDB.php url. Verify that
> the URL prefix maps to the root of the site.

The URL prefix in the testing server definition should be this:

http://mysite.com/

NOT this:

http://mysite.com/public_html/

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

ok this works now, thanks

but this error # 2002 is still bugging me. I noticed this though.

As I am hosting 2 sites at different hosting server. I tried to connect to my
MySQL database in the other site and it works fine. When I login into
PHPMyAdmin I see that the Server is "Localhost via UNIX socket" so I put that
into my setting in dreamweaver for the "MySQL server" but on the hosting that
giving me that #2002 error message their Server is "127.0.0.1 via TCP/IP" and I
tried to put in 127.0.0.1 instead of localhost but it still doesn't work and
gives me this error message. I have asked them to upgrade me to php version 5,
do you think this will help solve the issue? or is it because it is hosting in
a windows server?

ok this works now, thanks

but this error # 2002 is still bugging me. I noticed this though.

As I am hosting 2 sites at different hosting server. I tried to connect to my
MySQL database in the other site and it works fine. When I login into
PHPMyAdmin I see that the Server is "Localhost via UNIX socket" so I put that
into my setting in dreamweaver for the "MySQL server" but on the hosting that
giving me that #2002 error message their Server is "127.0.0.1 via TCP/IP" and I
tried to put in 127.0.0.1 instead of localhost but it still doesn't work and
gives me this error message. I have asked them to upgrade me to php version 5,
do you think this will help solve the issue? or is it because it is hosting in
a windows server?

chunkeung wrote:
> When I login into
> PHPMyAdmin I see that the Server is "Localhost via UNIX socket" so I put that
> into my setting in dreamweaver for the "MySQL server" but on the hosting that
> giving me that #2002 error message their Server is "127.0.0.1 via TCP/IP" and I
> tried to put in 127.0.0.1 instead of localhost but it still doesn't work and
> gives me this error message.

localhost and 127.0.0.1 are the same thing. All you need is "localhost"
or "127.0.0.1" (without the quotes). The "via UNIX socket" and "via
TCP/IP" are simply descriptions of the type of connection. They are NOT
part of the server address.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/