close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Where do I find out MySQL server for connecting Dreamweaver to database?

Thread began 1/14/2013 4:26 pm by Mark_Rinella291330 | Last modified 1/21/2013 3:54 pm by Jason Byrnes | 1355 views | 5 replies |

Mark_Rinella291330

Where do I find out MySQL server for connecting Dreamweaver to database?

Where do I find out MySQL server for connecting Dreamweaver to database?

Hello,

Thanks for your past customer support! I have been using WebAssist products since 2008 and you have been right on and helpful!

I cannot connect the CMS to Dreamweaver so that changes that I make in the CMS show up in Dreamweaver.

I am missing some information.

Dreamweaver asks for MySQL server and Connection name.

I assume connection name is any name I want, but I cannot figure out what information is necessary for MySQL server.

I spent 30 minutes on the phone with 1 and 1 hosting and they could figure out how to make this connection work.

Please and thanks for helping.

Those videos you all do are very helpful, but sometimes they need to be a little easier and simple for people like me that have very little experience using a database.

In one video, the girl mentions something like "I use Php My Admin to manage my databases, but you can use whatever you want".....

When you do an internet search to learn about Php Admin, it is impossible to figure out what she was talking about.

Some of us are just not as tech savy as you talented folks at WebAsssist.

Thanks again!

Mark

Sign in to reply to this post

Jason ByrnesWebAssist

any information about connecting to the MySQL Server will be available in your Hosts control panel.

the key to making DW connect to the server is setting up the DReamweaver Site correctly.

in the Dreamweaver site, you nee to define a testing server, the testing server connection is what DW will use for making a database connection, if you trying to connect to the remote MySQL server, then the DW testing server needs to be configured to connect to your site using FTP. make sure that the HTTP Prefix address for the testing server is a valid address t your site as well.

once the site is properly defined, you can create the Data Base connection. if you log into your sites control panel, you should be able to find the MySQL Address to use for the database connection.

Sign in to reply to this post

Mark_Rinella291330

Thank you and I have never set up a testing server

Thanks for your message.

I have never set up a testing server. I remember trying to follow a tutorial some time back setting XAMP or something like that.

I will review your FAQ for any helpful information.

Thanks again and take care,

Mark

Sign in to reply to this post

Jason ByrnesWebAssist

I'm not saying that you need to set up a testing server like XAMPP or WAMPP on your system, you are misunderstanding me.

When setting up your Dreamweaver site, there are 3 main sections:

1) Local Information
2) Connection to the Testing server
3) Connection to the Remote server

When you create a database connection in Dreamweaver and test it, Dreamweaver connects to the testing server that you defined. also if you use live view, it uses the testing server connection.

The testing server connection in Dreamweaver is the key to using it for dynamic development.

NOTE: this is just a connection to _a_ server, any server. for your uses, you want to use the connection settings for connecting to the remote server as the settings for the testing. you are trying to use the Remote server as both the live and the testing server

Sign in to reply to this post

Mark_Rinella291330

Dude, you are a Genius

Thanks Jason!

Not sure what you did or said, but it works!

Sometimes us neebies need to have things explained more than once and in more than one way.

I was able to connect a database via CS6 and I think I may actually have a working CMS. After starting and stopping many times since PowerCMS came out a few years ago. I would get frustrated and would give up and expected that either technology would make it easier or I would get a little smarter. I am happy that technology has made it easier.

Are you able to please answer two more questions on this same topic of databases?

Can/should I have more than one database for the same domain?
One for PowerGallery and One for Design Extender?

Is it possible to remove the CMS function from a page or pages and not mess up the content or the CMS?

I am trying to get my knowledge and skill set up to maximize more of your products and functions, but you all are moving pretty quick.

A few suggestions for additional videos:

Create a video that Website Designers can use to Explain and help us Sell the CMS ability and how to to do for our clients.

Google Apps has some great, simple, short, videos that help clients understand the power a little better.

A two minute video to show the end user how easy it is, would allow Website Designers to show a client the video and it would help us use PowrCMS more.

Concrete5 and a few other CMS people have videos that can be appealing to the end user.

On a related note:

It would help if there was a little more information, maybe 30 seconds inserted in the video, that explained how to set up a database connection.

At the 11:31 point in the one video on setting up a CMS using Design Extender, the narrator does a great job, except she zips through setting up a database connection, and that is where a little more information on how to set up a database connection would really help!

Thanks for your help again!

I am going to try to set up a second CMS this week.

Have a great week!

Mark

Sign in to reply to this post

Jason ByrnesWebAssist

  Can/should I have more than one database for the same domain?
One for PowerGallery and One for Design Extender?  



most hosts will allow you to create multiple databases for your hosting package. yes, you should use seperate database for power gallery and power cms

  Is it possible to remove the CMS function from a page or pages and not mess up the content or the CMS?  



yes, you can remove content from the page without effecting the content in the database.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...