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

[krzyflipx]

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 http://whatismyip.com/ 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.

[Quiver]

Nice guide. I might even use it with my server. I am still setting up a website for Registering and downloading my client. :P

[Roamer]

images

[krzyflipx]

I'll add some in a bit

[illibis]

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?

[krzyflipx]

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

[pandalov3r]

Nice Guild but needs some pictures

[b0ib0ii]

yea! Pics will be good. :P

[tnt12340]

Dude, i cant even understand half of this :)

We appreciate your effort to help us, However, it didnt really help :(

[Rainstruck]

It's easy..

[lols1996]

Pics Plz

[gtxx911]

Nice Job :flag_schw

[ketchup02]

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.

[tgf914520]

nice!! but i cant understand all of it -_-''add some pics will be cool

[xxolivionxx]

Hey dude very nice guide!

im gonna test it now!