~~~~~~
UPDATES
~~~~~~
ADDED MORE FAQ =D
~~~~~~~~
DOWNLOADS
~~~~~~~~
1.
Well, This is my first guide, basically anything else posted other than the support section. I felt as if i taken enough from the Community, so i decided to give back. And this is what i created.
I was able to figure out how to get people in someone else's database. You know like, i'm hosting a server, and yet i want to let a GM in my database; yeah i figured that out! Well, this is basically all pictures and and such. But i sure hope this helps others with more updates and is able to get more work done faster with adding more shops and things like that.
This guide will work with anyone USING MySQL QUERY BROWSER & ADMINISTRATION! (If you installed the MySQL tools its the same thing)
Well first off, for other people that is going to connect to your database, you first MUST give them the program to MySQL tools. Once you have done that, tell them to install the program EXCTALLY like you have. Other wise, i dont think it will work.
Also, Before you do ANYTHING YOU MUST HAVE PORT 3306
After that you can actually test it yourself with your server. Just do what i did. If you have any problems post here. I will not respond to PM's. I will do my best to solve everyone's problem.
~~~~~
FAQ
~~~~~
Q: I am getting a Error 10060 (Can not connect)
A1: Either the person with the Database, does NOT Have port 3306 FORWARDED; or you are NOT using the correct IP/Username/password
A2: OR You are using the localhost for login and root for password.
Q: Do I need to have the 5.0 Server installed before i do this?!
A: No, You DO NOT need to have the 5.0 Server installed. However, you do need to have MySQL TOOLS. (Or all of the Tools)
Q: ~it dont work i get errors and yeah i have port 3306 fowarded and it still dont work~
A: Make sure the SERVER HOSTER of the MySQL has forwarded the port.
Q: now could you start a server from another computer using this, keeping the same ip that the servers usually on?
A: Simple really. However it could be VERY laggy. Its not tested but i would imigine it so. Do everything like normal in the guides on how to set up your server, But change the db.PROPERTIES. You will have to change the IP (To server host) and login details for YOU TO LOG INTO THEIR SERVER. (ill think of a better way soon.)
Q:could this allow my friend to host my server?
A: Yes. It can. However, If only one person is going to host the server, you might as well not share a connection from your comp to his comp. You should allow him to use MySQL, and you can monitor everything just by logging into MySQL to his computer.
Q:erm i still get error even portforwarded and i can't delete the account in mysql admin y?
A: Here is the simple way of fixing that, uninstall MySQL SERVER 5.0 (or what ever version) and re-install it. Then you can make another account for MySQL on your server.
UPDATES
~~~~~~
ADDED MORE FAQ =D
~~~~~~~~
DOWNLOADS
~~~~~~~~
1.
To view the content, you need to sign in or register
Well, This is my first guide, basically anything else posted other than the support section. I felt as if i taken enough from the Community, so i decided to give back. And this is what i created.
I was able to figure out how to get people in someone else's database. You know like, i'm hosting a server, and yet i want to let a GM in my database; yeah i figured that out! Well, this is basically all pictures and and such. But i sure hope this helps others with more updates and is able to get more work done faster with adding more shops and things like that.
This guide will work with anyone USING MySQL QUERY BROWSER & ADMINISTRATION! (If you installed the MySQL tools its the same thing)
Well first off, for other people that is going to connect to your database, you first MUST give them the program to MySQL tools. Once you have done that, tell them to install the program EXCTALLY like you have. Other wise, i dont think it will work.
Also, Before you do ANYTHING YOU MUST HAVE PORT 3306
To view the content, you need to sign in or register
! Or else it will only result to errors.
To view the content, you need to sign in or register
To view the content, you need to sign in or register
To view the content, you need to sign in or register
To view the content, you need to sign in or register
To view the content, you need to sign in or register
After that you can actually test it yourself with your server. Just do what i did. If you have any problems post here. I will not respond to PM's. I will do my best to solve everyone's problem.
~~~~~
FAQ
~~~~~
Q: I am getting a Error 10060 (Can not connect)
A1: Either the person with the Database, does NOT Have port 3306 FORWARDED; or you are NOT using the correct IP/Username/password
A2: OR You are using the localhost for login and root for password.
Q: Do I need to have the 5.0 Server installed before i do this?!
A: No, You DO NOT need to have the 5.0 Server installed. However, you do need to have MySQL TOOLS. (Or all of the Tools)
Q: ~it dont work i get errors and yeah i have port 3306 fowarded and it still dont work~
A: Make sure the SERVER HOSTER of the MySQL has forwarded the port.
Q: now could you start a server from another computer using this, keeping the same ip that the servers usually on?
A: Simple really. However it could be VERY laggy. Its not tested but i would imigine it so. Do everything like normal in the guides on how to set up your server, But change the db.PROPERTIES. You will have to change the IP (To server host) and login details for YOU TO LOG INTO THEIR SERVER. (ill think of a better way soon.)
Q:could this allow my friend to host my server?
A: Yes. It can. However, If only one person is going to host the server, you might as well not share a connection from your comp to his comp. You should allow him to use MySQL, and you can monitor everything just by logging into MySQL to his computer.
Q:erm i still get error even portforwarded and i can't delete the account in mysql admin y?
A: Here is the simple way of fixing that, uninstall MySQL SERVER 5.0 (or what ever version) and re-install it. Then you can make another account for MySQL on your server.
Last edited: