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

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.

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

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

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

  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.