Error 1046 No database Selected how to resolve

Question

Error SQL query:

-- 
-- Database: `work` 
-- 
-- -------------------------------------------------------- 
-- 
-- Table structure for table `administrators` 
-- 
CREATE TABLE IF NOT EXISTS `administrators` ( 

`user_id` varchar( 30 ) NOT NULL , 
`password` varchar( 30 ) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = latin1;

MySQL said:

#1046 - No database selected

I need some help here to solve this ERROR. 

Answer 1

I can help you with this doubt as the same error occurred for me when I tried to import a database created from before. In order to fix this issue, start with Creating a new database, then use it by use command and try it again. This has helped me!! Have shared a screenshot below for better understanding:-