vb.net - Visual Basic - MySql connection is failing on another computer -


i having problem program of mine. chat program login system using mysql. downloaded mysql connector net 6.9.6 , using visual basic. when run program works (both in debug , release mode) , connects mysql database.

however, when friend tried couldn't connect database. need put library file within program or should download mysql connector net too?

it seems program works on local computer(i mean software works in same environment database engine running).

if want let friend connects mysql server, should create user friend pointing remote ip address of friend, this:

  1. so if friend have following public ip: 200.28.145.128

  2. you in mysql console, have write following command:

    grant privileges on yourchatdatabase.* remoteuser@200.28.145.128 identified 'somepassword';

  3. now friend should haves modify connection string data in order connect mysql server remote computer(just him). `


Comments

Post a Comment