+- BP Forums (https://bpforums.info)
+-- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=55)
+--- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=56)
+---- Forum: VB.NET (Visual Basic 2010/2008) (https://bpforums.info/forumdisplay.php?fid=8)
+---- Thread: others can't connect to online database (/showthread.php?tid=389)
others can't connect to online database - Stefanvp - 08-13-2011
hi everyone who read this,
I'm kinda new to VB.net but i'm getting pretty with someone helping me and tutorials on the internet.
But now I do have a problem that no-one could solve:
I've made a program that connects to an online database using MySQL. It's working fine for me, in the debugging mode and as published as well. I've made this version available for other people so they could see what's going on right now, but they can't register nor login. Everyone is getting this message: "Acces denied for user 'svpenter' @' ip51cc873e.speed.planet.nl'* (using password: YES)
" *between the ' ' depends on the users, but the rest is the same...
How do I solve this?
greets Stefanvp
PS.: The username and password are both placed in the connection-string
Re: others can't connect to online database - brandonio21 - 08-13-2011
Hey! Welcome to the forums!
Well, this is an easy problem to solve, or atleast I am thinking so. On your actual MySQL Settings, you have the option to add a thing called 'Access Hosts' which are simply IP Addresses that can access the database. You need to specify a wildcard for other users.
Or atleast, I think that is the problem, please correct me if I am wrong!
Re: others can't connect to online database - Stefanvp - 08-14-2011
Thanks! This was indeed the solution. I taught earlier about it but my host was a pain in the... well... Thanks once more an I think I'll be coming her more often since my program keep coming with messages <!-- s:roll: --><img src="{SMILIES_PATH}/icon_rolleyes.gif" alt=":roll:" title="Rolling Eyes" /><!-- s:roll: -->
Re: others can't connect to online database - brandonio21 - 08-14-2011
Haha, well I am glad that worked, and I hope you don't have any more difficulties with this.
And please feel free to post more questions, and we will answer them to the best of our ability!