Mysql ERROR 1049 (42000): Unknown database 'blog_data'

Asked Aug 30 '20 at 04:50

Active Aug 30 '20 at 10:21

Viewed 297 times

I used the command DROP DATABASE blog_data it was executed successfully.Then I logged out of the mysql and tried to login again with the command sudo mysql -u djangouser -p it prompt for the password after which if I give the password it is throwing the error

ERROR 1049 (42000): Unknown database 'blog_data'

Please help me where I am going wrong.

edited Aug 30 '20 at 10:21

Shadow

33,525
10
51
64

asked Aug 30 '20 at 04:50

Arjun Singh

When you have dropped the database then why you are expecting it should be recognized? – Akhilesh Mishra Aug 30 '20 at 05:18
I just want to login into the mysql client to see other databases.But I don't know why this error is coming. – Arjun Singh Aug 30 '20 at 05:25
Looks as user `jangouser` have not permissions to other databases. Try to login with `root` `sudo mysql -uroot -p` – Slava Rozhnev Aug 30 '20 at 08:33
With `DROP DATABASE` you just delete the WHOLE database, so your database can't exist anymore. Like pointed out before. – klediooo Aug 30 '20 at 10:24

Mysql ERROR 1049 (42000): Unknown database 'blog_data'

0 Answers0