Skip to main content
T
tashmac
Participating Frequently
July 11, 2009
Question

Unidentified Error when connecting DW with MySql

  • July 11, 2009
  • 2 replies
  • 1180 views

Hi

I am trying to connect to Mysql Database which is hosted by a hosting company on their server.  I have been given a static IP address and port to access this database remotely. I have add the information below to DW 8 in an attempt to gain access the info is below.  I get an unidentified error when i test the connection i don't know where to put this static IP and port.  Can someone help thanks

DW information is as follows:

My login is
username buildingbids
password ********

I am trying to connect from dreamweaver

Details of that are below

Local Info

Sitename buildingbids

Local root folder C:\Documents and Settings\Main User\My Documents\WEB SITES\buildingbids\

HTTP address http://www.buildingbids.ie


Remote Info

Access FTP

FTPhost ftp1.reg365.net

Host Directory web

Login buildingbids.ie

Password ******


This works when i test it


Testing Server

Server Model PHP MySQL

Access FTP

FTPhost ftp1.reg365.net

Host Directory web

Login buildingbids.ie

Password kevinmac


This works when i test it


URL Prefix http://ftp1.reg365.net/

When i go to test the connection i get a message saying an unidentified error has occured.


My connbuildingbids code is

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connbuildingbids = "ftp1.reg365.net";
$database_connbuildingbids = "buildingbids";
$username_connbuildingbids = "buildingbids";
$password_connbuildingbids = "kevinmac";
$connbuildingbids = mysql_pconnect($hostname_connbuildingbids, $username_connbuildingbids, $password_connbuildingbids) or trigger_error(mysql_error(),E_USER_ERROR);
?>


My connection criteria is

Connection name connbuildingbids

MySql Server mysql1.mylogin.ie

Username buildingbids

Password *********

Database buildingbids

This topic has been closed for replies.

2 replies

B
bregent
Participating Frequently
July 11, 2009

Looks like you used your ftp server address rather than the SQL server

$hostname_connbuildingbids = "ftp1.reg365.net";

Use the static ip/port that they gave you.

T
tashmacAuthor
Participating Frequently
July 12, 2009

I did use that when i got it and i still got the same error.  I have just tried it again and the same error.

$hostname_connbuildingbids = "89.101.172.46:3306";  this is what i put in

B
bregent
Participating Frequently
July 12, 2009

Are you absolutely sure your host allows remote connections? Many do not. I would contact them directly and speak to a rep to be sure.

J
JustinHill-CKA
Participant
July 11, 2009

Kind of the blind leading the blind here but I set my site development up using a handy server on my own network and the connect file looks like this:

?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_thompson = "192.168.4.100";
$database_thompson = "b_thompson";
$username_thompson = "jhill";
$password_thompson = "(not shown here)";
$thompson = mysql_pconnect($hostname_thompson, $username_thompson, $password_thompson) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

which works except that I had to mess with the permissions on the MySQL server side - in my case local and LAN-accessible, in your case maybe fight with the ISP.  What I didn't realise at first was that the permissions for 'jhill' needed to be set for 192.168.4.100 (actually I used 'mail.cka-net.com', the internal DNS hostname of 192.168.4.100); they were set up for 'localhost' (required to do local database setup changes) and '%' (theoretically everything else) but nothing worked until I set things up for mail.cka-net.com - the address of the server.

Probably no damn help at all I realise, but it does suggest you question the ISP carefully about what they've set up.

Justin

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices