MySQL Database Connection

Report · Apr 23, 2007

I have been trying to set up a dynamic site in Dreamweaver based on an example in a book titled Dreamweaver MX 2004 Demystified, by Laura Gutman. I have been developing on a Windows XP Pro machine using IIS. I have installed MySQL and PHP. I tested my web server on http://localhost/ and it seems to be working. I can open the MySQL databases from the command line. I loaded the sample project and set up the local info, remote folder and testing server making sure that the Testing server folder and URL prefix both point to the same location. The problem I keep having is that when I try to set up the database connection I get and error message that says "An unidentified error has occurred." I get this both from the Select button for the database and the Test button for the connection. Is there possibly something that I have missed in the MySQL setup or PHP configuration? I recently set up on a different computer using Apache web server, and the same thing happens. Any suggestions would be appreciated. Thank you.

Report · Apr 24, 2007

I had a similar problem and resolved it via this forum. Maybe its the same for you.

In the connection, it asks what the MySQL address is ( http://localhost/) as you entered.

It also asks for the database but when I tried this, I got an unidentified error.

It was only when I left the database field blank - none specified that I got a successful test connection and the database was selected using the server behaviour panel.

this might not be whats wrong but it worked for me.

Seems to be weird in DW

Report · Apr 24, 2007

I thought that might work, but no change. If I leave the database field blank I immediately get a warning that MySQL requires a database name for the connection. I can click ok there and everything saves, but in the database panel when I expand the tables, views and stored procedures nodes it just says none. It seems like Dreamweaver is not aware of the MySQL databases on the computer.

Report · Apr 25, 2007

Ok, update time. In looking at another post on this forum, I re-examined my php installation and decided to reinstall it due to switching to Apache web server. I did that and it made a big difference in that it now tests for the database connection when I hit the Select or test buttons. However, the test times out and tells me that I need to verify that the ODBC DSN exists on the testing server. I'm not quite sure how to do that since I read that php does not require drivers to work with MySQL. If someone could elaborate on this I think I am close to having this solved. Thanks.

Report · Apr 26, 2007

aopro wrote:
> Ok, update time. In looking at another post on this forum, I re-examined my php
> installation and decided to reinstall it due to switching to Apache web server.
> I did that and it made a big difference in that it now tests for the database
> connection when I hit the Select or test buttons. However, the test times out
> and tells me that I need to verify that the ODBC DSN exists on the testing
> server. I'm not quite sure how to do that since I read that php does not
> require drivers to work with MySQL. If someone could elaborate on this I think
> I am close to having this solved. Thanks.

Have you set up a username and password for MySQL? If it's trying to
connect via ODBC, it sounds as though you haven't established any user
accounts in MySQL.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

Report · Apr 26, 2007

Problem solved. After I configured PHP I tried to connect to MySQL and the connection attempt kept timing out. Turns out it was my firewall trying to block it and I couldn't see the warning until I closed Dreamweaver. Got that all straightened out and now everything seems fine. Thanks all.

Report · Apr 26, 2007

Problem solved. After I configured PHP I tried to connect to MySQL and the
connection attempt kept timing out. Turns out it was my firewall trying to
block it and I couldn't see the warning until I closed Dreamweaver. Got that
all straightened out and now everything seems fine. Thanks all.

Report · Jun 03, 2007

I installe MAMP on my iMac Mac OS 10.4 Tiger. The connection seems to work. I have Dreamweaver MX and My SQL connection seems to work too. But my problem is that I don't see the same table list in phpMyAdmin and Dreamweaver.

In phpMyAdmin I have those databases:
information_schema (17)
mysql (17)
login_system (1)
test (1)

In Dreamweaver, I have
information_schema
mysql
test
test1

Can someone tells me why?