Programming/MySQL

[MySQL] is an open source database management system.

It is one of the most commonly used database systems, designed to work with the SQL standard.

Alternatives are MariaDB and PostgreSQL.

Setup

• Programming/MySQL/Setup

Syntax

• Programming/MySQL/Databases
• MySQL/Queries

Basics

Accessing the MySQL Shell

You can access the MySQL server from a terminal via the MySQL shell.

If you have a fresh install with no setup yet, then this is likely done via:

sudo mysql

If you have done some setup, such as setting a password for the root account or creating a user to login with, then use:

mysql -u <username> -p

Exiting the MySQL Shell

exit

or

\q