close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Access mySQL tables through dreamweaver?

Thread began 1/27/2012 6:14 pm by elevy388997 | Last modified 2/02/2012 9:33 am by Jason Byrnes | 725 views | 3 replies |

elevy388997Beta Tester

Access mySQL tables through dreamweaver?

Hello, i need to change some tables in the CMS but I don't have access to any client (like cPanel) like I normally do. The website is hosted by an educational source and it took days to get them to setup the mySQL databases in the first place (of which i have the username and password).

How can I access the mySQL database/tables without having direct access to it through something like cPanel?

Sign in to reply to this post

Jason ByrnesWebAssist

the only way to update the table structure within Dreamweaver would be to write the Alter Table SQL command by hand, then run that SQL in a dreamweaver recordset behavior by clicking the test button.

other than that, you will need to have a MySQL GUI Client and connect it to the DB server. normally in a cpanel, they have PHPMyAdmin as the GUI Client. but you can use Sequel Pro, or Sequel Yog as well.

Sign in to reply to this post

elevy388997Beta Tester

I dont have direct access to the database. I had to tell them to create it with the username and password i needed. So as long as I have the ip and the user and pass i can use a third party client (one of the ones you mentioned)?

Sign in to reply to this post

Jason ByrnesWebAssist

you may be able to make the connection to the mysql database, but you will need to work that out with the hosting company.

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...