Friday, March 27, 2020

ERROR 1046 (3D000): No database selected



Error Blog 

Hi Guys ,
This blog is about the error   ERROR 1046 (3D000): No database selected

Problem Statement

unable to query in mysql usiing command line client 


Error Details 

error Log

ERROR DETAILS 


mysql> select * from all_tables
    -> ;
ERROR 1046 (3D000): No database selected
mysql>




Error Code 

Please check if the database is selected 

  
   
  

Solution

select a database

Code Changes 

execute the following command 

  
        

mysql> use mydb
Database changed
mysql>

         
OUTPUT



Thanks for reading . Let me know your thoughts in the comments below    .

No comments:

Post a Comment

ec2-user@ec2 Permission denied