How To List MySQL/MariaDB Databases
I have some MySQL databases. I have no previous experience about MySQL. How can list existing databases with bash?
MySQL and MariaDB are using same code base and tools. So we can use following instructions to list MariaDB too.
First be sure MySQL/MariaDB service is running
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | $systemctl status mariadb ● mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled) Active: active (running) since Cts 2016-11-05 09:23:09 UTC; 1min 0s ago Process: 1950 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=/SUCCESS) Process: 1922 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=/SUCCESS) Main PID: 1949 (mysqld_safe) CGroup: /system.slice/mariadb.service ├─1949 /bin/sh /usr/bin/mysqld_safe --basedir=/usr └─2106 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/l... Kas 05 09:23:05 cen1 systemd[1]: Starting MariaDB database server... Kas 05 09:23:05 cen1 mysqld_safe[1949]: 161105 09:23:05 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. Kas 05 09:23:05 cen1 mysqld_safe[1949]: 161105 09:23:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql Kas 05 09:23:09 cen1 systemd[1]: Started MariaDB database server. |
We can enter MySQL prompt like below.
1 2 3 4 5 6 7 8 9 10 | $ mysql -u root Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 5.5.50-MariaDB MariaDB Server Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> |
Run command to get list of databases.
1 2 3 4 5 6 7 8 9 10 | MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | owncloud | | performance_schema | | test | +--------------------+ |
List Without Entering MySQL Shell
We can run mysql shell command without entering the shell like below.
1 2 3 4 5 6 7 8 9 10 | $mysql -u root -e "show databases;" +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | owncloud | | performance_schema | | test | +--------------------+ |
