Skip to main content
R
roberttraum
Participating Frequently
August 23, 2006
Question

Need Help Getting Dreamweaver to find MySQL (Macintosh)

  • August 23, 2006
  • 1 reply
  • 466 views
I've been trying for a week to get Dreamweaver 8 at my job to talk to MySQL (NB: I'm experienced with Dreamweaver, but a newbie to MySQL -- I'm trying to get started…but can't!).

LOCAL INFO:

Local Root Folder: Macintosh HD:Users:robert:Sites:testy:
HTTP Address: Not required

REMOTE INFO:

Access: None

TESTING SERVER

Server Model: PHP MySQL
Access: Local/Network
Testing server folder: Macintosh HD:Users:robert:Sites:testy:
URL Prefix: http://localhost/~robert/testy/

MySQL is running, as per preferences pane.

I've got personal web sharing running as per pref pane.

When I tried the setup you suggested I got a different error:

"The URL prefix http://localhost/~robert/testy/ for this site's testing server could not be resolved. This could be due to several reasons:
1. You have specified a local root folder that doest not fall under the web server root folder
2. There is not web server running on the URL.
3. There is a web server running but no virtual web folder has been mapped to this prefix."

I tried then setting it up to run at http://localhost/~robert/, just to see if it couldn't find the folder "testy" -- but same story.

I then tried to set things up using DW's basic setup -- when I got to "What URL would you like to use to browse to the root of your site?", and I entered " http://localhost/~robert/testy/", and I tried to test, I got the error "Dreamweaver cannot use the prefix you entered to test live data...(HTTP Error: 0)"

I've also heard (somewhere in my meanderings) that there may be some problem in 10.3.9 or some such using "localhost", so I tried substituing "127.0.0.1" -- same results…

So, I'm still sitting in idle. Any help much appreciated.
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
August 23, 2006
roberttraum wrote:
> I've been trying for a week to get Dreamweaver 8 at my job to talk to MySQL
> (NB: I'm experienced with Dreamweaver, but a newbie to MySQL -- I'm trying to
> get started?but can't!).

All your settings seem correct, but you have never answered the
question: is there a folder called _mmServerScripts in Macintosh
HD:Users:robert:Sites:testy:? If there is, it should work.

However, there is a possibility that there's a problem with the files in
that folder. Select the Site menu, then choose Advanced, followed by
Remove Connection Scripts. Once the connection scripts have been
removed, try creating a MySQL connection again.

Another possibility: you haven't created a user account on MySQL, or
you're using the wrong username and password.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/
R
roberttraumAuthor
Participating Frequently
August 24, 2006


quote:
All your settings seem correct, but you have never answered the
question: is there a folder called _mmServerScripts in Macintosh
HD:Users:robert:Sites:testy:? If there is, it should work.


Yes, there is. I removed connection scripts and tried again.

There is some weird thing going on here now --

In the database panel, it still says I need to set up a testing server, even when I have one setup fine (as per below).

If I go back to the "basic" wizard for setup, and get to the page with the URL for the testing server, and enter

http://localhost/~robert/testy/

A dialog pops up which says "Dreamweaver cannot use the prefix you entered to display live data...HTTP Error(0)"

I don't think it's a MySQL user name problem -- why can't it even see the testing server. All settings as per earlier message.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices