Jason, as per your suggestion, I uninstalled and reinstalled MAMP. No luck. I also found out that OS X 10.6.7 did not have the client libraries and binary folder installed, so I updated that. I also had to activate in Dreamweaver the firewall and check that on the remote server.
As this point, MAMP will not let me check the Apache and MySQL ports change in preferences to 80 and 3306. Both red lights turn on. When I reset to MAMP ports 8888 and 8889, both green lights go on.
I also tried to configure with G0Daddy Database and use Dreamweaver CS3. I have not made a connection there either since the error says there is not testing server on this machine - which i set up to the remote server IP address and it tests fine except for using a database.
I have not seen the original error /tmp/mysql.sock as per your post since the upgrades to OS X 10.6.7 and the install of MySql on my computer.
Please advise as to how to get the localhost MAMP to the ports that I need (80 and 3306)
I need this in order to use Datassist and e-cart features and do not know why I cannot get the features to work. Thanx