Access MySQOL db from Dreamweaver?

wordpress

#1

Hi!
I want to work on my Wordpress blog from a locally installed copy of Dreamweaver 8. (This should be possible - there are others doing this with other hosts.)

I specifically want to be able to use the ‘design view’ in
Dreamweaver, which lets you visually see how things come out as you code.

In order to do this, a remote connection from Dreamweaver to Dreamhost is required.

I have spent 4 hours trying to complete the connection.
I really have to ask for help now - I seem to be stuck!

*Blog URL: www.vikingprincess.net.
*‘mysql’ database name: ‘johanna’ uid-jojo0507;pw-sverige (will change those very shortly now, but just in case somebody sees this and can help me with the parameters)

*I am currently working on changing the ‘Tiga’ theme, which is in www.vikingprincess.net/wp_content/themes/tiga

In Dreamweaver 8, I have set up a ‘Site’ (menu option: Site>Manage Sites, create new or edit existing) (I think I must be wrong about one or more of them. See ‘Sites’ dialogue box:

Local Info:

Sitename: vp1
Local Root Folder: d:\website\testenv
Refresh local file list automatically: checked
Default Images Folder: blank
Links Relative to: Document
HTTP Address: http : // www . vikingprincess . net/ (spaces removed)
Case Sensitive Links: unchecked
Cache: checked

Remote Info:

Access: FTP
FTP Host: ftp . vikingprincess . net (remove spaces)
Host Directory: /
Login: jojo0507 - works fine
Password: c$MjgmaA- works fine (this will be changed, shortly - nothing there worth hacking anyway. just hoping that my access problem can be solved.)
Use Passive Mode: checked
Use Firewall: unchecked
Use Secure FTP: unchecked
Maintain Syncronization Info: checked
Automatically Upload Files upon save: checked
Enable File check in and out: unchecked

Testing Server:

Server Model: PHP mysql
Access: FTP
FTP Host: ftp . vikingprincess . net (remove spaces)
Host Directory: /
Login: jojo0507
Password: c$MjgmaA
Use Passive Mode: checked
Use Firewall: unchecked
Use Secure FTP: unchecked
URL Prefix: http : // www . vikingprincess . net/

Cloaking
Enable Cloaking: checked
Cloaked Files end with: unchecked

Design Notes
Site Map Layout
File View Columns
Contribute
The 4 above were not changed from default


THIS (above) is working and LETS ME SYNCH THE FILES WITH THE REMOTE CONTENT. But I also need a db connection.


So I select Window > Databases and try to set up as follows:

mysql Connection Settings:

Connection Name: vpdb
mysql Server: localhost (I have tried ‘mysql.vikingprincess.net’ as
well with no success. I saw a post with somebody who connected remotely while using ‘localhost’ in this setting…(?!)
User Name: jojo0507 (the db user name according to the panel)
Password: see above
Database: johanna

The database connection does not work. I get various kinds of messages depending on what settings I try. With the above settings I get the message:

"HTTP code 404 file not found. Here are some possible reasons for the
problem: 1) There is no testing server running on the testing machine. 2) The testing server specified does not map to the
http://vikingprincess.net/_mmServerScripts/MMHTTP.php url. Please verify that the URL prefix maps to the root of the site. "

Well I tried every combination of parameters that I could think of and that seems reasonably likely.

I have added my machine IP to the list of computers that jojo0507 is allowed to access the database from (strange setting!)

Please help me - I know I have got something wrong, but what!!!

All the best from London, UK
Johanna


#2

While I can’t tell you how to do what you want using Dreamweaver because I don’t do it, I do have to ask, are you trying to just modify the theme, or do you actually want to update your blog by way of Dreamweaver? If the latter, I don’t think you can but don’t quote me on that. I know that, if you can, you can’t do so using localhost as MySQL is not actually on the same server as your website, so localhost will by default fail.

Yes, I have an opinion.

Get a minimum 50% off with the “haveadreamyday” promo code, and… have a dreamy day. Original, no?


#3

Hi!
Thanks for responding. I want to CHANGE the theme, not just update the diary entries in the blog.
Sorry if that wasn’t clear from the post.

I should mention that although I have been a programmer in the past, I haven’t really done any CSS / HTML coding, and therefore do not know Dreamweaver. I am trying to learn these new technologies while setting up ‘the perfect’ blog… I am a project manager and am beginning to feel quite alienated from hands-on technical work.

So answer yes, I want to MODIFY the theme - In fact you could say I am creating a theme from scratch. The original theme that I started out from is no longer recognisable. However I am getting a bit irritated with the time consuming “save file, upload via ftp, view in browser” routine. I’d like to work directly on the live site and see the results of what I am doing immediately.
Jo


#4

Ah, now I see. You don’t need to access the database, then, as the theme is only in at least one PHP file. The only time you need to be messing with the database is when you’re updating blog content. Unfortunately, if you want to see the changes immediately, you probably need to be editing the theme directly in wordpress. Otherwise, download file, edit file, save file, and upload file is the way to be.

Yes, I have an opinion.

Get a minimum 50% off with the “haveadreamyday” promo code, and… have a dreamy day. Original, no?