How can I write data to a database table on another server?

Question

I am using the mysqli_connect($host, $user, $pass, $db) line to connect to another server through php. I am trying to write to a MySQL database.

I have used the server's IP [A.B.C.D] on the $host variable. However I cannot write to that database, and the script does not run completely.

I am using the root user and password to connect, and the user list in phpmyadmin shows that anyhost(%), 127.0.0.1 and localhost can connect with the root username (I think that's what it means). Anyway, as I am using root, I don't think this is a user privilege problem.

I have tried putting a # before 'bind-address=127.0.0.1'.

I have tried editing my.cnf according to suggestions from a lot of forums.

I have not installed firewall in any of the servers that I'm using, so unless Debian 7 64-bit comes with pre-installed firewall that blocks certain ports, I don't think that is the problem either.

Isn't there an easy way to establish connection between multiple servers? :-/

Florin · Accepted Answer · 2014-01-23 19:15:22Z

1

Your remote mysql server must accept remote connection from your IP address.

After you make this setup you can access remote mysql server like this:

mysqli_connect($remote_host, $remote_user, $pemote_pass, $remote_db);

answered Jan 23, 2014 at 19:15

Florin

6,2382 gold badges24 silver badges32 bronze badges

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

8 Comments

MiniGunnR Over a year ago

How do I make sure that it accepts remote connections? I've found somewhere that I have to edit /etc/phpmyadmin/config.inc.php file. But what are the exact changes that I need to make? Also, do I edit this file on the local machine? Or the remote machine? I'm really confused!

Florin Over a year ago

here you have a complete tutorial how to do that. debianhelp.co.uk/remotemysql.htm

Florin Over a year ago

Remote server is your "other server". you have to edit that my.cnf file to accept connection from your ip.

MiniGunnR Over a year ago

I tried to follow your debianhelp.co.uk link and my mysql will not restart! Kill me now !!!! >.< Is xampp easier to manage? I've got Access Forbidden error when I installed XAMPP. I don't know which way to go.. lol..

MiniGunnR Over a year ago

Solved the slow connection. In my remote server--> # nano /etc/mysql/my.cnf... under the [mysqld] section added the line--> skip-name-resolve I love this community! :D

|

Collectives™ on Stack Overflow

How can I write data to a database table on another server?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related