MySQL help

Discussion in 'General Off-Topic Chat' started by Skye07, Feb 18, 2008.

Feb 18, 2008

MySQL help by Skye07 at 9:17 PM (777 Views / 0 Likes) 7 replies

  1. Skye07
    OP

    Member Skye07 GBAtemp Fan

    Joined:
    Dec 24, 2006
    Messages:
    450
    Location:
    Belgium
    Country:
    Belgium
    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!
     
  2. Samutz

    Member Samutz Wet Tissue Sample

    Joined:
    Oct 4, 2004
    Messages:
    1,598
    Location:
    See that hole in your wall?
    Country:
    United States
    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.
     
  3. Sinkhead

    Former Staff Sinkhead yay p1ngpong.

    Joined:
    Nov 22, 2006
    Messages:
    3,692
    Location:
    Across the pond
    Country:
    United Kingdom
    Or you could get a proper web host
     
  4. Little

    Member Little I r Little

    Joined:
    Nov 20, 2006
    Messages:
    1,227
    Location:
    England
    Country:
    United Kingdom
    opening it up to anything beyond the local host is just ridiculously silly.
     
  5. Skye07
    OP

    Member Skye07 GBAtemp Fan

    Joined:
    Dec 24, 2006
    Messages:
    450
    Location:
    Belgium
    Country:
    Belgium
    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.
     
  6. Little

    Member Little I r Little

    Joined:
    Nov 20, 2006
    Messages:
    1,227
    Location:
    England
    Country:
    United Kingdom
    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.
     
  7. CockroachMan

    Member CockroachMan Scribbling around GBATemp's kitchen.

    Joined:
    Jan 14, 2006
    Messages:
    3,889
    Location:
    Brazil
    Country:
    Brazil
    I suggest making a website using PHP or ASP with some basic operations for your users.. I believe that is what most people do..
     
  8. Skye07
    OP

    Member Skye07 GBAtemp Fan

    Joined:
    Dec 24, 2006
    Messages:
    450
    Location:
    Belgium
    Country:
    Belgium
    Unfortunately I don't have enough knowledge of SQL to do that kind of thing >.<

    Oh well, thanks for the help guys [​IMG]
     

Share This Page