Differances in MySQL servers

davebursey

Ive run into a spot of bother!!
On previous occasions, while connecting to MySql server, all ive had to do is fill in the MySQL connection fields in Dreamweaver MX. this works fine.

im now working on a new project...and a new MySQL server, and have had all manor of problems. the SQL server is behind a private firewall, and therefor i cannot establish a connection as before.

So i cannot to connect to the MySQL server as usual. Have i had it to easy before, should i be connecting in another way!?

I seem to be confused by the two differant server set ups

homchz

You may have to open a port on the fire wall to allow you through

davebursey

hmmm, yeah but i cant open ports on my web hosts firewall can i!?

homchz

davebursey wrote:
hmmm, yeah but i cant open ports on my web hosts firewall can i!?

is it a web host and you cannot just use localhost??

davebursey

yeah the server is on a remote host. localhost being that i run MySQL on my machine!? sorry im still learning this!

lozza1978

just set yourself up with a mirror of what your host is running, ie apache, php and mysql,

create and test your scripts on your xp machine... then upload to the host (Job Done),

Yes, mysql versions are slighty differnce in syntax, but you can get round this my re~coding the sql,

HTH

mmonaco

Your connection method should look something like this:

$host = ###.###.###.### The IP address of the mysql server (localhost is a reference to your machine 127.0.0.1
$user/$password = Your login credentials
$db = the database assigned to you by your host, probably something including you name, or just a serial number...
$port = if the host gave you a specific port ot use
$sock = if the hot gave you a specific socket to use

All of these values should have been provided when you signed up for an account. Probably in an email somewhere

$link = mysql_connect($host, $user, $password, $db, $port/sock);

lozza1978

localhost is a reference to the machine the script is being run on..

homchz

davebursey wrote:
yeah the server is on a remote host. localhost being that i run MySQL on my machine!? sorry im still learning this!

like lozza said localhost is a reference to the machine evertyhing is running on.

If you are testing on your machine localhost will work, and if you are on a live server, local host will work, as long as your scripts will be run on the same server.

lozza1978

of course localhost will only work if you have the correct applications installed on your machine to handle the request. ie apache, mysql and php..depending on your script.

HTH