Shiny Dashboard mySQL authorised user access

I have a general question on the capabilities of shiny dashboard before I embark on any development.

I have a mySQL database with employee information from several clients. It was initially for me alone to use but I have been asked to share the database with some clients. Questions as follows.

  1. Can R and Shiny access and tabulate, plot data in a dashboard from a mySQL database?
  2. Is it possible to enter or edit data back into the database from a Shiny dashboard?
  3. Since the database contains data from several clients is it possible to set up a login for a shiny dashboard, and restrict user access to the data.
  4. If any knows that this sort of thing has been done can they point me in the right direction or an example to do more research.

Thanks in advance