How do I access my MySQL DB through command line?

Question

So I'm working on this Django project, with MySQL as DB engine.
I made some sort of mistake, and now I have to drop a table I accidentally created. So I'm trying to access the DB through command line, but cannot figure out how.

Could anyone help? Or is there a better way of dropping a table in MySQL DB?
Thanks in advance.

score 0 · Answer 1 · answered Apr 19 '21 at 14:27

0

You can use python manage.py dbshell.

answered Apr 19 '21 at 14:27

ahmadgh74

801
6
10

score 0 · Accepted Answer · answered Apr 19 '21 at 14:50

Use the dbshell command

python manage.py dbshell

then while in the shell, depending on what database you are using, you type the command to show tables to identify the table you want to drop.

still in the shell, you can use SQL command to drop the table

DROP TABLE shop_brand;

source => How can i delete database table in django?

How do I access my MySQL DB through command line?

2 Answers2