Dreamweaver and remote mysql access

hello, will I be able to use Dreamweaver to acess my mysql database remotely & use as a testing server?

[Stef]

Hi there,

yes this is possible, no problem.

Bye,
Stef.

[lloydcodrington]

Hi Stef,
Please can I ask you for some assistance. I have just purchased a reseller package and am setting up my new website and also that of a couple of clients. However please can you tell me how I go about connecting to a database I have created. I am using Dreamweaver and to tell you the truth I have not got a clue about connecting to databases.

Originally Posted by lloydcodrington

Hi Stef,
Please can I ask you for some assistance. I have just purchased a reseller package and am setting up my new website and also that of a couple of clients. However please can you tell me how I go about connecting to a database I have created. I am using Dreamweaver and to tell you the truth I have not got a clue about connecting to databases.

You would first go into your cpanel. And then to mysql management.
In there there is an option called Access Hosts and a box to add a line into it. You will want to add either your IP address to your computer, or a % to allow any access. Then you connect to the database with your username and password from dreamweaver or whichever program you are using to do so.

[lloydcodrington]

Thanks for the reply but could I also trouble you for some more info? If I create a mysql database locally, how do I go about uploading that database to my site? Where do I store it? Do I have to create it first in the mssql c/panel and then upload?

[esl]

If you mean restoring a database you would first create the MySQL database and then restore the backup via the backup icon in cPanel.

I hope this helps.

Have a great day,
Evan

[lloydcodrington]

Hi els,
Thanks for taking the time to assist. But can I clarify something?

No what I meant was I am creating a database from scratch and if I do so on my local system, how do I upload that to the site? As far as I am aware it is not the same as uploading html pages via Dreamweaver!

[Serra]

You can't really upload a database. Use the MySQL tab to create the database and then use myPHPAdmin to create the tables and upload the data.


You can't really create them locally and then upload them.

This isn't really the right forum to be asking these types of questions. All of this information is available online if you Google it.

[Stef]

Originally Posted by lloydcodrington

Hi Stef,
Please can I ask you for some assistance. I have just purchased a reseller package and am setting up my new website and also that of a couple of clients. However please can you tell me how I go about connecting to a database I have created. I am using Dreamweaver and to tell you the truth I have not got a clue about connecting to databases.

Hi lloyd,

first you have to create the databases on your HG server via cPanel and then add your own system to the Access Hosts, as the great GatorJay explained above. Then you can access those databases from within DreamWeaver on your local system.
Now, I've described this last step in this thread and there's also more info on the other steps in this thread.
Can you read through them and see if this helps?

Stef.

Originally Posted by Stef

Hi lloyd,

first you have to create the databases on your HG server via cPanel and then add your own system to the Access Hosts, as the great GatorJay explained above. Then you can access those databases from within DreamWeaver on your local system.
Now, I've described this last step in this thread and there's also more info on the other steps in this thread.
Can you read through them and see if this helps?

Stef.

Great threads there, and its great to be great!

[MachineDog]

Originally Posted by lloydcodrington

Hi els,
Thanks for taking the time to assist. But can I clarify something?

No what I meant was I am creating a database from scratch and if I do so on my local system, how do I upload that to the site? As far as I am aware it is not the same as uploading html pages via Dreamweaver!

You can't just "upload" a SQL DB because it's not a local file of sorts. And you'd need root access to create DataBases aswell, which means you have to create them in cPanel so that cPanel can connect via root and setup the DB. Same reason you can't create DBs in phpMyAdmin. ;D

[lloydcodrington]

Hi Stef and Everyone that has contributed.
I am sure Stef that amongst what you have typed and the links you have provided I will get the connection and testing server issue sorted out.

Thanks mate.
Lloyd

[stevie]

A great utility I've found for working remotely with MySQL databases is Navicat. It's very intuitive, I've not had to look at the help file for it once since installing I got a free copy of Navicat 2004 with a magazine here in the UK back in september, they may possibly have been giving away copies with mags in other countries too, try checking the back issues of a few publications.
To answer the original question using navicat: You could back up your local database, create an empty database on your server, then point navicat at the new remote database and do a restore, this should give you a copy.

[Stef]

Originally Posted by lloydcodrington

Hi Stef and Everyone that has contributed.
I am sure Stef that amongst what you have typed and the links you have provided I will get the connection and testing server issue sorted out.

You're welcome Lloyd. If there are still probs, just let us know .

[Serra]

Originally Posted by stevie

A great utility I've found for working remotely with MySQL databases is Navicat.

MySQL Control Center is also a good remote utility. Very easy to work with and very powerful.

[crash]

I'm having an issue with DW and MySQL - I can connect fine, but it won't display my tables. I have created only one table, via the PHPMyAdmin on the CP, but cannot seem to read the database in DW. Everything in my settings is set for root.

I attempted to look at the two links Steff (I think it was) posted in regards to this, but was told both times I did not have access rights. Any ideas on this?

