Reply
[Tutorial] HeidiSQL Remote Access Setup! :: [Easy Guide]  
Old 03-11-2008, 04:37 PM   #1
killer911pt
 
killer911pt's Avatar
 
Join Date: Feb 2008
Location: Canterbury, UK
Posts: 904
killer911pt is a jewel in the rough
Ok so for remote access i suggest you follow the "Prevent your server from being hacked" guide first

So to setup remote access you first need to understand how you connect from the remote pc

This works by connectiong to your hosts PC's EXTERNAL ip address with the correct username and password allowing you to edit the database from another pc!

The First Decision!
Static IP: Follow Step 5a not 5b
Dynamic IP: Follow Stem 5b not 5a

Main Setup
1.) Install HeidiSQL on BOTH PC's
2.) Open HS (I will refer to HeidiSQL as HS Throught This Guide) And Click this icon
3.)Click "Global Access"
4.)Enter a Username and Password
5a.) Static IP Change "From Host" to the remote PC's EXTERNAL ip address
5b.) Leave "From Host" as a "%" (Note: this will compromise security if you haven't followed the guide mentioned above)
6.)Check "All Privilages"
7.)Click "Add User"

8.) Close HS
Main Setup Complete!

Remote PC
1.) Open HS
2.) Fill in the data like so (Screenshot is messed up so i will explain)

3.) Fill in "Hostname/IP" With your server Hostname or the Host's EXTERNAL Ip
4.) Fill in Username with the username registered on the Hosts PC
5.) Password same as above but with the password you registered
6.) Click Connect!
7.) You should Now Be Connected to the DATABASE remotely
Remote Setup Complete!

Post any problems below!
killer911pt is offline   Reply With Quote
 
Old 03-11-2008, 05:53 PM   #2
Raman
 
Raman's Avatar
 
Join Date: Dec 2007
Location: Up your A$$!
Posts: 291
Raman will become famous soon enough
nice guide +rep!
Raman is offline   Reply With Quote
 
Old 03-11-2008, 07:38 PM   #3
killer911pt
 
killer911pt's Avatar
 
Join Date: Feb 2008
Location: Canterbury, UK
Posts: 904
killer911pt is a jewel in the rough
Thanks my first +rep ^^
killer911pt is offline   Reply With Quote
 
Old 03-12-2008, 12:30 AM   #4
bloodexile
 
bloodexile's Avatar
 
Join Date: Feb 2008
Posts: 71
bloodexile is an unknown quantity at this point
Im getting a message saying i cant connnect using password yes.. wtf?
bloodexile is offline   Reply With Quote
 
Old 03-14-2008, 09:03 PM   #5
damagedealer
 
Join Date: Oct 2007
Posts: 48
damagedealer is an unknown quantity at this point
umm.....it says cannot connect....im on the same network as the computer that runs the heidisql and i followed ur dircetions.....however we both have the same external ip....is that whats causing the problem?
damagedealer is offline   Reply With Quote
 
Old 03-14-2008, 09:06 PM   #6
wartick
 
wartick's Avatar
 
Join Date: Jun 2007
Location: Finland
Posts: 1,825
wartick is a jewel in the rough
Nope, i guess you coud try to connect via Internal ip?
And are the paswords correct?
wartick is offline   Reply With Quote
 
Old 03-14-2008, 09:13 PM   #7
damagedealer
 
Join Date: Oct 2007
Posts: 48
damagedealer is an unknown quantity at this point
yea...i went into heidisql and made a username and pass.....put all info into my computer which is on the same network via router....and then put in the ip to the computer im trying to connect to....then ehh nothing...sigh

im using hamachi also...so idk if that matters

Last edited by damagedealer; 03-14-2008 at 09:15 PM. Reason: Automerged Doublepost
damagedealer is offline   Reply With Quote
 
Old 03-14-2008, 09:17 PM   #8
wartick
 
wartick's Avatar
 
Join Date: Jun 2007
Location: Finland
Posts: 1,825
wartick is a jewel in the rough
Well i ment is the Servercomputers, heidis and MySQL's paswords correct.
wartick is offline   Reply With Quote
 
Old 03-14-2008, 09:26 PM   #9
damagedealer
 
Join Date: Oct 2007
Posts: 48
damagedealer is an unknown quantity at this point
how do i check that....i think the pass for my mysql...is ascent.... but im not really sure how to check what ur asking srry...and thanks for helping me btw

do u have a windows messanger or aim that i can talk to u from ?

Last edited by damagedealer; 03-14-2008 at 09:32 PM. Reason: Automerged Doublepost
damagedealer is offline   Reply With Quote
 
Old 03-14-2008, 09:34 PM   #10
wartick
 
wartick's Avatar
 
Join Date: Jun 2007
Location: Finland
Posts: 1,825
wartick is a jewel in the rough
Yes i have MSN (see my info tab) but anyways i will go to sleep now.
wartick is offline   Reply With Quote
 
Old 05-29-2008, 11:15 PM   #11
killer911pt
 
killer911pt's Avatar
 
Join Date: Feb 2008
Location: Canterbury, UK
Posts: 904
killer911pt is a jewel in the rough
dont change yoiur conf files
killer911pt is offline   Reply With Quote
Help  
Old 06-18-2008, 09:53 AM   #12
tommyrego
 
