How to set up a Remote MYSql Connection menu

These ads disappear when you log in.

Results 1 to 3 of 3
  1. #1
    SupernovaHH's Avatar Master Sergeant
    Reputation
    12
    Join Date
    May 2008
    Posts
    113
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    How to set up a Remote MYSql Connection

    (Pictures comming soon)

    What you will need:
    Heidisql or an SQL program (im using navicat)
    MYSql
    Port forwarding knowledge


    Step 1: Start by going to your router area on your web browser (type 192.168.1.1) and port forwarding port 3306 (check it by going to Open Port Check Tool)

    (alternative if you know how to port forward using firewall) Step 1: Go to your firewall settings and click Exceptions, then add port name mysql port 3306 tcp (and make another named mysql2 3306 udp)

    Step 2: open up navicat and double click your mysql connection. At the top you will see 'Manage Users' open that up and click add user.

    Step 3: add the username of the person you want to connect (like their account name on your server) then their EXTERNAL IP in the Host area then type a password for them (probably their account password)

    Step 4: after adding the account in navicat you will see a list of account names and to the right of the account names you will see check boxes. Click the account name on the left hand side you just created and click Select All then hit save. (This can be edited to your liking, after you hit select all i recommend removing Drop, Shutdown, Lock Tables, Delete and Grant. This prevents future damages to the server)

    Send the person the info for the mysql program and let them edit as they like.

    WARNING: ONLY DO THIS FOR SOMEONE YOU TRUST!
    If you do this without being able to completely trust the person, they can seriously damage your server. USE EXTREME CAUTION

    These ads disappear when you log in.

  2. #2
    da9elsolum's Avatar Sergeant
    Reputation
    1
    Join Date
    Dec 2006
    Posts
    45
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Sorry, but this is OLD. And there is also plenty of guides on this already..

  3. #3
    SupernovaHH's Avatar Master Sergeant
    Reputation
    12
    Join Date
    May 2008
    Posts
    113
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    i searched for this a few times and didnt find anything.. after i figured it out i decided to make this. but even so, its good to have i guess

Similar Threads

  1. [MySQL] How to Set it up (error nr. 1045)
    By nubblez in forum WoW EMU Guides & Tutorials
    Replies: 4
    Last Post: 05-10-2009, 12:49 PM
  2. how to set one char become a GM ?
    By kelanthang998 in forum World of Warcraft Emulator Servers
    Replies: 10
    Last Post: 09-10-2007, 04:19 PM
  3. how to set player as gm or 6 persmision
    By ilovethissite in forum World of Warcraft General
    Replies: 1
    Last Post: 12-27-2006, 09:07 AM
  4. How To Set Up A Private Server Using A Lan/wireless Network!!!
    By Chaos Lord in forum World of Warcraft Guides
    Replies: 4
    Last Post: 07-22-2006, 06:26 AM
All times are GMT -5. The time now is 12:25 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search