MySQL Introduction

MySQL is an open-source database management system. The database is a structured collection of data, and MySQL store data in the form of a table, hence it is called Relational Database Management System (RDBMS). It can run on various platforms like Linux, Windows, macOS, etc. The MySQL is the combination of My and SQL, My is the daughter's name of the MySQL's co-founder, Monty Widenius, and SQL stands for Structured Query Language.


If you want to stay logically connected to this tutorial, start with MySQL: CREATE a DATABASE and TABLE, and then accordingly follow the recommended links at the bottom of each page. Throughout this tutorial, we are using MySQL on Linux Ubuntu distribution.
Prerequisite: The MySQL setup is up and running. If not, then refer How to setup, install, and start MySQL on Ubuntu.

How to start MySQL on Ubuntu
kodingwindow@kw:~$ sudo mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.36-0ubuntu0.22.04.1 (Ubuntu)

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Advertisement