PDA

View Full Version : got a question How to access DB from remote computer?


kouhei
05-11-2005, 12:18 PM
I got a server up and running and I would like someone to be able to connect to my emu DB to edit things like items and stuff. I belive it is possible to setup to allow them to be able to connect to edit the DB. But not sure how to do it. Any1 know what needs to be done to allow this person connect to the DB to edit. What needs to be done on server side and what needs to be done on their client side?

ZozzET
05-11-2005, 06:13 PM
You'll have to create a username/pass for them (unless you want to give them root or whatever you're using already)...and set the host as their their IP address, or their domain. My ISP is roadrunner, so if you were to add me for ex...you could either put in my IP address, or something like *.rr.com under host.

Here's the actual MySQL manual on adding accounts:
MySQL Manual - Adding Users (http://dev.mysql.com/doc/mysql/en/adding-users.html)

Belfedia
05-11-2005, 09:46 PM
Use frontend for mysql like : http://www.phpmyadmin.net/home_page/index.php
You can manage user , privileges and password.
User can modify DB with a simple internet browser :)