MySQL help

Skye07

Well-Known Member
OP
Member
Joined
Dec 24, 2006
Messages
450
Trophies
0
Location
Belgium
Website
www.skyon.be
XP
439
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!
 

Samutz

Well-Known Member
Member
Joined
Oct 4, 2004
Messages
1,598
Trophies
1
Website
samutz.com
XP
362
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.
 

Skye07

Well-Known Member
OP
Member
Joined
Dec 24, 2006
Messages
450
Trophies
0
Location
Belgium
Website
www.skyon.be
XP
439
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.
 

Little

I r Little
Member
Joined
Nov 20, 2006
Messages
1,226
Trophies
0
Age
35
Location
England
XP
227
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.
 

Skye07

Well-Known Member
OP
Member
Joined
Dec 24, 2006
Messages
450
Trophies
0
Location
Belgium
Website
www.skyon.be
XP
439
Country
Belgium
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
smile.gif
 

You may also like...

General chit-chat
Help Users
  • No one is chatting at the moment.
  • Psionic Roshambo @ Psionic Roshambo:
    Psi has a new girlfriend but I have known her for like 28 years
    +1
  • The Catboy @ The Catboy:
    Is she you?
    +1
  • K3N1 @ K3N1:
    Psi just become a sparkling vampire already
    +1
  • Psionic Roshambo @ Psionic Roshambo:
    The Catboy it's weird there was always something between us.... But neither of us was single at the same time.... But last night we found out we both are... And hmmm 🥰
    +1
  • Psionic Roshambo @ Psionic Roshambo:
    She has all my weak points smart funny blonde and she lights up the room when she walks in and nothing else exists when she is there
    +1
  • Psionic Roshambo @ Psionic Roshambo:
    I would eat the corn out of her.... Lol
    +1
  • Veho @ Veho:
    Psi! You're alive!
    +1
  • Veho @ Veho:
    ...and you have yet another new
    girlfried :rolleyes:
    +1
  • Veho @ Veho:
    MAKE HER SIGH A PRENUP
    +1
  • cearp @ cearp:
    PSI <3 🌽
    +1
  • Psionic Roshambo @ Psionic Roshambo:
    Lol Veho I'm down to 3
    +1
  • Psionic Roshambo @ Psionic Roshambo:
    Dumping one soon
    +1
  • Psionic Roshambo @ Psionic Roshambo:
    My Facebook has like 120 women now or something lol
    +1
  • Psionic Roshambo @ Psionic Roshambo:
    Each one hotter than the last...
    +1
  • K3N1 @ K3N1:
    Ordered a new SSD
    +1
  • Psionic Roshambo @ Psionic Roshambo:
    Your mom's an SSD lol
    +1
  • K3N1 @ K3N1:
    Your mom writes to me fast
    +1
  • K3N1 @ K3N1:
    I haven't placed an order with Newegg since like 2016 lol
    +1
  • Psionic Roshambo @ Psionic Roshambo:
    Amazon Is better lol
    +1
  • K3N1 @ K3N1:
    Hard to find a fast 2tb SSD for 130
    +1
  • Peretti @ Peretti:
    lately I downloaded super mario galaxy for wii, but in the first phase, right in the first cutscene of the game, the game freezes in that part, with the image appearing but completely frozen. I already had this problem with pikmin 2 but in the end I couldn't fix the problem. Has anyone had this problem, and if so, did you find a solution?
  • K3N1 @ K3N1:
    Moms spaghetti
  • M4x1mumReZ @ M4x1mumReZ:
    @Peretti, Ask you question in the Wii section of the forum.
    M4x1mumReZ @ M4x1mumReZ: @Peretti, Ask you question in the Wii section of the forum.