[Tutorial] HeidiSQL Remote Access Setup! :: [Easy Guide]

killer911pt · 03-11-2008, 04:37 PM

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!

Raman · 03-11-2008, 05:53 PM

nice guide +rep!

killer911pt · 03-11-2008, 07:38 PM

Thanks my first +rep ^^

bloodexile · 03-12-2008, 12:30 AM

Im getting a message saying i cant connnect using password yes.. wtf?

damagedealer · 03-14-2008, 09:03 PM

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?

wartick · 03-14-2008, 09:06 PM

Nope, i guess you coud try to connect via Internal ip?
And are the paswords correct?

damagedealer · 03-14-2008, 09:13 PM

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

wartick · 03-14-2008, 09:17 PM

Well i ment is the Servercomputers, heidis and MySQL's paswords correct.

damagedealer · 03-14-2008, 09:26 PM

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 ?

wartick · 03-14-2008, 09:34 PM

Yes i have MSN (see my info tab) but anyways i will go to sleep now.

killer911pt · 05-29-2008, 11:15 PM

dont change yoiur conf files

tommyrego · 06-18-2008, 09:53 AM

I did everything u said but still my friend cant conect to my host plz add me in msn tomasrego9@hotmail.com

mcilduff · 06-26-2008, 07:44 PM

Nice Guide tanks.

<('_')> Mcilduff <('_')>

Myerz · 06-27-2008, 07:40 AM

great guide! +Rep

kramslas · 07-07-2008, 11:28 PM

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 ?

xUPx Undead Pro · 07-08-2008, 10:59 PM

tyvm + rep

heavyq · 07-08-2008, 11:22 PM

Sweet I am able to access my DB at work. Thanks a bunch!!!!! +rep

Langeland · 07-17-2008, 11:41 PM

Please make this in a Navicat tutorial 2 or just help me out as me for my msn over pm

killer911pt · 07-18-2008, 10:28 AM

ill make a navicat 1!

Roro · 08-05-2008, 06:29 PM

nice guide +rep

, does Navicat work the same way?

QQrofl · 08-05-2008, 06:41 PM

This is 5 months old

guess its still useful tho

killer911pt · 08-29-2008, 12:08 PM

yea i posted this like when i joined ac-web

Quote:

Originally Posted by damagedealer

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!

shadowater99 · 08-29-2008, 08:43 PM

+rep lol wow i had to figure that out on my own lolz

swanitalia · 09-12-2008, 02:15 AM

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.

bartender · 01-16-2009, 06:08 PM

[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)

03-14-2008, 09:13 PM	#7
damagedealer Join Date: Oct 2007 Posts: 48	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

03-14-2008, 09:26 PM	#9
damagedealer Join Date: Oct 2007 Posts: 48	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

07-07-2008, 11:28 PM	#15
kramslas Join Date: Jun 2008 Posts: 38	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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

03-11-2008, 04:37 PM	#1
killer911pt Join Date: Feb 2008 Location: Canterbury, UK Posts: 904	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!

03-11-2008, 05:53 PM	#2
Raman Join Date: Dec 2007 Location: Up your A$$! Posts: 291	nice guide +rep!

03-11-2008, 07:38 PM	#3
killer911pt Join Date: Feb 2008 Location: Canterbury, UK Posts: 904	Thanks my first +rep ^^

03-12-2008, 12:30 AM	#4
bloodexile Join Date: Feb 2008 Posts: 71	Im getting a message saying i cant connnect using password yes.. wtf?

03-14-2008, 09:03 PM	#5
damagedealer Join Date: Oct 2007 Posts: 48	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?

03-14-2008, 09:06 PM	#6
wartick Join Date: Jun 2007 Location: Finland Posts: 1,825	Nope, i guess you coud try to connect via Internal ip? And are the paswords correct?

03-14-2008, 09:17 PM	#8
wartick Join Date: Jun 2007 Location: Finland Posts: 1,825	Well i ment is the Servercomputers, heidis and MySQL's paswords correct.

03-14-2008, 09:34 PM	#10
wartick Join Date: Jun 2007 Location: Finland Posts: 1,825	Yes i have MSN (see my info tab) but anyways i will go to sleep now.

05-29-2008, 11:15 PM	#11
killer911pt Join Date: Feb 2008 Location: Canterbury, UK Posts: 904	dont change yoiur conf files

06-18-2008, 09:53 AM	#12
tommyrego Join Date: May 2008 Posts: 34	I did everything u said but still my friend cant conect to my host plz add me in msn tomasrego9@hotmail.com

06-26-2008, 07:44 PM	#13
mcilduff Join Date: Apr 2008 Location: 38/100 Until Power User Getting There XD Posts: 342	Nice Guide tanks. <('_')> Mcilduff <('_')>

06-27-2008, 07:40 AM	#14
Myerz I walk like a pimp... foo Join Date: Feb 2008 Location: 0110110101001011010010 Posts: 990	great guide! +Rep

07-08-2008, 10:59 PM	#16
xUPx Undead Pro Join Date: Apr 2008 Location: Alabama Posts: 96	tyvm + rep

07-08-2008, 11:22 PM	#17
heavyq Join Date: Jul 2008 Posts: 7	Sweet I am able to access my DB at work. Thanks a bunch!!!!! +rep

07-17-2008, 11:41 PM	#18
Langeland Join Date: May 2008 Posts: 10	Please make this in a Navicat tutorial 2 or just help me out as me for my msn over pm

07-18-2008, 10:28 AM	#19
killer911pt Join Date: Feb 2008 Location: Canterbury, UK Posts: 904	ill make a navicat 1!

08-05-2008, 06:29 PM	#20
Roro Join Date: Jul 2008 Posts: 117	nice guide +rep , does Navicat work the same way?

08-05-2008, 06:41 PM	#21
QQrofl http://d2-gaming.com Join Date: May 2008 Location: http://d2-gaming.com -- Yeah! Posts: 10,010	This is 5 months old guess its still useful tho

08-29-2008, 08:43 PM	#23
shadowater99 Join Date: Mar 2008 Posts: 105	+rep lol wow i had to figure that out on my own lolz

09-12-2008, 02:15 AM	#24
swanitalia Join Date: Mar 2008 Posts: 34	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.

01-16-2009, 06:08 PM	#25
bartender Join Date: Sep 2007 Posts: 4	[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)