MySQL help

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

  1. Skye07
    OP

    Skye07 GBAtemp Fan

    Member
    450
    0
    Dec 24, 2006
    Belgium
    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

    Samutz Wet Tissue Sample

    Member
    1,598
    2
    Oct 4, 2004
    United States
    See that hole in your wall?
    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

    Sinkhead yay p1ngpong.

    Former Staff
    3,692
    0
    Nov 22, 2006
    Across the pond
    Or you could get a proper web host
     
  4. Little

    Little I r Little

    Member
    1,227
    11
    Nov 20, 2006
    England
    opening it up to anything beyond the local host is just ridiculously silly.
     
  5. Skye07
    OP

    Skye07 GBAtemp Fan

    Member
    450
    0
    Dec 24, 2006
    Belgium
    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

    Little I r Little

    Member
    1,227
    11
    Nov 20, 2006
    England
    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

    CockroachMan Scribbling around GBATemp's kitchen.

    Member
    3,889
    4
    Jan 14, 2006
    Brazil
    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

    Skye07 GBAtemp Fan

    Member
    450
    0
    Dec 24, 2006
    Belgium
    Belgium
    Unfortunately I don't have enough knowledge of SQL to do that kind of thing >.<

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