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/