Create the following scripts countries.sql, athletes.sql** and sports.sql

Each script will populate the corresponding table with the data from your CSV.

Data needs to be sorted alphabetically and can not contain duplicates.

Data will be broken by the following filter so that each node contains different records.

CentOS

olympic

Ubuntu

All 1k Users

Fedora

paralympic

* For the athletes.sql script make sure to combine

firstname+' '+lastname into the roary001_atheletes_name column

Create a script called secure_installation.sql

The script must accomplish the same result as mysql_secure_installation. The script must contain your own SQL statements and no reference to the built-in mysql_secure_installation command. Additionally, this script must run without stopping for user interaction.

- Set root password. // Use your PANTHERID as password. i.e 7654321

- Remove anonymous users.

- Disallow root login remotely.

- Remove test database and access to it.

- Reload privilege tables

Access // 2 pts

Disallow root from SSH to each one of your servers

Disable the Firewall to allow incoming SQL connections.

Create a professor account in MySQL.

- Use ggome002 as the username.

- Set your PANTHERID as password. // i.e 7654321

- Allow the professor account to connect from all your servers.

- Grant the professor ALL access to all databases and tables.