silent Installation of mysql server with predefined password so user can not know it.
This can be done by adding MySQL Server as a prerequisite
for your package. Please note that the User Guide contains a tutorial
which may help you. In order to install MySQL Server silently, you can use a custom command line
for its package in the Properties
tab of the "Edit Prerequisite" dialog.
Unfortunately the MySQL server installation package doesn't support specifying the password from the command line. However, you can try using a BAT file
as a custom action
to set the password after MySQL server is installed.
Automatic restoration of mysql database
For this you can try using the SQL Scripts
feature. Please note that the User Guide contains a SQL Scripts tutorial
which may help you.