Results 1 to 6 of 6

Thread: I need connect to MySQL Database on second computer on the net

  1. #1

    Thread Starter
    Member
    Join Date
    Jan 2006
    Location
    Czech Republic
    Posts
    52

    Arrow I need connect to MySQL Database on second computer on the net

    Hi, help me please. I need connect to MySQL Database on second computer on the net (two computer join over switch).

    I wrote:
    $signal=mysql_connect("192.168.0.1");


    When I work with database on localhost then is all OK but when I want connect to database on second computer then this is problem.
    It not make errors but database is always empty.

  2. #2
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    Re: I need connect to MySQL Database on second computer on the net

    Have you set up permissions for the connecting PC in the database? Also, how do you mean the database is always empty?
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!


    Spread happiness and joy. Rate good posts.

  3. #3

    Thread Starter
    Member
    Join Date
    Jan 2006
    Location
    Czech Republic
    Posts
    52

    Re: I need connect to MySQL Database on second computer on the net

    I'm Not Understand. Can You me please write code for connect.

  4. #4
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    Re: I need connect to MySQL Database on second computer on the net

    Quote Originally Posted by salcman.vladimir
    I'm Not Understand. Can You me please write code for connect.
    "code for connect"

    I mean, you need to add a user to your MySql database for the IP address of the computer you are connecting from. Also when you say that the database is empty, what do you mean? If yoyu are connecting to the same database then it would contain the same data, of course if it is failing to connect the mysql_connect function will return false.
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!


    Spread happiness and joy. Rate good posts.

  5. #5

    Thread Starter
    Member
    Join Date
    Jan 2006
    Location
    Czech Republic
    Posts
    52

    Arrow Re: I need connect to MySQL Database on second computer on the net

    Sorry, I learn English only 1/2 year.
    So once more:
    I have a APACHE software at home on 2 computers and I have 1 MySQL database on first computer. I want to connect from second computer to database on first computer.

    1. computer's IP: 192.168.0.1
    2. computer's IP: 192.168.0.3

    How do I do it ?

    When I write to command MySQL_connect("localhost") then this code go. When I write the command with IP address then don't going. Page don't work.

    Can you help, me ???

  6. #6
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697

    Re: I need connect to MySQL Database on second computer on the net

    I to had this problem a little while ago until I downloaded MYSQL Tools and after a little help from the developers I can now connect to mysql database from any machine on our office network. If you go with MySQL Tools but can't get it working I can email you the insrucitons the developers sent me if you like

Posting Permissions

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



Click Here to Expand Forum to Full Width