how to connect to mysql on host on another computer on network

Question

For

$conn = mysql_connect("192.168.0.235", "root", "") or
    die("Could not connect: " . mysql_error());

mysql_select_db("crossdomaintest");

$result = mysql_query("SELECT * FROM testing");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    echo $row[1].$row[2].$row[3]."<br/>"; 
}

mysql_free_result($result);

I am getting

Warning: mysql_connect() [function.mysql-connect]: Host '192.168.0.167' is not allowed to connect to this MySQL server in /var/www/test.php on line 3 Could not connect: Host '192.168.0.167' is not allowed to connect to this MySQL server

And my IP is 192.168.0.168 and I am using LAMP on Ubuntu 10.10 and 192.168.0.235 is using XAMPP on windows 7 i can access all sites on ...235 but not access database from my local-server.

Any ideas?

Currently going offline now please any effort will be appreciated. — S L
– S L, Commented Mar 20, 2011 at 8:46
Use a good database managing program in linux and see if you can connect to windows database using that. Col. Shrapnel is also right, the appropriate privileges on your friend's computer must have been set for the ip of your computer so you can connect to that. (No, i don't know db programs for linux and have no idea where in the windows you should set the privileges.) — Hossein
– Hossein, Commented Mar 20, 2011 at 9:02

Your Common Sense · Accepted Answer · 2011-03-20 08:40:44Z

3

it's not about "how to connect". connecting would be all the same.
it's about how to setup remote server to allow connections from your IP.
do you have root privileges on the db server on 192.168.0.235? if so, you have to run appropriate GRANT PRIVILEGES query on it.
If not - ask a db admin to do that

I'd also advise not to use root user to access remote database. Better create another user and give him appropriate privileges

answered Mar 20, 2011 at 8:40

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

S L Over a year ago

well, i know the root username and password i am connecting as simply a webrequest. but honestly i don't know a lot of stuff for neetworking

Brad Over a year ago

@experimentX, you are not connecting as a web request, MySQL doesn't work that way. You are connecting with MySQL's protocol over TCP/IP. Also, this has nothing to do with networking (other than that you are using one). This has to do with the proper permissions on your MySQL installation. Col. Shrapnel is correct.

Brad Over a year ago

GRANT ALL ON * TO 'root'@'%' IDENTIFIED BY 'somepassword'; should do it. Be careful though, you're opening yourself up to trouble. MySQL's protocol is fairly plain-text, and certainly isn't encrypted, unless you connect over SSL, which you aren't doing. Remote root access is generally a bad idea. Instead, you should set up a separate user account that has access only to what you need.

S L Over a year ago

@Brad @Col.Shrapnel thanks for info, but i got one question, I can access mysql from terminal, and as well from localhost i.e. apache, and i use username and password to connect to it, am i still connecting through TCP/IP from my localserver to mysqldb?

Brad Over a year ago

@experimentX ... What does that have to do with your question. If you have a separate question for working "offline", please explain what you need in a new question. Usually if you need a couple systems to function while disconnected and then sync up, you need local servers on each side, and replication. You shouldn't mess with replication at this point. Get the basics down first.

|

Cosmik · Accepted Answer · 2011-03-20 08:42:49Z

0

Did you change to root user access the host "%"?

Sorry for my english i'm french.

Cosmik.

answered Mar 20, 2011 at 8:42

Cosmik

1

2 Comments

S L Over a year ago

mean?? i am loggin as a root user there, it's my friend computer

Brad Over a year ago

@experimentX, each user in MySQL is given a host. Usually, root is only allowed to login from localhost. If you don't grant permissions to the wild-card host (%, meaning any-host), then you won't be able to login.

Collectives™ on Stack Overflow

how to connect to mysql on host on another computer on network

2 Answers 2

7 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related