php and MySQL

Report · Sep 25, 2006

I’m pretty new to using databases with web page design, and while I’d like to think I’m progressing somewhat well with .asp pages and Access databases but I’m having problems connecting .php pages to a MySQL database. I created a MySQL database, but I just can’t figure out how to connect to it using Dreamweaver 8. The problem I’m having is with the fields in the screenshots linked below.

In the first screenshot, you'll see the screen the is giving me problems.
MySQL Connection Screen

The second screenshot will hopefully solve the first one.
MySQL Database

I tried:

Connection name: CosmaticMySQL
MySQL server: 67.159.9.157
User name: gunblade
Password: *************
Database: cosmaticdb

And it gave me an error when I clicked on "Test". This also stops me from using the rest of the connection steps and thus I have to quit the entire page.

Report · Sep 26, 2006

I am not sure if ASP works with MySQL database server. Are you really sure that you have configured your PHP application server -- to make sure the path works and in connection with your MySQL web server. Not only that, but be sure that your MySQL server is up and running before you make any efforts to make a connection to MySQL database files along with your Dreamweaver 8.

Anyway, did you 'test' your PHP application server on your localhost on top of your computer. I also didn't know what type of system architecture you are working on. Mac OSX or WIndows XP Home (or professional edition)? As for Mac OSX, be sure to state the exact version.

Hope that helps somewhat.

Report · Sep 26, 2006

I forgot to mention one other thing. If you are working with your MySQL database sever through your web host provider, then you'll have to contact your tech support people to get the exact information how to set up the right path, the right password and other confidential information between yourself and tech support people at web host provider.

If you are working and testing your database or data-driven websites on your machine right on top of your computer and plans to upload files to your web host provider servers (including database severs, etc...) YOu need to make sure that you have the exact same verions of PHP, MySQL and all other open source application development. If differs, you could run into problems not able to process or work with those database servers. Just two cent advice and tips.

Report · Sep 26, 2006

Hi,
As you have heard, more info would help...anyway a couple of things to try
that might work depending on your remote setup:

Any account I have has an owner and therefore the remote username is:
owner_username
and the database name is:
owner_databasename

The other thing you might try is giving wildcard access to the database.
Some hosts allow this, normally a % symbol. Not very secure but works if
you do not have a fixed IP address

joe

"Dreamspeeder" <webforumsuser@macromedia.com> wrote in message
news:efa8j6$2i7$1@forums.macromedia.com...
: I?m pretty new to using databases with web page design, and while I?d like
to
: think I?m progressing somewhat well with .asp pages and Access databases
but
: I?m having problems connecting .php pages to a MySQL database. I created a
: MySQL database, but I just can?t figure out how to connect to it using
: Dreamweaver 8. The problem I?m having is with the fields in the
screenshots
: linked below.
:
: In the first screenshot, you'll see the screen the is giving me problems.
: http://www.lightspeedfinearts.com/dreamweaver8mysql01.jpg
:
: The second screenshot will hopefully solve the first one.
: http://www.lightspeedfinearts.com/dreamweaver8mysql02.jpg
:
: I tried:
:
: Connection name: CosmaticMySQL
: MySQL server: 67.159.9.157
: User name: gunblade
: Password: *************
: Database: cosmaticdb
:
: And it gave me an error when I clicked on "Test". This also stops me from
: using the rest of the connection steps and thus I have to quit the entire
page.
:

Report · Sep 26, 2006

Dreamspeeder wrote:
> I?m having problems connecting .php pages to a MySQL database.

I have answered your duplicate post in the main Dreamweaver forum.

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