Thanks,

Jon

[ltrump]

I too am getting the no access rights problem with both of those links.....

[Serra]

Must be super secret, because I can't see them either.

[crash]

I'm reposting text here so we don't all have to email and get temporary access. Reposting relevant information from two threads on shared server forums:


Post 1308 - This is the meat and potatoes of the post. These are quick instructions for the info you need to to have entered.


I think there still must be some misconfiguration in your DW settings. I tested this and it works fine for me.
My site definition for 'testing server' has these settings (fake values):
Quote:
Server model: PHP MySQL
Access: FTP
FTP Host: www.domain.com
Host Dir: <empty>
Login: username@domain.com (or an ftp user you created)
URL Prefix: http://www.domain.com/
Fill out the correct values and press 'Test' to verify this is OK.

The MySQL connection settings are like this:
Quote:
Connection name: test1
MySQL server: localhost
User name: username_dbuser
Password: <the correct passwd as defined for this dbuser>
Database: username_db
Again, press the 'test' button after filling out the correct values.

Also, try to add this in your access host list (just to be sure): %.comcast.net
You can always remove this afterwards when things are working.

Good luck,
Stef.


Second post (which is also referenced from post 1308)


Post 1029 - Relevant Info


REPOST:
This is what i had to do to make it work.... there may be a set or two extra, cause i don't know if they fix problems i did not know about. My domain is andism, so just replace your domain.

1- hostgator,by default, does not allow outside connections to mysql. The port is open, but you need to add an access host like %your-isp.com to your mysql page.

2- your username and database name need to include the name you created in the control pannels. So if you are abc123.com, your mysql user is user1, and your database is data1.... your username will be abc123_user1 and database will be abc123_data1

3- Now to config Dreamweaver, open up your site and go to advanced tab. Look under local info the http Address needs to be your site... for me, i need to use http://ip address/~andism/ because my nameservers not done updating.

4- Still in Dreamweaver look at Remote info, the host directory needs to be /public_html/ ... yes include the other normal info

5- Now look at the testing server in Dreamweaver, Server Model PHP MySql, Host Directory /public_html/, and the URL prefix http://ip address/~andism/ ... yes include the other normal info

6- Now its time to setup the MySql Connection. The MySql server is localhost, your username will be abc123_user1 and database will be abc123_data1... the info from step two.... yes include the other normal info

END REPOST

[khepri]

Originally Posted by GatorJay

Great threads there, and its great to be great!

I just wanna say...you guys are great!

[khepri]

Originally Posted by Serra

You can't really upload a database. Use the MySQL tab to create the database and then use myPHPAdmin to create the tables and upload the data.


You can't really create them locally and then upload them.

This isn't really the right forum to be asking these types of questions. All of this information is available online if you Google it.

What's the fun it that?....

Anyway...leaving Dreamweaver aside for a minute...if he made his DB locally and had phpmyadmin local also...would he not be able to export an sql file locally and then upload it via remote phpmyadmin and it would create the tables etc and enter the info (ala ESL's post above)?

[Serra]

Originally Posted by khepri

if he made his DB locally and had phpmyadmin local also...would he not be able to export an sql file locally and then upload it via remote phpmyadmin and it would create the tables etc and enter the info (ala ESL's post above)?

Yes. People get confused because an Access database could be uploaded, like just sent up to the server. A mySQL database needs to be exported or transfered, but not uploaded.

If someone is going to do that, it is far easier to use an external program like mySQL CC to do the export and import. I find it much easier to work with.

[garfinkel]

Hey so ive been following the directions exactly but still produce the following error

"HTTP Error Code 404 File Not Found. Here are the possible reasons for this problem:

1) There is no testing server running on the server machine.

2) the testing server specified for this site does not map to the http://mydomain.com/_mmServerScripts/MMHTTPDB.php URL. Verify that the URL Prefix maps to the root of the site."

I replace my domain with mydomain.com btw & cpanel login with cpanelusername

If someone could help me with my problem that would be great. My Record Set is.

Connection Name: test
MySQL Server: localhost
User Name: cpanelusername_dbuser
Password: **********
Database: cpanelusername_db

Test = Error message above

My Testing Server is:

Server Model: PHP MySQL
Access: FTP
FTP host: www.mydomain.com
Host directory: <empty>
Login: Cpanelusername
Password: *******

Test = Successful

[gwyneth]

Several possibilities.

Did you create the database in cPanel? If so, did you create the user? And most important, if so to both, did you assign that user to that database?

Also, the ftp server isn't prepended by www (though it says the test is successful)--try ftp.mydomain.com.

PS: I just noticed that the original thread is almost three years old. garfinkel, try those changes and if you're still having problems contact support or wait until you're activated and post in the shared category.

[garfinkel]

Yes i have created a database with linked user and ill try it on the shared category when my accounts activated thanks anyway

I tried what you said it didnt change anything sadly all tests came up the same.