MySQL help

[Skye07]

Hey guys, I was wondering what I needed to do when I want to make an account for a mySQL database so it's accessable anywhere in the world. I've managed to make an account that works from anywhere on the home network but not more than that.

I use a no-ip thingy. So could anyone just post the queries I need to execute so it works?

Thanks in advance!

 

[Samutz]

SQLGRANT ALL ON *.* TO 'usernamehere'@'%';
This should work. Although, I highly suggest narrowing it down to a specific range or host for security reasons (eg. '123.123.123.%').
Don't forget to set a password to the username.
And don't forget that you need to open/forward the port on your firewall/router.

 

[Sinkhead]

Or you could get a proper web host

 

[Little]

opening it up to anything beyond the local host is just ridiculously silly.

 

[Skye07]

Why? I use the database for my MMORPG, the crew needs access to the database to add items, ... And I got a decent webhosting but I prefer to have the mysql database to be on the same computer as the game server.

 

[Little]

then you dont want to be opening up your mySQL... you want to be installing some form of interface between the server and the outside world. Cpanel is such example. or set up something where your "crew" just uploads it via ftp to somewhere like /sqlfiles and then have the server automatically run the SQL, email a report and delete the file via a cron job.

 

[CockroachMan]

I suggest making a website using PHP or ASP with some basic operations for your users.. I believe that is what most people do..

 

[Skye07]

then you dont want to be opening up your mySQL... you want to be installing some form of interface between the server and the outside world. Cpanel is such example. or set up something where your "crew" just uploads it via ftp to somewhere like /sqlfiles and then have the server automatically run the SQL, email a report and delete the file via a cron job.

Unfortunately I don't have enough knowledge of SQL to do that kind of thing >.<

Oh well, thanks for the help guys