Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    19

    Unanswered: How to connect to MySQL from my another server

    Hi,

    I have MySQL installed in my PC, and some databases already working.

    Also, I have a webpage, but it's not in my PC, I'm paying for the hosting.

    They support PHP but not MySQL.

    So, what I want to do is to run the PHP scripts in the webpage and pull information from MySQL installed in my PC.

    As an example, my IP is : 201.132.130.140 (I'm running a Dynamic to Static IP software, so my domain will be:

    lotes.com

    $conn=mysql_connect("lotes.com",$user,$pass);

    I connect with the root username = root@localhost

    That doesn't work, I get ths simple error:

    Warning: Can't connect to MySQL server on 'lotes.com'


    Please help....

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: How to connect to MySQL from my another server

    Originally posted by Mysticav
    Hi,

    I have MySQL installed in my PC, and some databases already working.

    Also, I have a webpage, but it's not in my PC, I'm paying for the hosting.

    They support PHP but not MySQL.

    So, what I want to do is to run the PHP scripts in the webpage and pull information from MySQL installed in my PC.

    As an example, my IP is : 201.132.130.140 (I'm running a Dynamic to Static IP software, so my domain will be:

    lotes.com

    $conn=mysql_connect("lotes.com",$user,$pass);

    I connect with the root username = root@localhost

    That doesn't work, I get ths simple error:

    Warning: Can't connect to MySQL server on 'lotes.com'


    Please help....
    You need ti have user entry in users table (mysql database) with specified hostname or IP of remote machine. Check mysql documentation

  3. #3
    Join Date
    Apr 2004
    Posts
    19

    Please be more specific

    Kindly,

    Give me a better explanation, describe me the steps with real situation examples,

    I will appreciate.

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •