- 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
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.
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
To view the content, you need to sign in or register
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.
![krzyflipx - [Tut] Connecting to Another persons MySql Database +mysql from web to pc. - RaGEZONE Forums](http://i84.photobucket.com/albums/k35/ansoncai/mapleserver4.jpg "krzyflipx - [Tut] Connecting to Another persons MySql Database +mysql from web to pc. - RaGEZONE Forums")
