Dreamweaver - Making local connection to MySQL using OS X

Author

Making local connection to MySQL using OS X

itisgregory

2005-04-30, 4:18 am

I am using OS X and Dreamweaver MX. I am trying to make a connection to the
MySQL Sever from within Dreamweaver using the Applications panel and clikcing
on the "+". A window opens asking for:
Connection Name: Apress
MySQL Server: localhost
User Name: apress
Password: xxxxxx
Database (Select):
When I click select so the Dreamweaver can browse to the databases in MySQL
the connection is not being made because Dreamweaver cannot find the MySQL
Server. I think that "localhost" is wrong even though I am using a book that
tells me to use localhost. mysql and PHP are on my local machine. I am NOT
using a remote machine. I used phpMyAdmin to create the databases. Any
suggestions?

Gregory

David Powers

2005-04-30, 7:30 am

itisgregory wrote:
> When I click select so the Dreamweaver can browse to the databases in MySQL
> the connection is not being made because Dreamweaver cannot find the MySQL
> Server. I think that "localhost" is wrong even though I am using a book that
> tells me to use localhost. mysql and PHP are on my local machine.

If they're both on the same machine, localhost is correct.

Check that the mysql server is running (the simplest way is to open
phpMyAdmin - if it opens normally, mysql is running).

Sometimes OS X fails to resolve localhost, so try using 127.0.0.1 instead.

Make sure that your username and password are correct, and that the user
account has been correctly set up in MySQL.

Also make sure that your site definition has been set up correctly. The
URL prefix in Testing server must have a trailing slash on it.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
http://computerbookshelf.com