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

[salcman.vladimir]

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.

[visualAd]

Have you set up permissions for the connecting PC in the database? Also, how do you mean the database is always empty?

[salcman.vladimir]

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

[visualAd]

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.

[salcman.vladimir]

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 ???

[lintz]

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