Look at the documentation regarding the users table in the mysql database. You can specify an ip address (or subset of an ip address) on which users are allowed to connect; others are rejected, via the hosts column.
IE if you specify 192.168.1.%, any user on the 192.168.1 portion of the network (ie 192.168.1.1, 192.168.1.2, 192.168.1.3, etc up to 192.168.1.255) are allowed to connect. Since you are connecting via a vpn, it sounds like an IP address will be handed out by the VPN, and you should be able to establish some security with your connections. You can have different rules for different users and hosts. IE you can set it up so that the "Fred" user on localhost doesn't need a password, but Susan on 192.168.1.% does. And you can also set it up so that Susan can't modify any data in Table A (just read data, not write), etc. The permissions setup in MySQL is really good; very flexible. Don't screw up the users table, though, as you might find yourself unable to connect from any machine. Look at the MySQL Admin tool (or some other tool). I believe that it has a GUI that lets you add/edit/remove users painlessly (and reduces the risk of screw ups). This list is not a great place to ask about Firebird. David. ----- Original Message ----- From: "The masked marvel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, May 01, 2004 4:52 PM Subject: Accessing DBMS remotely: MySQL? FireBird? > Hi, > > Some of our customers have remote offices. I was wondering if it'd be safe > to have a DBMS running at their central office, and have our client > application running on hosts in the branches connect to it through a VPN > via the Net? > > What happens if the connection goes south while a branch office was making > changes? Does the DBMS just rollbacks changes automatically after a time-out? > > Should we set up some kind of replication instead? > > Also, are there compeling reasons to go for Firebird instead of MySQL? I > don't know enough about the capabilities of each DBMS today to make an > educated choice. > > Thank you for any tip > Fred. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
