New problem

[buzzt]

How can I allow someone to access my mysql database from their website. I need them to be able to write information into my database, so how would I set up the account (the privileges)? It can't still be 'user'@'localhost' can it? Can I allow only 1 ip to access it?

 

[sleipnir214]

'localhost' is one address, specifically 127.0.0.1. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[buzzt]

But how would I set up the account? I mean, what would the connection string have to look like for their website to be writing to mine (they are not on the same server as I am)? How can localhost work if they are on a completely different server?

 

[sleipnir214]

As far as giving the user access goes:

http://www.mysql.com/doc/en/GRANT.html

I cannot say what the connection string would look like. I do not know what software your user will utilize to connect to your database server. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!