Programming/MySQL: Difference between revisions
Jump to navigation
Jump to search
Brodriguez (talk | contribs) (Export content to sub-pages) Tag: Replaced |
Brodriguez (talk | contribs) (Correct link) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[https://www.mysql.com/ 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. | It is one of the most commonly used database systems, designed to work with the SQL standard. | ||
| Line 6: | Line 6: | ||
== Setup == | == Setup == | ||
* [[MySQL/Setup]] | * [[Programming/MySQL/Setup | Setup]] | ||
== Syntax == | == Syntax == | ||
* [[MySQL/Databases]] | * [[Programming/MySQL/Databases | Databases]] | ||
* [[MySQL/Queries]] | * [[MySQL/Queries | 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 | |||
Latest revision as of 06:58, 20 November 2020
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