When a user logs on and she tries to execute one of the reports inside of the access file, she gets prompted for a sql password.

Use this guide to learn how to easily create and manage a MySQL 8 user with remote access to all databases.