Challenge to solve: Connect to a remote MySQL database that requires secure authentication and retrieve specific data based on dynamic user input.

$10$

The solution should be a step$-$by$-$step, package installation to close the connection.

Challenge: You're working with a dataset on global life expectancy at birth over time $($by country$).$ Develop an R visualization that allows users to:

Select a specific country from a dropdown menu.

Explore life expectancy trends over time using an interactive line chart.

View additional information about the chosen country in a separate panel.

The solution should be a step$-$by$-$step, from package installation.