How i allow other people connect MySQL Database?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How i allow other people connect MySQL Database?

Postby FunnyMaker » 23. April 2007 11:18

How i allow other people connect MySQL Database?
I make online game and i need that people could connect to database! :D
FunnyMaker
 
Posts: 22
Joined: 02. December 2006 09:51

Postby maxnorris » 23. April 2007 15:57

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.
maxnorris
 
Posts: 17
Joined: 21. August 2006 06:51

Postby FunnyMaker » 28. April 2007 20:12

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.

If a bad idea then i will use http://www.freesql.org/... :o
FunnyMaker
 
Posts: 22
Joined: 02. December 2006 09:51

Postby ldivinag » 29. April 2007 23:52

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.
leo d.
User avatar
ldivinag
 
Posts: 40
Joined: 19. April 2006 04:18

Postby FunnyMaker » 23. May 2007 20:24

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.

How can i?
It says MyIP is not allowed to connect. :(
FunnyMaker
 
Posts: 22
Joined: 02. December 2006 09:51

Postby Makuro » 23. May 2007 23:05

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.

1st localhost
means the user is only allowed to connect from the localhost e.g. webinterfaces, bash, etc
2nd 192.168.1.1
means the user is only allowed to connect from this one IP address and not from any else
3rd %
means the user can access from anywhere
4th domain.dyndns.org
means the user can access from the domain and its ip

now the question, what did you configure if you created the user ? :)
jedes Kind braucht Großeltern!
Es sind die einzigen Personen die bezeugen können , das die eigenen Eltern nicht besser waren.
Makuro
 
Posts: 17
Joined: 23. May 2007 12:23

Postby FunnyMaker » 24. May 2007 11:26

What happens if i forgot my username and password? How i can remind it? Does there any file/folder?
Because i'm not remember i change the password/username.
FunnyMaker
 
Posts: 22
Joined: 02. December 2006 09:51

Postby FunnyMaker » 25. May 2007 23:12

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.

1st localhost
means the user is only allowed to connect from the localhost e.g. webinterfaces, bash, etc
2nd 192.168.1.1
means the user is only allowed to connect from this one IP address and not from any else
3rd %
means the user can access from anywhere
4th domain.dyndns.org
means the user can access from the domain and its ip

now the question, what did you configure if you created the user ? :)

I choose %. :)
But i still can't connect. :( What problem is now?
FunnyMaker
 
Posts: 22
Joined: 02. December 2006 09:51


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 41 guests