Jump to content


Photo

can not connect to MYSQL DB


  • Please log in to reply
2 replies to this topic

#1 manou

manou
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 09 May 2006 - 05:14 AM

hello,
I am trying to run a php page and mysql using dreamweaver 8 but I can not make it work, and I need help.
I appreciate your help,
here is what I have on my computer:

win xp pro ( IIS installed)
dreamweaver 8, 2005 ( upgrade also installed (8.01),
Php 5.1.4
Mysql 5 5.0.1.6

mysql woks fine on my computer,
I have istalled Navicat ( windows base software to work with Mysql)
and connects to my test database.

I made a php page and try to connect to my database but I get the following error :
there is no testing server running on the machine, the testing server specified for this site does not
map to the [a href=\"http://localhost/test12/mmserver\" target=\"_blank\"]http://localhost/test12/mmserver[/a] Scripts/MMHTTPDB.php URL verify the URL prefix
map to the root of the site.

mmserverScripts folder and the file MMHTTPDB.php are found on both local floder and server test folder,


I have read many solutions posted on different forums on this issue but still could not make it work,
different changes and got different errors, but the above error is the latest.


I have this info on site defenition, advance mode:

local info:
local root folder: I:\webtest\test12\
http address: [a href=\"http://localhost/test12/\" target=\"_blank\"]http://localhost/test12/[/a]

Remote Info:
access: local /network
remot folder: I:\webtest\test12\


Testing Server:
server model: PHP MYSQL
acess: local/network
Testing Server Folder: C:\Inetpub\wwwroot\test12\
URL Prefix: [a href=\"http://localhost/test12/\" target=\"_blank\"]http://localhost/test12/[/a]

I have taken off the semi colon from the following code of php ini file:
extension=php_mysql.dll

and give the following address to the following code :
doc_root=c:\Inetpub\wwwroot\

but I don't know what to write in the front of following line in php ini file:
extension_dir = "./"

php is installed in c:\php\

and php5ts.dll and php-cgi and three folders are inside the php folder.

I also have copied the libmysql.dll into system32 folder and widows folder,

I am working on this since this morning and not been able to make it work,

appreciate if anyone can help me on this.

Thanks



#2 moberemk

moberemk
  • Members
  • PipPipPip
  • Advanced Member
  • 695 posts

Posted 09 May 2006 - 11:14 AM

Is the MySQL server on another computer? If so, you can't connect to it unless it's specially set up to allow remote connections.
Disclaimer: No matter how harsh I may be, I'm always IMO only.

#3 manou

manou
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 09 May 2006 - 05:05 PM

[!--quoteo(post=372551:date=May 9 2006, 06:14 AM:name=moberemk)--][div class=\'quotetop\']QUOTE(moberemk @ May 9 2006, 06:14 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Is the MySQL server on another computer? If so, you can't connect to it unless it's specially set up to allow remote connections.
[/quote]

thanks for reply;

No it is not,
everything is on my home compter,





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users