Error 1046 3d000 No Database
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 Us Learn more about Stack Overflow the company Business Learn more about hiring
Error 1046 (3d000) No Database Selected Grant
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the
#1046 - No Database Selected Import
Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error 1046 No database Selected,
No Database Selected Php
how to resolve? up vote 136 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 no database selected mysql command line here. sql mysql mysql-error-1046 share|improve this question edited Oct 23 '10 at 18:21 OMG Ponies 198k36356415 asked Oct 23 '10 at 18:19 steph 687253 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 212 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
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 error code 1046 in mysql workbench about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges error 1046 (3d000) at line 22: no database selected Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 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 http://stackoverflow.com/questions/27018653/error-1046-3d000-no-database-selected-while-creating-user your 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 6689 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 Navigation menu switched per app? Why don't you connect unused hot and neutral wires to "complete the circuit"? What is the difference between SAN and SNI SSL certificates? 2048-like arra
Du siehst YouTube auf Deutsch. Du kannst no database selected diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can change this preference below. Schließen Ja, ich möchte sie behalten Rückgängig machen Schließen Dieses Video ist nicht verfügbar.
log in tour help Tour Start 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 hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Error 1046 Mariadb: No database selected up vote 3 down vote favorite 1 GRANT ALL ON my-database.* TO my-user@10.0.0.1 IDENTIFIED BY 'password'; ERROR 1046 (3D000): No database selected Ok, I have created a database with a "-" on the name (did the same thing on the user)... then when I try to set the grants on it the database wont work. If I use the base the error is different MariaDB [(none)]> use my-base Database changed MariaDB [my-base]> GRANT ALL ON 'my-base'.* TO 'my-user'@'10.0.0.1' IDENTIFIED BY 'password'; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''my-base'.* TO 'my-user'@'10.0.0.1' IDENTIFIED BY 'password'' at line 1 MariaDB [my-base]> mariadb share|improve this question edited Mar 8 at 22:54 RolandoMySQLDBA 107k15138274 asked Oct 19 '12 at 14:27 maniat1k 1702516 1 In regards to the second error if you set your database, if you're not running in ANSI-quote sql_mode, ' doesn't escape a database object. Use the back tick ` –Derek Downey Oct 19 '12 at 15:03 1 Slight correction to myself...ANSI_QUOTES affects the double-quotes for escaping...single-quotation never does :) –Derek Downey Oct 19 '12 at 15:14 add a comment| 1 Answer 1 active oldest votes up vote 8 down vote accepted Try escaping it with backticks? GRANT ALL ON `my-database`.* TO `my-user`@`10.0.0.1` IDENTIFIED BY 'password'; Also, if you already have a user my-user@10.0.0.1, you don't need to provide the IDENTIFIED BY... portion of your grant statement share|improve this answer answered Oct 19 '12 at 14:31 Derek Downey 15.8k74885 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up usin