link

Related

Connect to PostgreSQL

psql

Connect to a PostgreSQL database using psql

Create Database

mysql

Create new database

Show Databases

mysql

List all databases

mysql/mysql-connect

Connect to MySQL

Connect to MySQL database

connection
database

Command

mysql

Explanation

Connect to MySQL server using the command-line client.

Examples

Connect as root user

mysql -u root -p

Connect to specific database

mysql -h localhost -u user -p database_name

Execute SQL file

mysql -u user -p < script.sql

More

Locate Files

linux

Find files by name using database

Select Data

mysql

Query data from tables

Insert Data

mysql

Insert data into tables