In mysql it is very simple to make use of the userfile. Therefore you can create multiple users on different databases and different priveliges. I know with web connections, it is better to use one user for all connection and queries.
But I delevope a client server application.
What is the best way to do. We using INNODB for recordlocking.