[PHP] MySQL Connection Help
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.
Site URL = http://quinnserver.com
FTP URL = ftp.quinnserver.com
FTP Username = [EMAIL PROTECTED]
FTP Password = password
MySQL database = quinn_tempdb
MySQL table = addresses
MySQL Username = quinn_tempdbuser
MySQL Password = password
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?
Please confirm the following settings and tell me where I'm wrong or fill
in what I've left out.
In the Testing Server area of DW's Site Definition dialogue...
Server Model = PHP MySQL
Access = FTP
FTP Host = ftp.quinnserver.com
Host Directory =
Login = [EMAIL PROTECTED]
Password = password
In the MySQL Connection dialogue...
Connection Name = QuinnServer
MySQL Server =
User Name = quinn_tempdbuser
Password = password
Database = quinn_tempdb
I apologize for the newbieness of this question but it's been driving me
crazy and I'm sure I'm just missing something simple. Thanx in advance for
any help provided.
--
Robb Kerr
Digital IGUANA
Helping Digital Artists Achieve their Dreams
http://www.digitaliguana.com
http://www.cancerreallysucks.org
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySQL Connection Help
Robb Kerr wrote:
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.
[ snipped out passwords and login information ]
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
