Working with MySQL/MariaDB

In this hands-on lab, you will install Mysql/MariaDB on a CentOS 7 server. Once that is complete, you will be required to configure the server with the provided data.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Install MariaDB/MySQL

Install using the official repo:

sudo yum install -y mariadb-server

sudo systemctl start mariadb

sudo systemctl enable mariadb

sudo mysql_secure_installation

Create required resources

Then, create the database and the table:

create database city_data;

use city_data

create table city_info(
LatD int,
LatM int,
LatS int,
NS char,
LonD int,
LonM int,
LonS int,
EW char,
City varchar(50),
State varchar(50)
) ;

Bulk insert and validate the data

Copy the cities.csv file into the mysql user’s home directory:
```
sudo cp ./data/cities.csv /var/lib/mysql
```

Perform the bulk insert:

LOAD DATA INFILE '/var/lib/mysql/cities.csv' INTO table city_info Fields terminated by ',' ENclosed by '"' Lines terminated by 'n' Ignore 1 ROWS;

Validate the data:

select count(city) from city_info where state='KS';

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Working with MySQL/MariaDB

About this Hands-on Lab

Learning Objectives

Additional Resources

What are Hands-on Labs

Newsletter