Can't Open a MySQL Database

Forum|Forum|18 years ago
December 31, 2007
3 replies
698 views

After downloading, installing, and starting the Xampp copies of MySQL and Apache, I created and loaded a small database, which I can see in a browser using localhost. In Dreamweaver I created and saved a PHP page on which I want to display database informaiton. I opened the Databases pane, click +MySQL Connection, entered a name, "localhost," a user name and password, and clicked select to select a database. I get the "404 File Not Found" error message. I know that Apache and MySQL are running because I can see them in a browser using "LocalHost." Whe can't DW see them?, or am I doing something wrong?

Server side applications

This topic has been closed for replies.

C

CaroleMatthewsAuthor

Participating Frequently

Thanks again for your comments!

I have both
Loaded Configuration File C:\xamp\pApache2\bin\php.ini and
MySQL Client API library version 5.0.45

In localhost I can use the browser through phpMyAdmin to look at my database and on same computer I open DW with the .php page and try to open the database only to get the 404 File Not Found error.

H

headlocklynn

Participant

hi, I had same problems. Have solved the connection issues by going back in and making sure my remote paths and testing server paths were setup correctly. I have been following the cafetownsend tutorials see how mine is set up. Hopefully it will solve your problems too
Local Root folder = F:\websites\cafetownsendphp\
Images folder = F:\websites\cafetownsendphp\images\
HTTP address = http://localhost/cafestownsenphp/
Remote info = local host
Remote folder = C:\Apache2\htdocs\
testing server info php, mysql
Access = local network
Testing server folder = C:\Apache2\htdocs\

Hope this helps all those others who have had trouble getting dreamweaver to connect to mysql database. It took me days to sort it out and checked all the forums etc.

C

CaroleMatthewsAuthor

Participating Frequently

Thanks a lot! I'll try to follow this set up and see if I can't get mine to work.

A

Anonymous

did you install seperately ? each . or Package Xampp ?. I'm not sure if you can view it in your PHP interface like in Wamp myself but you could try.

1. Go to http://localhost

2. Click on phpinfo()

3. Search for
3.1 Loaded Configuration File C:\xamp\pApache2\bin\php.ini
checking if Apache and php.ini is configured
3.2 MySQL Client API library version 5.0.45 ( scroll futher down )
checking MySQL is too configured

That's the proof of correct configuration .If you can't find these- then it's not properly conjoined/configured.

A

Anonymous

is root your username ?. Do you have a password ?. Something is wrong with the configuration part. You have to make sure that MySQL ,Apache and PHP are conjoined while setting up your Xampp.

C

CaroleMatthewsAuthor

Participating Frequently

Thanks for the reply.

I have assigned a separate user name and password, and I also tried "root" with no password. I used the Xampp installer. How can I check if MySQL, PHP, and Apache are cojoined?

Marty

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded