[Help] Accessing databases

Newbie Spellweaver
Joined
Oct 17, 2007
Messages
11
Reaction score
0
I was wondering if there was a way for others to access your database. For example, they might want to change someone's stats so they would just have to access my database and just change it.
 
You have to forward port 3306 UDP and TCP and give them your MySQL information, and you'll need to allow external access to the mysql user, which you can do in PhpMyAdmin, go to Privaleges edit the user account and change the 'host' to %. make sure your account has a secure password or anyone can log in and change info etc
 
You have to forward port 3306 UDP and TCP and give them your MySQL information, and you'll need to allow external access to the mysql user, which you can do in PhpMyAdmin, go to Privaleges edit the user account and change the 'host' to %. make sure your account has a secure password or anyone can log in and change info etc

If you dont have a router, no need to portforward.
The external access permition part is right, by default the root user cant login from remote computers.
Also, dont forget to look if phpmyadmin isnt accessable by yourip/phpmyadmin(just an example).
 
Back