>_ linuxcommand.dev

Startseite › mysql

mysql

MySQL/MariaDB Client

Ubuntu CentOS Debian SUSE Fedora RHEL

Syntax

$mysql [options] [database]

Optionen

-u

-p

-h

-e

Examples

Examples

$mysql -u root -p

Examples

$mysql -u user -p database_name

Examples

$mysql -e "SHOW DATABASES;"

Examples

$mysql < backup.sql

See also

mysqldump mysqladmin mariadb

Alternatives

mariadb

Typical use cases

Manage databases

Run SQL queries

Import data

Note Interactive MySQL client. Works with MariaDB as well.

Export