Ошибка sql 1046 no database selected

MySQL no database selected is an error that occurs when you execute a statement without first selecting a database. The database may be completely missing, or you may choose the wrong database if there is more than one database.

Therefore, if you have more than one database, know the currently selected database and on which database your query execution takes place. Read this article to understand MySQL error and how to fix it.

MySQL No Database Selected Error Causes

The MySQL1046 (3D000) error occurs when you do not select a database first when executing the MySQL statement. This error will mostly happen if you are trying to create a table in the MySQL database using the command prompt. While executing a command from the command prompt, you must also select the database. Otherwise, MySQL will not know from which database you are running the script.

MySQL has a command to help you determine the currently selected database. This is a quick way to help you ascertain if the problem is genuinely caused by not specifying a database. If the error arises due to not selecting a database, you can easily overcome it by replacing [database_name] with the correct database name in your server.

When creating a table statement from the MySQL workbench, you need to select the database to run before executing the statement. Note, the process of choosing the database is manual, not automatic. Similarly, when running a script from the command prompt screen, ensure that you provide that database name.

How to Resolve the No Database Selected Error During File Import

The error code 1046 no database selected MySQL workbench will pop up if you do not select a database before importing the SQL file. This can be disappointing if you do not know the origin of the problem. Now that you know the reason, here are some quick fixes.

– Create a New Database

• You must mention the name of the database prior to creating a table. To do so, use the command: USE database_name;
• If the database is not there, create a new database. Creating a new database can be quickly done by using the command: CREATE DATABASE database_name;

Now, use the newly created database with the command USE database_name. This should eliminate the 1046 error.

– Workbench Solution

This solution is specifically efficient when using the workbench. Experts suggest that you follow the steps below to eliminate the error:

• Find the welcome window, navigate to the left pane, and Object the browser
• From the drop-down list, select a database of interest
• Go to the SQL Development in the Workbench splash screen, look for the Manage Connections icon, and click on it.

– PhpMyAdmin Error Fix

This solution works for No database selected PhpMyAdmin errors. The approach tells you how you can resolve the error during the import. Just follow the steps below:

• Have a new database ready on Live Site (the company hosting you, e.g., Bluehost). This is mandatory.
• Navigate to phpMyAdmin on the live site and log in to the database
• Choose a database of interest from the list on the left side of the page. Usually, there is a grey bar on top with a PHPMyadmin inscription, and below it are two options – information_schema and the name of the database you logged into.
• From the top bar, click on the import button.
• Find and click on the Browse button, browse the files to find the SQL file you created or of interest and click to open it when you see it. If the file is zipped, unzip it first.
• Select SQL as the file format and press the Go button

After pressing the Go button, you will wait for a few minutes before seeing the results. Typically, the amount of wait time depends on the size of the database. The name of the created database must be similar to the name mentioned in the file. Otherwise, it will still throw the error.

– Other Solutions for Database Not Selected Error

One of the solutions requires that you create a database first before importing it. Here is the procedure.

• Create a new database using MySQL phpMyAdmin
• Use the database by simply running the command use database_name

And, finally, the easiest solution among all as it allows you to select a database using the command:

mysql -u example_user -p –database=work < ./work.sql

How to View Currently Selected Database: Avoiding MySQL No Database Selected Error

If you want to view the presently selected database, use the MySQL command below:

SELECT DATABASE();

You can execute this command from both two points – MySQL command line or MySQL workbench. The procedure for both processes is pretty straightforward.

If you are accessing it from the workbench, open it and execute the command:

SELECT DATABASE();

This action will expose the currently selected database, i.e., it returns the database you have selected. Usually, the database is also displayed in bold on the left side.

If you are working from the MySQL terminal, you must log in using your username and password and execute the command:

SELECT DATABASE();

This action also presents the selected database. However, the command will return null if you have not selected a database. This is common when you log into the terminal for the first time.

How to Import Files to Mysql Correctly

When the error emerges on your screen, you know the real cause of the issue. But, do you know how to select the database in MySQL? So, if you encounter a ”no database selected” error in PHP, Python, or any other program, you didn’t import your file correctly. Here is how you can import the files:

1. The step one is opening the Command :

• Open the command prompt on MySQL
• Navigate to the start menu and open Command Line Client.

2. The second step is selecting the Database:

• Selecting the database takes two forms: first, if you know the database, and second, if you do not know the database.

3. Let’s look at the first case (you know the database name):

