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   need some help here

User · Answer

You need to tell MySQL which database to use:

USE database_name;

before you create a table.

In case the database does not exist, you need to create it as:

CREATE DATABASE database_name;

followed by:

USE database_name;

User · Answer

Although this is a pretty old thread  I just found something out  I created a new database  then added a user  and finally went to use phpMyAdmin to upload the  sql file   total failure   The system doesn t recognize which DB I m aiming at      When I start fresh WITHOUT first attaching a new user  and then perform the same phpMyAdmin import  it works fine

User · Answer

first select database   USE db name  then creat table CREATE TABLE tb name      id  int   name varchar 255    salary int    city varchar 255      this for mysql 5 5 version syntax

User · Answer

If importing a database  you need to create one first with the same name  then select it and then IMPORT the existing database to it   Hope it works for you

User · Answer

You can also tell MySQL what database to use  if you have it created already     mysql -u example user -p --database example  lt    example sql

User · Answer

For MySQL Workbench   Select database from Schemas tab by right mouse clicking  Set database as Default Schema

User · Answer

Just wanted to add  If you create a database in mySQL on a live site  then go into PHPMyAdmin and the database isn t showing up - logout of cPanel then log back in  open PHPMyAdmin  and it should be there now

User · Answer

If you are doing this through phpMyAdmin    I m assuming you already Created a new MySQL Database on Live Site  by live site I mean the company your hosting with  in my case Bluehost    Go to phpMyAdmin on live site - log in to the database you just created  Now IMPORTANT  Before clicking the  import  option on the top bar  select your database on the left side of the page  grey bar  on the top has PHP Myadmin written  below it two options information schema and name of database you just logged into  once you click the database you just created logged into it will show you that database and then click the import option     That did the trick for me  Really hope that helps

User · Answer

I faced the same error when I tried to import a database created from before   Here is what I did to fix this issue   1- Create new database   2- Use it by use command    3- Try again   This works for me

User · Answer

Assuming you are using the command line  1  Find Database show databases   2  Select a database from the list e g  USE classicmodels  and you should be off to the races   Obviously  you ll have to use the correctly named database in your list  Why is this error occurring  Mysql requires you to select the particular database you are working on  I presume it is a design decision they made  it avoids a lot of potential problems  e g  it is entirely possible  for you to use the same table names across multiple databases e g  a users table  In order to avoid these types of issues  they probably thought   quot let s make users select the database they want quot

User · Answer

If you re trying to do this via the command line     If you re trying to run the CREATE TABLE statement from the command line interface  you need to specify the database you re working in before executing the query   USE your database    Here s the documentation   If you re trying to do this via MySQL Workbench        you need to select the appropriate database catalog in the drop down menu found above the  Object Browser  tab  You can specify the default schema database catalog for the connection - click the  Manage Connections  options under the SQL Development heading of the Workbench splash screen   Addendum  This all assumes there s a database you want to create the table inside of - if not  you need to create the database before anything else   CREATE DATABASE your database

User · Answer

jst create a new DB in mysql Select that new DB  if you r using mysql phpmyadmin now on the top it l be like  Server         Database   Now go to import tab select file Import

User · Answer

I m late i think    soory    If you are here like me searching for the solution when this error occurs with mysqldump instead of mysql  try this solution that i found on a german website out there by chance  so i wanted to share with homeless people who got headaches like me   So the problem occurs because the lack -databases parameter before the database name  So your command must look like this   mysqldump -pdbpass -udbuser --databases dbname   Another cause of the problem in my case was that i m developping on local and the root user doesn t have a password  so in this case you must use --password  instead of -pdbpass  so my final command was   mysqldump -udbuser --password  --databases dbname     Link to the complete thread  in German    https   marius bloggt-in-braunschweig de 2016 04 29 solution-mysqldump-no-database-selected-when-selecting-the-database

User · Answer

For an added element of safety  when working with multiple DBs in the same script you can specify the DB in the query  e g   create table my awesome db really cool table

User · Answer

Edit your SQL file using Notepad or Notepad   add the following 2 line    CREATE DATABASE NAME  USE NAME

User · Answer

be careful about blank passwords  mysqldump  options  -p    --databases database name   will ask for a password and complain with mysqldump  Got error  1046   No database selected  when selecting the database  the problem is that the -p option requires that there be no space between -p and the password   mysqldump  options  -p   --databases database name   solved the problem  quotes are not needed anymore

User · Answer

quoting ivan n    If importing a database  you need to create one first with the same name  then select it and then IMPORT the existing database to it  Hope it works for you    These are the steps  Create a Database  for instance my db1  utf8 general ci  Then click to go inside this database  Then click  import   and select the database  my db1 sql  That should be all

[sql] Error 1046 No database Selected, how to resolve?

Examples related to sql

Examples related to mysql

Examples related to mysql-error-1046