Database Connection Problem with MAMP (Mac)

[David Blomstrom]

I installed a preconfigured package called MAMP on my MacBook Pro and have just about
everything working except my database connections. I can use phpMyAdmin to manipulate
databases and tables, but I can't connect to those databases from Dreamweaver.

I read somewhere that you have to use a special username (or host?) if your components are
running on different servers. I have two Apache installations running, with the default
installation running the show. In other words, phpMyAdmin is running with the original
Apache, not MAMP's Apache (at least, I think so).

Anyway, I created a user named 127.0.0.1, which I believe is my webserver's IP address. I
assigned no password. This is what my connection looks like:

$link = mysql_connect ("127.0.0.1" , "" , "") or die(mysql_error());
mysql_select_db ("WebServer", $link) or die(mysql_error());

I also tried it with host also designated 127.0.0.1...

$link = mysql_connect ("127.0.0.1" , "127.0.0.1" , "") or die(mysql_error());

mysql_select_db ("WebServer", $link) or die(mysql_error());

Access denied for user ''@'localhost' to database 'webserver'

* * * * *

This database connection...

$link = mysql_connect ("localhost" , "root" , "") or die(mysql_error());
mysql_select_db ("Test2", $link) or die(mysql_error());

...yields this error:

Warning:  mysql_connect() [function.mysql-connect]: Access denied for user
'root'@'localhost' (using password: NO) in /Users/davidblomstrom/Sites/Geobop/a1/dbc.php
on line 21

Access denied for user 'root'@'localhost' (using password: NO)

* * * * *

The only database I could connect to without an error message was the default database
"test," which I accidentally dropped. The weird thing is that I couldn't connect to it if
I designated "root" as the username; rather, there was no error only if I used anything
BUT root, even though the usernames I assigned didn't even exist. So I don't think I was
really connected.

I've seen some sources that talk about "symlinking" MySQL (or phpMyAdmin?) if Apache is on
a different server. Could that be the problem? If not, does anyone know how I can
troubleshoot this?

Thanks.





 
____________________________________________________________________________________
It's here! Your new message!  
Get new email alerts with the free Yahoo! Toolbar.
http://tools.search.yahoo.com/toolbar/features/mail/