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