maxnorris wrote:Well, if they're on the same network, you just need to edit the permissions. For example, you can have a username at localhost, then you can add the same username from a different host name. (You can allow any host too)
If you're doing this over the internet, you'll need to allow the SQL connection through your firewall. Ummm errrr port 3309 if I recall? I'd Google that to be sure, haven't had coffee yet.
Just note that doing either of those is really opening you up to security holes, especially allowing internet access to your database server.
Edit: Double checked, I was close, 3306. Still a bad idea though. If you're making an online game, that should be entirely handled by the server. There's no reason a game client should ever access the database directly.
ldivinag wrote:can you describe HOW THE user will be using the db?
if through the game, then let your own software handle the connections.
that way, they dont have a direct way of manipulating the data, which can open up tons of security issues.
Makuro wrote:What did you configure for allowed host for the username?
when you create a new user, you got the option to enter a host from which the user is allowed to connect.
for this you got several options.
means the user is only allowed to connect from the localhost e.g. webinterfaces, bash, etc
means the user is only allowed to connect from this one IP address and not from any else
means the user can access from anywhere
means the user can access from the domain and its ip
now the question, what did you configure if you created the user ?
Users browsing this forum: No registered users and 77 guests