phpMyAdmin“未选择数据库"的MySQL [英] phpMyAdmin "No database selected" MySQL

问题描述

我下载了一个MySQL备份文件，并立即导入了MAMP的phpMyAdmin.我懂了 返回:

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 

我根本没有更改.sql文件.关于我如何让这只小狗去本地的任何提示?

I did not alter the .sql file at all. Any hints on how i can get this puppy going locally?

谢谢！

推荐答案

首先创建一个具有某些名称的数据库.单击该数据库，然后导入表.这里的问题是，当您导入任何表时，它会查找您正在使用的数据库.因此，按照我上面所说的做，或者在不存在columns_priv(

Just create a database with some name first of all. Click on that database and then import your table. The problem here is when you import any table it looks for which database you are using. So, either do as I said above or add this just above CREATE TABLE IF NOT EXISTS columns_priv (

USE your_db_name;//here your_db_name is the database you just created. 

就是这样.

这篇关于phpMyAdmin“未选择数据库"的MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！