You can use any MySQL installation settings - just make sure that INNODB tables and transactions are supported (which they are by default). If you use default MySQL settings it should be fine.
You need to speciay a user with admin privileges for Aware IM to work.