Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Tut] Connecting to Another persons MySql Database +mysql from web to pc.

Newbie Spellweaver
Joined
Jul 17, 2008
Messages
14
Reaction score
0
Guide connecting to mine or anothers MySql Database

So some people might think or question "Hmm is it possible to connect to
another persons MySql database hosted on their comp?"

Answer is Yes. And I will explain on how to do that

This method will also help for those who host on a domain and not their
own Pc

First you need MySql 5.0 and its Gui Tools I'm not going to provide it here
either most of you should have it or simply do a search on the forum and look
through repacks.

Second you need to enable remote access for starters who just installed MySql and
the GUI tools you should automatically be taken to setup your Server Instance Configuration
dont touch anything and keep clicking next until you get to the area where it
says Enable TCP/IP Networking you should see a check box "Add firewall exception for this port"
using the port 3306 keep in mind you would need to port forward that.
Continue clicking next until you reach the Modifiy Security Settings it's up to you
whether or not you want to use a password, but the important thing here is to
Enable root Access from remote machines Check that option and click next and finish installing.

For Users who have already setup their Server Instance Config and don't know
if they checked the enable remote access Go to your installed folder where Mysql
is and you can run it there and repeat step 2

Third Basically for this step all you need to do is Port Forward the port 3306
or whatever port you assigned your database on.

Fourth Connecting:
Now that your all configured , port forward , and etc. Time to test what you did
If you have another person lets say another GM you trust and knows MySql pretty well
Like executing scripts, changing variables, adding shops, items etc. use that person for
your test. So what you need to provide that person or if your the person reading
and wanting to connect you need their WAN IP, yes the familiar word ALOT of people
should know if not, go to write down your WAN IP.
Now the other person must have mysql and its gui tools in order for this to work
once that person is all setup you/person would start MySql Query browser now it shoulf
automatically bring up a login screen if your the one hosting leave it all alone
the localhost 3306 etc. But if your the one connecting under server host you put the
WAN IP on port 3306 and the default username should be root and password blank unless
you or the host has created one and the default schema odinms,vana,titan whichever you use
and click ok. You should now have access to the persons database and be able to change things.
if you get an error check your ports and make sure its been forwarded.

Extra
Ok this part of the tut is confusing, tricky, and at times seem frustrating.
So for example if you use a registration page to register people on a domain server
rather than a program like xamp,wamp,or abyss this will help you connect to your pc's database
rather than the one provided from a web hoster. ( continue this tommorow its late )

Hope this all helps.
 
Retired
Joined
Jul 25, 2008
Messages
188
Reaction score
29
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

Nice guide. I might even use it with my server. I am still setting up a website for Registering and downloading my client. :p
 
Newbie Spellweaver
Joined
Jul 17, 2008
Messages
14
Reaction score
0
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

I'll add some in a bit
 
Newbie Spellweaver
Joined
Apr 5, 2008
Messages
7
Reaction score
0
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

This guide is very hard to follow I didn't get past step 3
"For Users who have already setup their Server Instance Config and don't know
if they checked the enable remote access Go to your installed folder where Mysql
is and you can run it there and repeat step 2"
What do you mean "run it there" run what? Can you please add images or rewrite it?
 
Newbie Spellweaver
Joined
Jul 17, 2008
Messages
14
Reaction score
0
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

whats wrong with it? makes sense to me if you already setup your server instance config go to where you installed mysql c:/programs files/mysql or wherever you installed it open the folders and look for run Server Instance Config thats what i meant by run it there and repeat step 2. common sense
 
Junior Spellweaver
Joined
Jun 20, 2008
Messages
189
Reaction score
0
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

Nice Guild but needs some pictures
 
Experienced Elementalist
Joined
Apr 3, 2008
Messages
236
Reaction score
7
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

yea! Pics will be good. :p
 
Newbie Spellweaver
Joined
Mar 25, 2007
Messages
42
Reaction score
0
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

Dude, i cant even understand half of this :)

We appreciate your effort to help us, However, it didnt really help :(
 
Junior Spellweaver
Joined
Jul 29, 2008
Messages
111
Reaction score
0
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

It's easy..
 
Junior Spellweaver
Joined
Jun 30, 2008
Messages
132
Reaction score
0
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

Pics Plz
 
Master Summoner
Loyal Member
Joined
Jul 14, 2008
Messages
584
Reaction score
1
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

Nice Job :flag_schw
 
Newbie Spellweaver
Joined
Apr 29, 2008
Messages
75
Reaction score
0
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

Ty lol.
If you get an error just keep re-reading.
He explained it in readable text so it is possible to follow his instructions.
 
Newbie Spellweaver
Joined
Jul 25, 2008
Messages
26
Reaction score
0
Re: [Guide] Connecting to Another persons MySql Database +mysql from web to pc.

nice!! but i cant understand all of it -_-''add some pics will be cool
 
Newbie Spellweaver
Joined
Apr 5, 2009
Messages
69
Reaction score
0
krzyflipx - [Tut] Connecting to Another persons MySql Database +mysql from web to pc. - RaGEZONE Forums


i get stuck at the character screen still
i've done everything correctly, from mysql to wz files
help please !
 
Newbie Spellweaver
Joined
Jun 18, 2008
Messages
7
Reaction score
0
Hey, im following your guide atm, but when i try to end my configuration wizard, i get some problems.


Prob 1 : I NEED to make a password for root, its impossible to leave it blank,why?

Prob 2 : when i click on execute at the very end , the line with server restart failes and i get this error:
Failed to start the server Error:0

is this because i got MySQL server 6.0 and MYSQL gui tools 5.0? or not?
plz reply to me... thanks anyways
 
Newbie Spellweaver
Joined
Mar 1, 2009
Messages
63
Reaction score
1
would this teach hackers to hack your database and delete it or make them gm>?
 
Newbie Spellweaver
Joined
Apr 5, 2009
Messages
69
Reaction score
0
krzyflipx - [Tut] Connecting to Another persons MySql Database +mysql from web to pc. - RaGEZONE Forums


i get stuck at the character screen still
i've done everything correctly, from mysql to wz files
help please !
 
Back
Top