Web Analytics Made Easy -
StatCounter Connectivity dropped - CodingForum

Announcement

Collapse
No announcement yet.

Connectivity dropped

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Connectivity dropped

    Updated all pages. Specifically the PHP database connection code.

    Swapping
    $db = mysql_connect("localhost", "root", "");
    to

    $db = mysql_connect("system IP", "root", "");
    Tested the pages and now they are refusing to connect to the database.

    Looked in the MySQL administrator; didn't notice any setting that wouldn't allow a page to connect by specific IP address.

    Using MySQL 4.1 and Administrator 1.2.3 rc

    The development machine and test machine are the same.
    Last edited by h8ids; Sep 26, 2006, 01:30 PM.

  • #2
    Did you include the port number with the ip?

    p.s. you actually changed more than one page before testing to see if it actually works? Gluton for punishment I see

    Comment


    • #3
      Include the port number with the IP... something like this?
      Code:
      $db = mysql_connect("system IP", "port number", "root", "");

      p.s. you actually changed more than one page before testing to see if it actually works? Gluton for punishment I see
      Didn't think that it would be such a big problem.

      Comment


      • #4
        I RFTM for you, here's the copy/paste:

        server

        The MySQL server. It can also include a port number. e.g. "hostnameort" or a path to a local socket e.g. ":/path/to/socket" for the localhost.

        If the PHP directive mysql.default_host is undefined (default), then the default value is 'localhost:3306'
        http://us3.php.net/manual/en/function.mysql-connect.php

        Comment


        • #5
          Got it. thanks.

          Comment

          Working...
          X