Programming/MySQL

From Dev Wiki
< Programming
Revision as of 06:58, 20 November 2020 by Brodriguez (talk | contribs) (Correct link)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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

Syntax


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