Show databases mysql docker

First, go inside docker container, run below command
docker exec -it mysql_container_name mysql -uroot -p
where “root” is the username for MySQL database. After running above command it will ask you a password.

Then Select Database, run below command
USE Name-Of-The-Database

get the list of all tables.
show tables;

Source: stackoverflow.com

Similar codes

2 votes262 views1 answer
Postgresql drop primary key constraint
SQL
3 votes259 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote262 views1 answer
How to get data between a last week in mysql
SQL
0 vote704 views2 answers
Zsh: command not found: mysq
SQL
0 vote287 views3 answers
How to increase size of column in sql
SQL
0 vote277 views1 answer
Postgres sequence name
SQL
0 vote282 views1 answer
Tinydb add table
SQL
0 vote260 views1 answer
Postgresql isnull with max
SQL
1 vote279 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote253 views1 answer
Truncate table sql server foreign key
SQL