0
php and MySQL
New Here
,
/t5/dreamweaver-discussions/php-and-mysql/td-p/1066288
Sep 25, 2006
Sep 25, 2006
Copy link to clipboard
Copied
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.
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.
TOPICS
Server side applications
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Contributor
,
/t5/dreamweaver-discussions/php-and-mysql/m-p/1066289#M148712
Sep 26, 2006
Sep 26, 2006
Copy link to clipboard
Copied
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.
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.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Contributor
,
/t5/dreamweaver-discussions/php-and-mysql/m-p/1066290#M148713
Sep 26, 2006
Sep 26, 2006
Copy link to clipboard
Copied
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.
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.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
LEGEND
,
/t5/dreamweaver-discussions/php-and-mysql/m-p/1066291#M148714
Sep 26, 2006
Sep 26, 2006
Copy link to clipboard
Copied
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.
:
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.
:
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
LEGEND
,
LATEST
/t5/dreamweaver-discussions/php-and-mysql/m-p/1066292#M148715
Sep 26, 2006
Sep 26, 2006
Copy link to clipboard
Copied
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/
> 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/
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

