DB edit

[kimura0715]

is there a way that i can give access to my GM assistant to help customize my database. how can we share the DB so that we can both work on it? thanks....

[trevius]

First, set Port Range Forwarding on your router for port 3306 to your server. Then, create a MySQL account for your developer so they can log into MySQL on your server. If you know the IP they are coming from and their IP doesn't change, you can add more security by creating the MySQL account to only work from a specified host (their IP address). You will also need to make sure you have MySQL setup to allow remote access. If you are on Windows, you just need to go through the MySQL setup program again and check the box near the end of the setup process that let you allow remote connections. If you are using Linux, then it is a bit more complex than that, but the Debian Linux Setup Wiki page describes how to do it. Then, they should just need to setup Navicat or any other MySQL tool and they will be able to do edits.

[kimura0715]

thanks trevius..a big help as always

[pfyon]

GRANT ALL ON eqemu.* TO 'gmaccount'@'%' IDENTIFIED BY 'gmpassword'; is the sql to create an account named "gmaccount" with the password "gmpassword" that can access the database named "eqemu" from any ip address (the % is a wildcard). As Trevius said, if you know the gm has a static ip or always connects from a specific hostname, you can change the ip to be like '173.22.166.22' or '192.168.1.%' (for any ip on the lan), or even '%.example.com'.

You should look at http://dev.mysql.com/doc/refman/5.1/en/grant.html to see the syntax for grant as you probably don't need/want to grant all privileges to a gm (he or she probably doesn't need drop, for example) for security purposes.

Of course, there's probably an option in a gui mysql admin program to set this up as well.