networking - Connecting to MySQL Database over server -

i'm quite beginner when comes working networks , like, apologizes front. while set mysql database locally on machine, , have built number of simple programs work it. (aka root:localhost sort of thing). has been great, i'm hoping allow other colleagues @ work access database machines, have no idea how.

likely there network protection issues (firewalls etc), may need taken account... (although have it's on this, neither or myself know required 'connect' database).

for example, ip need? have change setup of database? understand localhost not work colleagues computer's, obvious reasons, have no idea go in place others access it.

i not mind having machine run dedicated database machine... not able run off dedicated server or that, beyond machine.

any appreciated! thanks

edit: suggestions - go through them tomorrow when i'm bit more awake! solid though.

first of all, colleagues need are:

• the ip address mysql server running.
• user , password connect remotely
• have port 3306 open on network
• a mysql client (mysql workbench, mysql query browser, toad, heidi or command line tool).

when create user in mysql have this:

'root'@'localhost' 

that means, user work if connect localhost user root. can create user allowed connect anywhere:

'juanperez'@'%' 

and have careful privileges granting them. not forget comment line in options file of mysql says "bind-address" (this options prevents remote connection).