Mysql Error 1046 3d000 No Database Selected
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and
#1046 - No Database Selected Import
policies of this site About Us Learn more about Stack Overflow the company no database selected php Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users error 1046 (3d000) no database selected grant Badges Ask Question x Dismiss Join the 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
No Database Selected Mysql Workbench Import
minute: Sign up Error 1046 No database Selected, how 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
No Database Selected Mysql Command Line
CHARSET = latin1; MySQL said: #1046 - No database selected need some help here. 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 databas
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 Overflow the company Business Learn more about #1046 - no database selected wordpress hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges
Error Code 1046 In Mysql Workbench
Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each no database selected mysqli other. Join them; it only takes a minute: Sign up ERROR 1046 (3D000): No database selected while creating user up vote 0 down vote favorite When I create a admin user with: GRANT ALL ON * TO my_name@localhost IDENTIFIED http://stackoverflow.com/questions/4005409/error-1046-no-database-selected-how-to-resolve BY 'my_passwd' WITH GRANT OPTION I received the error message "ERROR 1046 (3D000): No database selected". mysql mysql-error-1064 share|improve this question edited Nov 19 '14 at 14:12 Lars 1,186823 asked Nov 19 '14 at 13:56 user2823470 312 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted You should be saying it like below by qualifying it with database name. Check MySQL Documentation for more information. GRANT ALL ON db_name.* So for your http://stackoverflow.com/questions/27018653/error-1046-3d000-no-database-selected-while-creating-user case, GRANT ALL ON db1.* TO my_name@localhost IDENTIFIED BY 'my_passwd' WITH GRANT OPTION; share|improve this answer answered Nov 19 '14 at 13:59 Rahul 43.4k63462 or for all databases use GRANT ALL ON *.* ... –Lars Nov 19 '14 at 14:04 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged mysql mysql-error-1064 or ask your own question. asked 1 year ago viewed 6794 times active 1 year ago Related -2Syntax Error in Create Function2Importing using MySQL WorkBench… error ERROR 1046 (3D000)0Error Updating Database with PHP0You have an error in your SQL syntax while doing a basic SELECT0MySQL Error #1064 from Create Table1MySQL Error: #1046 - No database selected-1Create procedure ERROR 1046 (3D000): No database selected-1SQLSTATE[3D000]:1046 - No database selected0SQL syntax error when adding a user to the database through php0codeigniter 3.1 PDO mysql Error Number: 3D000/1046 No database selected Hot Network Questions What's the longest concertina word you can find? How do I depower overpowered magic items without breaking immersion? Why is JK Rowling considered 'bad at math'? How many decidable decision p
Aug 2014 15:49 Reporter: Flavian C Email Updates: Status: Verified Impact on me: None Category:MySQL Server: Parser Severity:S3 (Non-critical) Version:5.5.26 5.6.19 OS:Any Assigned to: Triage: Needs Triage: D4 (Minor) View Add Comment Files Developer Edit Submission View Progress Log Contributions https://bugs.mysql.com/bug.php?id=73590 [14 Aug 2014 17:56] Flavian C Description: If we use multi-join inside a join the update query asks for DB name ERROR 1046 (3D000): No database selected How to repeat: Im getting no database select when using http://forum.wampserver.com/read.php?2,121899,121960 JOIN inside a JOIN. UPDATE DB1.TABLE1 as a JOIN (SELECT * FROM DB1.TABLE2 as b,(SELECT * DB1.TABLE2) as c WHERE b.col1 = c.col1) ea JOIN (SELECT SUM(d.size) FROM DB1.TABLE2 as d WHERE d.col1=xx) ef ON a.col1=ea.col1 and no database a.col1=ef.col1 set xxxx Also if ea alias join if we convert the inside join to subquery it works properly but takes a performance hit. i.e UPDATE DB1.TABLE1 as a JOIN (SELECT * FROM DB1.TABLE2 as b WHERE b.col1 = (SELECT c.col1 DB1.TABLE2 as c)) ea JOIN (SELECT SUM(d.size) FROM DB1.TABLE2 as d WHERE d.col1=xx) ef ON a.col1=ea.col1 and a.col1=ef.col1 set xxxx [14 Aug 2014 18:00] Sveta Smirnova Thank you for the report. Please specify no database selected which exact minor version of MySQL server you use and provide output of SHOW CREATE TABLE for all involved tables. [14 Aug 2014 18:28] Flavian C Just for test case you can do: Do not do " use dbname " login into mysql : execute the following CREATE TABLE flavian.`test1` ( `col1` int(3) DEFAULT NULL, `col2` int(3) DEFAULT NULL, `col3` int(3) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; CREATE TABLE flavian.`test2` ( `col1` int(3) DEFAULT NULL, `col2` int(3) DEFAULT NULL, `col3` int(3) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; mysql> update flavian.test1 a JOIN (select * from flavian.test2 b, (select * from flavian.test2 c where c.col1=1 limit 1) d where b.col1=d.col1) ea JOIN (select sum(e.col2) from flavian.test2 e where e.col1=1) ef set a.col2=ea.col2, a.col3=ef.col3 where a.col1=1 and a.col2=2; ERROR 1046 (3D000): No database selected mysql> update flavian.test1 a JOIN (select * from flavian.test2 b where b.col1=(select c.col1 from flavian.test2 c where c.col1=1 limit 1)) ea JOIN (select sum(e.col2) size1 from flavian.test2 e where e.col1=1) ef set a.col2=ea.col2, a.col3=ef.size1 where a.col1=1 and a.col2=2; Query OK, 0 rows affected [14 Aug 2014 18:35] Sveta Smirnova Thank you for the report. Verified as described. If run first query with default database correct error is returned: mysql> update flavian.test1 a JOIN (select * from flavian.test2 b, -> (select * from flavian.test2 c where c.col1=1 lim
- MySQL said: #1046 - No database selected Posted by: IrvC (---.hfc.comcastbusiness.net)Date: February 21, 2014 04:27PMI am trying to import the database that I exported from our live site to WAMP using phpMyAdmin. I browse for the .sql file that the export created and click GO. I tried leaving SQL compatibility mode as NONE, and also selected MYSQL40 and MYSQL323 for compatbility mode.I am getting error #1046 - No Database Selected.Any clues?IrvWindows 7WAMP ver. 2.4 (just downloaded this week)Edited 1 time(s). Last edit at 02/21/2014 04:46PM by IrvC.Options:Reply•QuoteRe: Import error - MySQL said: #1046 - No database selected Posted by: RiggsFolly (---.as13285.net)Date: February 23, 2014 03:43PMLook at your .sql file from your database dump. It probably does not contain a 'USE xxx;' statement.So add a USE databasename;To the top of your .sql file where 'databasename' is a database you have previously created using phpmyadmin.---------------------------------------------------------------------------------------------(Windows 7 Pro 32bit) (Wampserver 3.0.6RC2 32bit) - Apache 2.4.18 - PHP 5.6.15 - MySQL 5.7.10