• Select the database you wish to execute your script
• Do you know the name of the database? If yes, enter it in the format, use <database_name>;

Knowing the database name is critical since it is a solution to getting rid of the 1046 (3D000) error message.

4. Let’s look at the second option (you do not know the database name):

• In case you don’t know the database or database name on which you want to execute the script, list all the databases available using the command SHOW databases;
• This command, i.e., SHOW databases, will list all available databases making it easy to spot the database of interest.
• Run the use <database_name> command to select the database you want

5. And now we can execute the Statement:

• After you successfully select a database of interest, execute the needed statement. Typically, you will be executing create table statement in the database. This action creates a table in the database in MySQL using the workbench.

FAQ

– How Do I Switch Between Mysql Databases?

If you have more than one database in MySQL, indicate each with the USE command. This command helps you select or switch between databases in a MySQL server. However, you must choose the correct database each time you switch databases or start a new MySQL session.

– How Do I Select a Schema in Mysql?

Right-click on MySQL connection from the home screen and select edit connect. Set the desired default schema on the Default Schema box. The schema you select will be displayed in bold in the schema navigator. Use Filter to This Schema functionality to target specific schemas in the list.

Conclusion

Error 1046 usually occurs if you do not select the correct database when importing files in MySQL. That’s what we have discussed in detail in this article. The main points in this article are:

• Always select the database before clicking the import button
• Use the command SELECT Database when selecting a specific database in MySQL to work with when you have multiple databases. However, if you have one database, use SQL command USE.
• When MySQL ERROR 1046 (3D000) occurs, ensure you select the database. You can use the exact name to locate the file. Otherwise, use the command SHOW databases. This command displays all databases letting you select the right one.
• The first step in preventing the 1046 error is learning how to import files.

First, we have shown you how to import files correctly, and second, we have given you tips on how to solve the error 1046 when it occurs. These fixes are pretty straightforward, so why can’t you start applying them today?

The 1046 error occurs if you forget to select any database before creating a table.
Let us see how and why this error occurs. We will try to create a table without selecting a
database −

mysql> CREATE table MyTable1
   -> (
   -> id int
   -> );
ERROR 1046 (3D000): No database selected
Or
mysql> INSERT into sample values(1);
ERROR 1046 (3D000): No database selected

Look at the output above, we are getting the same 1046 error: “No database selected”

Now, we can resolve this error after selecting any database with the help of USE command −

mysql> USE business;
Database changed

Above, I have included the database with the name ‘business’. After that, we can create the
same table (which we tried creating above) under the database, “business” −

mysql> CREATE table MyTable1
   -> (
   -> id int
   -> );
Query OK, 0 rows affected (0.49 sec)

We can check whether the table is present or not in the “business” database. The query is as
follows −

mysql> SHOW tables like '%MyTable1%';

The following is the output

+---------------------------------+
| Tables_in_business (%MyTable1%) |
+---------------------------------+
| mytable1                        |
+---------------------------------+
1 row in set (0.05 sec)

15 ответов

USE database_name;

CREATE DATABASE database_name;

USE database_name;

 mysql -u example_user -p --database=example < ./example.sql

USE your_database;

CREATE DATABASE your_database;

mysqldump -pdbpass -udbuser --databases dbname

mysqldump -udbuser --password= --databases dbname

What is MySQL?

MySQL is a Relational Database Management System (RDBMS). SQL in MySQL is the abbreviation of «Structured Query Language», which Oracle developed it in 1995. It is one of the most famous database management systems. It stores data in table format. A relational database is a database that stores data in more than one table, and those tables may be further connected through a primary key. It is also available free on the website of oracle.

It is written in C and C++ languages.

MySQL Error — No Database Selected

The error which occurs when the execution of a statement is done without first selecting a database is known as MySQL no Database Selected error. It may also be possible that the Database needs to be included, or the user may have chosen the wrong Database.

Causes of MySQL-No Database Selected Error

The MySQL — 1046 error occurs when a user tries to execute the commands without selecting a database first. This type of error commonly occurs when creating a table in the MySQL database using the command prompt (cmd). To execute the commands from the command prompt, selecting a database in MySQL is necessary. Otherwise, MySQL will not be able to determine from which Database the user is running the script.

There is a command in MySQL that can help a user to determine the currently selected Database. It is the best and quick way to ascertain if the error is caused by genuine reasons for not specifying the Database or something else. If the error arises by not selecting the Database, it becomes easy to overcome it by selecting  <database_name> with the databases available in the system.

