Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a vb.net program that uses mysql as its database. And it works when the computer has wampservr installed. But the program gets an unhandled exception error when the computer where its running does not have a wampserver. The only thing that is installed in it is the mysql connector net. How do I make it work. I just want the two programs to access the same mysql database. I already opened port 20 by configuring firewall. Both in TCP and UDP. What do I do? Do I have to tweak the codes? Anyone in here who have tried this before?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

Did you grant access to the target database from the other host?

Assuming the IP of the other computer is 1.2.3.4:

$ mysql -u root -p <database_name>
mysql> grant all on db_name.* to <user_name>@1.2.3.4 identified by '<password>';
mysql> flush privileges;

(of course you'll want to limit that grant statement to whatever is appropriate for your environment)

Oh, and what does TCP/UDP port 20 have to do with MySQL? By default, MySQL uses port 3306/tcp.

share|improve this answer
    
what would be the username?I have also installed mysql admin on the pc w/ wampserver. Is it the users that I have defined in mysql admin? –  user28233 Mar 24 '10 at 4:05
    
Most likely, yes. This would be whatever username your application is using to connect to mysql. –  EEAA Mar 24 '10 at 4:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.