Forums
This topic is locked
connecting to database
Posted 11 Dec 2003 01:51:35
1
has voted
11 Dec 2003 01:51:35 Carl Robison posted:
I've searched through your archives and found many responses to this problem, but I'm still not sure where I'm going wrong. I have a WinXP system. I've created a simple MySQL database named "testing". These are the steps I've taken.1. Created a site:
Site Name: List a Menu
Local Root Folder: C:\Sites\ListaMenu Default Images Folder:
C:\Sites\ListaMenu\Images HTTP Address:
??????? What should I put here or is this only for remote connection???
2. Chose a document type: PHP
3. Set up testing server:
Server model: PHP MySQL
Access: Local Network
Testing Server Folder:
C:\Phperl2.3\Apache2 URL Prefix: localhost/Phperl2.3/Apache2/
( I really have no clue if those last two items are correct)
4. Click the plus sign under Databases tab and select MySQL Connection
Connection Name: List a Menu
MySQL Server: localhost
Username: *
Password:*******
Database: Testing
Something else that's confusing me...when I setup MySQL, I did set up a password, but what is the user name that they're asking me for here?
Anyway, if I click on the Test button at this point, I get the dreaded:
HTTP Error Code 404 File Not Found. Here are some possible reasons for the problem:
1. There is no testing server running on the server machine. (I do know the server is running)
2. The testing server specified for this site does not map to the localhost/Phperl2.3/Apache2/_mmServerScripts/MMHTTPDB.php URL. Verify that the URL Prefix maps to the root of the site.
I do have a _mmServerScripts folder in my Apache folder with 2 PHP files in it:
MMHTTPDB.php and mysql.php.
I apologize if I'm giving more information than needed, but I've gone through every post I can find on this problem and still can't figure out where I'm going wrong with my settings. Thank you so much for any help you can give!!!!
Carl
Replies
Replied 17 Dec 2003 13:42:30
17 Dec 2003 13:42:30 Janusz Jasinski replied:
Hi,
Assuming that Apache is running in: "C:\Phperl2.3\Apache2" Is it only for this one site that you are having problems? If not, then your PHP, MySQL or Apache installation might have gone wrong.
Try passive connection (if its available). You sure database name is correct.
You have: <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>C:\Phperl2.3\Apache2 URL Prefix: localhost/Phperl2.3/Apache2/ <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Not sure if you should just use: localhost
Sorry couldn't be of more help!
Janusz
======================
www.xlibris.co.uk
janusz.monkey-it.co.uk
ASP | VBScript | IIS 5.1 | Windows XP Pro | Linux Redhat 9 | SuSE 9 Pro | Linux FreeBSD 4.9 | PHP 5.0.0 Beta 2 | MySQL 4.0 | Apache 2.0.48 | Macromedia Studio w/t Flash 2004 | Microsoft Office Pro 2003 | Mozilla Firebird 0.7 | IE 6 | B.O.R.E.D @ HoMe
Assuming that Apache is running in: "C:\Phperl2.3\Apache2" Is it only for this one site that you are having problems? If not, then your PHP, MySQL or Apache installation might have gone wrong.
Try passive connection (if its available). You sure database name is correct.
You have: <BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>C:\Phperl2.3\Apache2 URL Prefix: localhost/Phperl2.3/Apache2/ <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Not sure if you should just use: localhost
Sorry couldn't be of more help!
Janusz
======================
www.xlibris.co.uk
janusz.monkey-it.co.uk
ASP | VBScript | IIS 5.1 | Windows XP Pro | Linux Redhat 9 | SuSE 9 Pro | Linux FreeBSD 4.9 | PHP 5.0.0 Beta 2 | MySQL 4.0 | Apache 2.0.48 | Macromedia Studio w/t Flash 2004 | Microsoft Office Pro 2003 | Mozilla Firebird 0.7 | IE 6 | B.O.R.E.D @ HoMe