Mysql Error Code 1046
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About no database selected mysql php Us Learn more about Stack Overflow the company Business Learn more about hiring
Error 1046 No Database Selected Phpmyadmin
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the error 1046 (3d000) no database selected grant Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error 1046 No database Selected, how
No Database Selected Mysql Workbench Import
to resolve? up vote 137 down vote favorite 22 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. no database selected mysql command line sql mysql mysql-error-1046 share|improve this question edited Oct 23 '10 at 18:21 OMG Ponies 199k37360417 asked Oct 23 '10 at 18:19 steph 692253 5 In case anyone is interested, you can also specify the database name via the CLI command without editing the import file. mysql -u root -p databasename < import.sql –Sam Dufel Nov 24 '14 at 15:36 what happened to me was: create a schema, filled in the name of the database, then it says "fail, no database selected". reopen workbench, i see database that i have just failed to created. Then I choose the database that i have just created, and open a .sql file and run, with both create database and use database statements, it complains "fail no database selected" again. reopen workbench, the tables are all built. MAC system, workbench 6.3.3 –Tiina Jun 9 at 9:12 add a comment| 13 Answers 13 active oldest votes up vote 216 down vote 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; share|improve
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack
#1046 - No Database Selected Wordpress
Overflow the company Business Learn more about hiring developers or posting ads with us
No Database Selected Mysqli
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community #1044 - access denied for user of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error Code: 1046. No database selected Select up vote -1 down vote favorite What seems to http://stackoverflow.com/questions/4005409/error-1046-no-database-selected-how-to-resolve be wrong with my DB Error ? Im very new to SQL. Thanks <3 /* Navicat MySQL Data Transfer Source Server : Localhost Source Server Version : 50141 Source Host : localhost:3306 Source Database : tabulaDb Target Server Type : MYSQL Target Server Version : 50141 File Encoding : 65001 Date: 2011-02-10 23:56:02 */ SET FOREIGN_KEY_CHECKS=0; -- Table structure for characters DROP TABLE IF EXISTS characters; CREATE TABLE characters ( id int(11) http://stackoverflow.com/questions/27329099/error-code-1046-no-database-selected-select NOT NULL AUTO_INCREMENT, name varchar(64) NOT NULL, slotID tinyint(4) NOT NULL, userID int(11) NOT NULL, gender tinyint(4) NOT NULL, raceID tinyint(4) NOT NULL, classID tinyint(4) NOT NULL, ad1_classId int(11) NOT NULL, ad1_hue int(10) unsigned NOT NULL, ad2_classId int(11) NOT NULL, ad2_hue int(10) unsigned NOT NULL, ad3_classId int(11) NOT NULL, ad3_hue int(10) unsigned NOT NULL, ad4_classId int(11) NOT NULL, ad4_hue int(10) unsigned NOT NULL, ad5_classId int(11) NOT NULL, ad5_hue int(10) unsigned NOT NULL, ad6_classId int(11) NOT NULL, ad6_hue int(10) unsigned NOT NULL, ad7_classId int(11) NOT NULL, ad7_hue int(10) unsigned NOT NULL, ad8_classId int(11) NOT NULL, ad8_hue int(10) unsigned NOT NULL, ad9_classId int(11) NOT NULL, ad9_hue int(10) unsigned NOT NULL, ad10_classId int(11) NOT NULL, ad10_hue int(10) unsigned NOT NULL, ad11_classId int(11) NOT NULL, ad11_hue int(10) unsigned NOT NULL, ad12_classId int(11) NOT NULL, ad12_hue int(10) unsigned NOT NULL, ad13_classId int(11) NOT NULL, ad13_hue int(10) unsigned NOT NULL, ad14_classId int(11) NOT NULL, ad14_hue int(10) unsigned NOT NULL, ad15_classId int(11) NOT NULL, ad15_hue int(10) unsigned NOT NULL, ad16_classId int(11) NOT NULL, ad16_hue int(10) unsigned NOT NULL, ad17_classId int(11) NOT NULL, ad17_hue int(10) unsigned NOT NULL, ad18_classId int(11) NOT NULL, ad18_hue int(10) unsigned NOT NULL, ad19_classId int(11) NOT NULL, ad19_hue int(10) unsigned NOT NULL, ad20_classId int(11) NOT NULL, ad20_hue int(10) unsigned NOT NULL, ad21_classId int(11) NOT NULL, ad21_
a Bug Impact on me: None Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical) Version:5.2.34 OS:Any Assigned to: View Add Comment Files Developer Edit Submission View https://bugs.mysql.com/bug.php?id=61821 Progress Log Contributions [11 Jul 2011 15:22] carlos villa Description: Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. How to repeat: ror Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. no database [11 Jul 2011 15:24] Valerii Kravchuk Do you use MySQL Workbench? What exact version of it, 5.2.x? [11 Jul 2011 15:39] Miguel Solorzano Not repeatable with 5.2.34. [11 Aug 2011 23:01] Bugs System No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was no database selected originally requested, please do so and change the status of the bug back to "Open". [8 Dec 2011 8:05] bruce deng Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. i got this error in the MySQL Workbench 5.2.34 CE Revision 7780 [8 Dec 2011 17:41] Valerii Kravchuk All reporters: Please, check if this problem still happens with a newer version, 5.2.36. [9 Jan 2012 7:00] Bugs System No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". [28 Jan 2012 16:00] Tolulope Eribake You need to specify a default schema for the error not to appear. [23 Sep 2012 23:05] scott markowitz 15:36:46 show index from tblprojects Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar. 0.00