Hi,

I'm building a mysql database which is accessed via JDBC. The database can have many users, but I want to simplify it by only allowing one user to connect to the database at a time. My Java application creates and holds onto a connection until it exits. I just need to know how to lock the whole database whilst somebody is connected! Any ideas?

Cheerz,

Steve.

The best solution i've come up with is to change th mysql system variable max_connections to 0 which only allows one person access at a time.
If anybody knows of a better solution then let me know!!

I have set up two user accounts, an admin one which only I use and a general one which is used by everything else. Then when I wish to lock the database I drop the general account. When I wish to unlock the database, I recreate the account.

Anyone else got other ways of doing it?