phpMyAdmin "No database selected" MySQL
        Posted  
        
            by 
                user1751660
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by user1751660
        
        
        
        Published on 2012-12-19T10:59:07Z
        Indexed on 
            2012/12/19
            11:03 UTC
        
        
        Read the original article
        Hit count: 224
        
I downloaded a MySQL backup file and promptly imported into MAMP's phpMyAdmin. I got this return:
Error
SQL query: 
--
-- Database: `mysql`
--
-- --------------------------------------------------------
--
-- Table structure for table `columns_priv`
--
CREATE TABLE IF NOT EXISTS  `columns_priv` (
 `Host` CHAR( 60 ) COLLATE utf8_bin NOT NULL DEFAULT  '', 
 `Db` CHAR( 64 ) COLLATE utf8_bin NOT NULL DEFAULT  '',
 `User` CHAR( 16 ) COLLATE utf8_bin NOT NULL DEFAULT  '',
 `Table_name` CHAR( 64 ) COLLATE utf8_bin NOT NULL DEFAULT  '',
 `Column_name` CHAR( 64 ) COLLATE utf8_bin NOT NULL DEFAULT  '',
 `Timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
 `Column_priv` SET(  'Select',  'Insert',  'Update',  'References' ) CHARACTER SET utf8          NOT NULL DEFAULT  '',
PRIMARY KEY (  `Host` ,  `Db` ,  `User` ,  `Table_name` ,  `Column_name` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin COMMENT =  'Column      privileges';
MySQL said: 
#1046 - No database selected 
I did not alter the .sql file at all. Any hints on how i can get this puppy going locally?
Thanks!
© Stack Overflow or respective owner