[ snipped out passwords and login information ]Ok, I feel like a complete bonehead because I can't seem to figure this thing out. But, I readily welcome someone making me feel worse by pointing out my simple mistake. I can't get DW to connect to a MySQL database on a new server with which I'm working. I've worked with other servers and haven't had a problem. I'm providing all of the connection and password information so that you can help me - don't worry, I'll change all these once I've solved the problem. BTW, I've also posted this in the Dreamweaver newsgroups but they're not as helpful as this one, so please excuse the fact that this is a ways off-topic.
myPhpAdmin provides the following connection script which works...
<?php $dbh=mysql_connect ("localhost", "quinn_tempdbuser", "password") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("quinn_tempdb"); ?>
I have built a page which works fine when uploaded to the server... http://quinnserver.com/dbcheck.php
Here's my question... What do I enter in DW's Testing Server and MySQL Connection dialogues to be able to use the database and table during the development phase without having to upload the pages to the server?
You need to setup your mysql server so that it accepts non-local connections (by default mysql only listens on localhost).
Generally this can be done from your control panel application. Also, it is never a good idea to give out your passwords in a public forum like this.
If you can't find the option in your control panel (I know cpanel has it as a last option under the mysql section), you can ask your host to add an alias for mysql.
-- Burhan Khalid phplist[at]meidomus[dot]com http://www.meidomus.com ----------------------- "Documentation is like sex: when it is good, it is very, very good; and when it is bad, it is better than nothing."
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
