Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
March 18, 2010, 09:29:51 AM

Pages: [1] 2   Go Down
  Print  
Author Topic: How to connect to MySQL with DreamWeaver  (Read 9087 times)
RATTLESNAKE
Galactic Royalty
*****
Offline Offline

Posts: 383



WWW
« on: February 09, 2004, 01:04:02 AM »

create or open a new PHP File

1) new site

2)Yes I want to use server technology

3)which server technology: PHP MySQL

4)I chose to edit directly on FTP server using FTP

5)enter in your FTP details

ftp.domain.com
folder you want to access = public_html
login = cpanel username
password = cpanel pass

6)test the connection

7)insert your domain url minus the public_html

"http://www.domainname.com"

8)you can enable the check in out if you wish.

9)window>database> click the + and select MySQL connection

10) server details: I will use the ones you provided me with:

connection name = whatever you wish

MySQL Server = localhost

username = cpanelusername_username

password = xxxx

database = cpanelusername_databasename

I then hit test and it connected successfully.
Logged
Trey
Jedi
*****
Offline Offline

Posts: 984



WWW
« Reply #1 on: February 11, 2004, 03:01:34 PM »

Applause
Logged

This space for rent.  Reasonable rates!
Jwink3101
Über Jedi
*****
Offline Offline

Posts: 1838


The one and only.


« Reply #2 on: February 11, 2004, 03:40:39 PM »

IS there a way to specify the info in one file and have about 20 look at that. I know you can specify it once in one file and have it connect many times within that file.
Logged

-Justin Winokur


"The Music is reversible but time is not. Turn Back! Turn Back! Turn Back! Turn Back!" - Intentional backmasking in ELO's Fire On High.
mattl
Intergalactic Cowboy
*****
Offline Offline

Posts: 68

iMac 20" Intel Core D2


WWW
« Reply #3 on: November 28, 2004, 05:06:37 AM »

Hi,
I've done all the stuff below and still can't connect - any ideas?

I get the following error when I test the DB connection:

HTTP Error code 404 File not found.....
1) There is no testing server running on the server machine.

Regards
Matt
Logged

Tristan
Resident Alien
Administrator
Berserker Poster
*****
Offline Offline

Posts: 9237


nihil sunt omnia


WWW
« Reply #4 on: November 28, 2004, 10:07:49 AM »

Hi Matt,

I would suggest looking at this graphical tutorial instead:

http://twebman.lunarpages.com/mm/dw/remotemysql/

Step 1 in it includes setting up the testing server for your already existing and configured site.  Please ensure you do have a php document open at the time you try this, otherwise you will not be able to successfully connect.

Also, please provide your version of Dreamweaver (MX or MX 2004) so we can assist with exact instructions if you run into issues at any step in the process.

I hope this helps.
Logged

thepixellator
Galactic Royalty
*****
Offline Offline

Posts: 340


Be here now.


WWW
« Reply #5 on: April 11, 2005, 12:11:26 PM »

Did Twebman's link change? The above link is showing the following error:
Visitors
We are sorry but this site is experiencing difficulties at this time.
Please return shortly!
Thank you for your patience.


Webmaster - please contact support as soon as possible.
Logged

::Jessica::
Have I reached the party to whom I am speaking?
GMTurner
Berserker Poster
*****
Offline Offline

Posts: 7539



WWW
« Reply #6 on: April 11, 2005, 07:33:58 PM »

There's another thread around here somewhere about the same issue. The response at that time was that a more permanent location for the tutorial was being sought, but I don't think it's been found yet...
Logged

The above post was made at a time when I gave a dang and doesn't necessarily reflect my current views or opinions.

For those no longer with us ... Grr..!!

Turner's Lounge
lexhair
Galactic Royalty
*****
Offline Offline

Posts: 339


« Reply #7 on: August 31, 2006, 12:35:13 PM »

Bump. Getting a dialog box that there's no testing server running.
Logged
lexhair
Galactic Royalty
*****
Offline Offline

Posts: 339


« Reply #8 on: September 03, 2006, 05:54:45 PM »

Bump. Getting a dialog box that there's no testing server running.
Figured it out. Needed to put the root directory in step 7 not /public_html. Should have read it more carefully. Hypno
Logged
mjmco3
Trekkie
**
Offline Offline

Posts: 10


« Reply #9 on: November 24, 2008, 12:10:03 PM »

I am getting the HTTP Error Code 404.  File Not Found.  ....  1)There is no testing server running on the serer machine.  2) The testing server specified for this site does not map to the ..  /_mmServerScripts/MMHTTPDB.php URL.  Verify that the URL Prefix maps to the root of the site.

All of my settings are correct as per the instructions above.  I am running Dreamweaver CS3.  Any help would be greatly appreciated.
Logged
mjmco3
Trekkie
**
Offline Offline

Posts: 10


« Reply #10 on: December 04, 2008, 08:13:05 AM »

are you "put"ting the page or are you previewing the page?
Logged
valdeam
Pong! (the videogame) Master
*****
Offline Offline

Posts: 20



« Reply #11 on: December 10, 2008, 07:45:32 PM »

It works for me.   Confused
Logged

"If you always do what you've always done, how can you ever be any better than you've always been?" 
pendrive
Freedom
Pong! (the videogame) Master
*****
Offline Offline

Posts: 20



« Reply #12 on: December 14, 2008, 03:07:36 PM »

I have been trying to connect via dreamweaver for hours now - and I just happened to stumble on this thread while taking a break. What a great bit of info!!
Logged

Time to live for today!
Mitch
Senior Moderator
Berserker Poster
*****
Online Online

Posts: 12713


Business Development Specialist at Lunarpages


WWW
« Reply #13 on: December 15, 2008, 06:03:25 AM »

Might have to add this one to the wiki (first I got to check and make sure it isn't already there)  Doh  Rofl
Logged

New Lunarpages Contest! - Win a Free Web Site Design! Enter Today!


Mitch the Moderator - follow me @lunarpages on Twitter!
Important Threads: Read This Before Posting! | Lunarforums Rules! | Mitch's Link of the Day!
Also, be sure to check out and subscribe to the Lunartics Blog and the Lunarpages Newsletter !

Need Web Hosting Help? Check out the Lunarpages Web Hosting Wiki. It has tons of tips, tutorials and resources!
fantasylu
Trekkie
**
Offline Offline

Posts: 10


« Reply #14 on: December 25, 2008, 09:55:08 PM »

It's very useful. Thanks very much
Logged
Pages: [1] 2   Go Up
  Print  
 
Jump to: