Tutorials › MySQL › MySQL Introduction

MySQL Introduction

4 min read Quiz at the end

MySQL is the world's most popular open-source RDBMS — stores data in structured tables with SQL queries.

MySQL Introduction

MySQL is the world's most popular open-source relational database. It stores data in structured tables with rows and columns and uses SQL (Structured Query Language) to query and manipulate data.

# Install MySQL
sudo apt install mysql-server
mysql --version

# Connect
mysql -u root -p
mysql -u root -p mydb
mysql -h localhost -P 3306 -u user -p

# Basic commands
SHOW DATABASES;
USE mydb;
SHOW TABLES;
DESCRIBE users;

← Back to overview Next: Creating Databases and Tables →

Topic Quiz · 2 questions

Test your understanding before moving on

1. Which SQL statement retrieves data from a table?

💡 SELECT is the SQL command for querying and retrieving data from one or more tables.

2. What does SHOW TABLES; do in MySQL?

💡 SHOW TABLES displays all tables in the currently selected database.

Quick Access

MySQL Introduction

MySQL Introduction

Test your understanding before moving on