Mysql Question

[golfinggod]

Hi all need help, I want to test my pages with my mysql databse as im creating them, the problem is i dont know how to remotely link to the database. Im guessing i need to change the $server part of the code below, but i dont know what to.

 /* Start of PHP3 Script */ 
          /* Data of SQL-server */ 
          $server= "db262.oneandone.co.uk";     /* Address of 1&1 database server */ 
          $user= "*******";                   /* FTP-username */ 
          $password= "*******";              /* FTP-Password */ 
          $database= "*******";             /* name of database */ 


      /* Accessing the server and creating the table */ 
      MYSQL_CONNECT($server, $user, $password) or die ( "<H3>Database Not Availiable At This Time</H3>");
      MYSQL_SELECT_DB($database) or die ( "<H3>database not existent</H3>");
	  

any ideas thanks

[sidney]

mysql can except connection from remote hosts but this needs to be set on server

some hosting account allow you to specify remote host connections in the hosting control panel

failing this you would neded to contact your host to get your ip added

another metod would to be install a web server on your machine and install mysql and php to

then you could do all testing localy