Hi all,
I'm having problems connecting to my remote database from dreamweaver. I contacted my hosting company and they said they cannot see any hits from my IP and to try another app. I downloaded sequel pro and it connects straight away, but I've been using DW for years (for static sites) and really wanna get this working. This is the first time i've used a database in DW so I might be missing something. DW throws up the error: MySQL Error#: 1045. Access denied for user 'xxxx'@'xxxx.net' (using password:YES). Does anyone know why one app would connect when DW won't? Does something need flushing or will deleting DW prefs do anything?
I also sometimes get the message 'waiting for server', which times out, instead of the 1045 error. Does this indicate a DW problem since the errors are inconsistent?
thanks guys 
1 Correct answer
Drag all current MAMP files to the trash and search using spotlight for files with MAMP, there is also a .plist file in the User Library->Preferences folder. Next, run Repair Permissions from the Applications->Utilities folder. Then download the latest version of MAMP (1.9.6.1). Then install MAMP and try there with a fresh set of files. Because MAMP is contained in the Applications folder you should be able to just install into the new version. MAMP as far as I know does not have a built in
...
6
Replies
drennan_uk wrote:
Hi all,
I'm having problems connecting to my remote database from dreamweaver. I contacted my hosting company and they said they cannot see any hits from my IP and to try another app. I downloaded sequel pro and it connects straight away, but I've been using DW for years (for static sites) and really wanna get this working. This is the first time i've used a database in DW so I might be missing something. DW throws up the error: MySQL Error#: 1045. Access denied for user 'xxxx'@'xxxx.net' (using password:YES). Does anyone know why one app would connect when DW won't? Does something need flushing or will deleting DW prefs do anything?
I also sometimes get the message 'waiting for server', which times out, instead of the 1045 error. Does this indicate a DW problem since the errors are inconsistent?
thanks guys
First thing that jumps out at me is "xxxx@xxxx.net". Are you trying to connect to your remote server or your testing server? For purposes of development in DW you should make a local copy of your database and connect to the local database as opposed to a remote database. Much more efficient and doesn't effect server load at all.
If the testing server (WAMP, MAMP, XAMPP, IIS) is running locally and you are using localhost with the username and password it should work fine. If you use the default installation for those packages it is possible that the applications are running on a different port in which case your host is: localhost:port .
Thanks for your help so far 
Firstly, MySQL server wouldn't start when the ports were changed to 80 and 3306 but would at default ports. I've messed around with the DW site settings and currently have them set to local/network, server folder: /Applications/MAMP/htdocs/test, web URL:http://localhost/test/. In the advanced tab I have server model: PHP MySQL, and the 'testing' checkbox checked in the main servers window. MAMP wont start MySQL regardless of the MAMP port settings now, and when I try to connect to my local database, DW says an unknown error has occurred. I've reinstalled MAMP and set DW settings up from scratch but cannot get the MySQL server to start at all now. Is there anything I can 'flush' as starting from scratch doesn't resolve the issue so I'm wondering if settings have been left somewhere even after reinstalling MAMP. Thanks.
AdChoices