Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
others can't connect to online database
#1
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
#2
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!
My Blog | My Setup | My Videos | Have a wonderful day.
#3
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: -->
#4
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!
My Blog | My Setup | My Videos | Have a wonderful day.


Possibly Related Threads…
Thread Author Replies Views Last Post
  Help Online Public Access Catalog ryunaga63 0 6,149 08-20-2012, 08:16 PM
Last Post: ryunaga63
  2 Listboxes and database qazinasir 7 26,012 07-22-2012, 09:41 PM
Last Post: brandonio21
  VB2010 & MS Access Database kismetgerald 3 14,702 01-10-2012, 10:35 PM
Last Post: kismetgerald
  connect to online database elnashar77 3 14,721 08-09-2011, 01:27 PM
Last Post: brandonio21
  connect to mysql client cry1978 2 11,104 07-12-2011, 11:09 AM
Last Post: brandonio21
  DataBase - Login - Not Working Murcs 4 17,128 07-02-2011, 09:46 AM
Last Post: brandonio21

Forum Jump:


Users browsing this thread: 1 Guest(s)