close ad
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


DW connections

Thread began 2/19/2010 3:08 am by i.edwards384429 | Last modified 2/19/2010 12:23 pm by neilo | 1601 views | 3 replies |


DW connections


I'm trying to get PS3 working on my local pc whilst connecting to the remote server that hosts the database. The idea being that I can then upload the php pages when I've modified them.

However after trying for several days I cant get a connection to the remote server with DW CS4 although I can connect with phpmyadmin and mysql administrator.

I've posted this on the ADOBE forum but as yet have not had a solution. I'm
hoping someone else has come accross this and can help.

simply...... (is anything simple?)

Using PHP myadmin and mysql administrator I can log into my remote mysql
database using the same settings I use in DW and see all the tables etc.
However in CS4 I get the error

MySql Error 2000

mysqlind cannot connect to MYSQL4.1 using old authentication

what I'm doing is

1.I'm selecting the database tab and then MYSQL connection

2. In the window I'm using:

Conection name: test

mysql server: the ip address given to me by the isp

username: xyz

password: password

If I then press the select database button I get the error message.

The remote mysql database is running mysql 5.0.77 via tcpip

The ISP is Fasthosts based in Gloucester

I've spoken to fasthosts who say that as I can connect using phpmyadmin and
mysql administrator then the problem is within Dreamweaver CS4. I find it
hard to beleive that no one else has ever connected to a remote mysql
database using CS4

Really would appreciate any assistance



Sign in to reply to this post


I've been able to connect using DW CS4. I'm using a different host though (Dreamhost in California).

Sign in to reply to this post


Connecting remote database!

You may want to check with your ISP, Many do not allow remote connections to Database!

Good Luck!

Sign in to reply to this post



The 'authentication' part of the error message is to do with the way that your mySql password has been written to the root (admin) mySql database on your server (which you probably don't have root user access to). This may have been set up before the hosting server system's upgrade to mySql v.5x.

Are you able to create a new database user via your control panel? If so, as a test, create a new user (with full permissions), this will also create a new password. Try setting up a connection using your new user name in Dreamweaver and try connecting again.

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





Ease of use


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