Before creating a table in MySQL, selecting a database where the table gets stored is necessary. Choosing the Database is not automatic; it is a manual process. So, before running any script or commands from the command prompt, ensure that the database name is provided to the server.

How to Resolve the Issue of “No Database Selected Error”

The issue of no database selected can be solved by following these simple steps-

Step 1: Open Command Prompt

• First of all, open MySQL Command line Client on the start menu.
• Then enter the passkey to execute the commands.

Step 2: Select the Database

If the user knows the database name:

• Select the Database in which you want to execute the commands.
• If you know the database name, input the database name preceding the keyword ‘use’. Like:-

use <database_name>;

Note:  It is important to follow this step. Otherwise, it will give a 1046(3D000) error message.

If user don’t know the name of the database:

Suppose a user needs to learn the database name on which he wants to execute statements or commands. He can show the list of Databases available in the system by using the keyword SHOW. If the user doesn’t know the name of the Database:

SHOW databases;

This command will show all the databases available in the system in a list format. The user can choose a database that he wants by using <database_name>;

If the user wants to create a new database:

If the Database the user needed is unavailable or he wants to create a new one, he can create it by entering a new database name preceding the keyword ‘create’.

CREATE DATABASE database_name;

Step 3: Execution of Statements

Once the Database is selected, a user can execute its required SQL commands. There are various commands available in MySQL to create tables and make amendments. For example-

CREATE TABLE <table_name>;
SHOW * from <table_name>;

How to View Currently Selected Database: To Avoid MySQL 1046 Error

If the user is unable to determine which Database is selected and he wants to view the currently selected Database, use the MySQL command listed below:

SELECT DATABASE();

A user can execute this command from both IDE of MySQL – MySQL command line prompt or MySQL workbench. Following this command is quite simple in both IDEs.

If the user is accessing it from the MySQL workbench, open it and execute the command:   

SELECT DATABASE();

SELECT DATABASE() from DUAL;

This command will show the current Database a user is working on, i.e., it represents the Database the user has selected.

If the user is using MySQL terminal, they must log in using username and password and then execute the command:              

SELECT DATABASE() from DUAL;

STATUS;

STATUS command represents the current status of the MySQL server in the system. It shows the connection id, the current Database selected, and the current user working on MySQL.

SQL error 1046 occurs if the database is not selected.

Here at Bobcares, we have seen several such SQL related issues as part of our Server Management Services for web hosts and online service providers.

Today we’ll take a look at the cause for this error and how to fix it.

What causes SQL error 1046 to occur

Generally, this error occurs when creating tables or while recovering the tables from any backup.

For example, let’s say that we have created a database and provided a password as well.
Now while creating the table if we forget to mention the database name then we will end up with this error message.

This happens because SQL is not aware of which database we are going to use.

Also, the same goes while importing tables from any backup.

For instance, the error appears as below.

How we fix SQL error 1046

Now let’s look into different solutions provided by our Support Engineers.

1. Recently, one of our customers approached us with the same error message while creating a table.

We then replicated the error and could find that the customer wasn’t selecting the database to create a table.

So we suggested running the below command so that the database gets selected.

USE database_name;

In case, if the database doesn’t exist then we ask customers to create it via below command

CREATE DATABASE database_name;

After this step, we suggested the customer create the tables. Finally, he was able to create it with no more errors.

2. Alternately, we also provide the below command to select the database.

mysql -u example_user -p –database=work < ./work.sql

3. In some situations, if the customer has the database file then we import the database in phpMyAdmin for them. Here are the steps that we follow to do so.

• First, we access the phpMyAdmin. Then select the database created by the customer from the list of databases on the left of the page.
• Here, we click on the Import option available on the top bar.
• Then click on the ‘Browse‘ button available next to the ‘Location of the SQL file‘.
• Here, we browse the local SQL file and open it. After that, we choose the format as ‘SQL‘.
• Finally, we click on the ‘Go‘ button and wait for the database to get imported.

NOTE: We follow the above steps to import the database only after creating it.

[Need any further assistance in fixing SQL errors? – We’re available 24*7]

Conclusion

In short, this error can arise if we forget to select the database before creating tables or importing .sql file. Today, we saw the resolution to this SQL error.

var google_conversion_label = «owonCMyG5nEQ0aD71QM»;