Join Date: May 2008
Posts: 34
tommyrego is an unknown quantity at this point
I did everything u said but still my friend cant conect to my host plz add me in msn tomasrego9@hotmail.com
tommyrego is offline   Reply With Quote
 
Old 06-26-2008, 07:44 PM   #13
mcilduff
 
mcilduff's Avatar
 
Join Date: Apr 2008
Location: 38/100 Until Power User Getting There XD
Posts: 342
mcilduff has a spectacular aura about
Nice Guide tanks.

<('_')> Mcilduff <('_')>
mcilduff is offline   Reply With Quote
 
Old 06-27-2008, 07:40 AM   #14
Myerz
I walk like a pimp... foo
 
Myerz's Avatar
 
Join Date: Feb 2008
Location: 0110110101001011010010
Posts: 990
Myerz has a brilliant futureMyerz has a brilliant futureMyerz has a brilliant futureMyerz has a brilliant future
great guide! +Rep
Myerz is offline   Reply With Quote
Hello about my external ip  
Old 07-07-2008, 11:28 PM   #15
kramslas
 
Join Date: Jun 2008
Posts: 38
kramslas is an unknown quantity at this point
I have done everything it stood but when i try to push logonserver it stands acces denied for user root@my eternal ip using password yes whats wrong anyone knows ?

Last edited by kramslas; 07-08-2008 at 12:05 AM.
kramslas is offline   Reply With Quote
 
Old 07-08-2008, 10:59 PM   #16
xUPx Undead Pro
 
xUPx Undead Pro's Avatar
 
Join Date: Apr 2008
Location: Alabama
Posts: 96
xUPx Undead Pro is an unknown quantity at this point
tyvm + rep
xUPx Undead Pro is offline   Reply With Quote
 
Old 07-08-2008, 11:22 PM   #17
heavyq
 
Join Date: Jul 2008
Posts: 7
heavyq is an unknown quantity at this point
Sweet I am able to access my DB at work. Thanks a bunch!!!!! +rep
heavyq is offline   Reply With Quote
 
Old 07-17-2008, 11:41 PM   #18
Langeland
 
Join Date: May 2008
Posts: 10
Langeland is an unknown quantity at this point
Please make this in a Navicat tutorial 2 or just help me out as me for my msn over pm
Langeland is offline   Reply With Quote
 
Old 07-18-2008, 10:28 AM   #19
killer911pt
 
killer911pt's Avatar
 
Join Date: Feb 2008
Location: Canterbury, UK
Posts: 904
killer911pt is a jewel in the rough
ill make a navicat 1!
killer911pt is offline   Reply With Quote
 
Old 08-05-2008, 06:29 PM   #20
Roro
 
Roro's Avatar
 
Join Date: Jul 2008
Posts: 117
Roro is an unknown quantity at this point
nice guide +rep , does Navicat work the same way?
Roro is offline   Reply With Quote
 
Old 08-05-2008, 06:41 PM   #21
QQrofl
http://d2-gaming.com
 
QQrofl's Avatar
 
Join Date: May 2008
Location: http://d2-gaming.com -- Yeah!
Posts: 10,010
QQrofl has a reputation beyond reputeQQrofl has a reputation beyond reputeQQrofl has a reputation beyond reputeQQrofl has a reputation beyond reputeQQrofl has a reputation beyond reputeQQrofl has a reputation beyond reputeQQrofl has a reputation beyond reputeQQrofl has a reputation beyond reputeQQrofl has a reputation beyond reputeQQrofl has a reputation beyond reputeQQrofl has a reputation beyond repute
This is 5 months old guess its still useful tho
QQrofl is offline   Reply With Quote
 
Old 08-29-2008, 12:08 PM   #22
killer911pt
 
killer911pt's Avatar
 
Join Date: Feb 2008
Location: Canterbury, UK
Posts: 904
killer911pt is a jewel in the rough
yea i posted this like when i joined ac-web

Quote:
Originally Posted by damagedealer View Post
umm.....it says cannot connect....im on the same network as the computer that runs the heidisql and i followed ur dircetions.....however we both have the same external ip....is that whats causing the problem?
Thats impossible to both have the same external ip!

Last edited by killer911pt; 08-29-2008 at 12:11 PM. Reason: Automerged Doublepost
killer911pt is offline   Reply With Quote
 
Old 08-29-2008, 08:43 PM   #23
shadowater99
 
Join Date: Mar 2008
Posts: 105
shadowater99 is on a distinguished road
+rep lol wow i had to figure that out on my own lolz
shadowater99 is offline   Reply With Quote
 
Old 09-12-2008, 02:15 AM   #24
swanitalia
 
swanitalia's Avatar
 
Join Date: Mar 2008
Posts: 34
swanitalia is on a distinguished road
when i try to logon my DB from my other computer, i get a error that says "my comps name" is not allowed to connect to MySQL server.
swanitalia is offline   Reply With Quote
 
Old 01-16-2009, 06:08 PM   #25
bartender
 
Join Date: Sep 2007
Posts: 4
bartender is an unknown quantity at this point
[QUOTE=killer911pt;257080]yea i posted this like when i joined ac-web



Thats impossible to both have the same external ip![/QUOTE]

nah it isnt i am having the same problem (good guide +rep)
bartender is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT. The time now is 02:20 AM.

All times are GMT. The time now is 02:20 AM. Contact Us - AC Web - Archive - Privacy Statement - Top