You are a database administrator running a MySQL database server with 100 databases for different applications. Write commands for:
i) Taking a backup of all databases into one .sql file using mysqldump. The databases should them be copied to an external backup server. Write the commands for these tasks. Assume you have the root password for MySQL and the SSH password for the backup server
ii) Explain how you would allow remote connection for users and command on how you would access a database remotely. Assume you do not have access to phpMyAdmin. The database name is app_one, user is app_user, remote IP is 123.12.1.20 and password is My#Database#Pass#