Connect to This MariaDB Database on Linux

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Connect to the database.

As this database is behind a firewall, you must first connect to the server using ssh.

After connected to the server via ssh, you can connect using the mysql client.
sudo mysql -h localhost -u root demo

Print the name of the user with ID 3.

select name from users where ID = 3;

Print the ID of the user named “David”.

select ID from users where name = 'David';