Connect to a database

• MariaDB: mysql
• PostgreSQL: psql:
  • sudo -u postgres psql
  • psql service=MyConfiguredDB ($HOME/.pg service.conf)
• MongoDB: mongo, use DB_NAME

Related terms

\c databasename

• Connect to a database
• Show databases
• Create database
• Delete database
• Create user
• List users
• List databases
• List tables: show tables
• GRANT

See also

• PostgreSQL: psql, .psqlrc, $HOME/.pg service.conf, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, show users, show, su - postgres, psql --help, psql -c
• Databases: SQL, NoSQL, PostgreSQL, MariaDB, MySQL, Derby DB, MongoDB, Cassandra, SQLite, HSQL2, H2, RocksDB, Microsoft SQL Server, DB2, Oracle Database, Memcached, Berkeley DB, Collation, SingleStore, Amazon Aurora, Graph database, Amazon DynamoDB, PrestoDB, Cache hit ratio, ACID, WAL, ARIES, DBMS, OLTP, OLAP, Database Schema, CockroachDB