Could you add an option where the MySQL server does authentication by the Linux system
account of the other end of the (local) connection?
This will only work for local connections, but is very handy. Passwords would no longer
be needed, making it both more secure and easier.
In addition to user name/password, the privilege tables should contain a unix_account