Error 1046 3d000 No
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 Us error 1046 (3d000) no database selected grant Learn more about Stack Overflow the company Business Learn more about hiring developers
No Database Selected Mysql
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
No Database Selected Error In Php
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 Create procedure ERROR 1046 (3D000): No database
No Database Selected Phpmyadmin
selected up vote -1 down vote favorite I am trying to create a simple procedure which would create a new database. complete code which i am trying to run over mysql is : SET @DB_NAME := "mydb"; SET @DB_CREATE:= "CREATE DATABASE "; DELIMITER // drop procedure if exists create_db // create procedure create_db(name TEXT) BEGIN DECLARE temp TEXT; DECLARE user TEXT; SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME no database selected mysql workbench import = name INTO temp; if temp = name then SIGNAL SQLSTATE '45002' SET MESSAGE_TEXT = 'This database already exist'; else SELECT USER() INTO user; SET @s = CONCAT('CREATE DATABASE ', name); PREPARE stmt_create FROM @s; EXECUTE stmt_create; DEALLOCATE PREPARE stmt_create; SET @s = CONCAT('GRANT ALL PRIVILEGES ON ', name, '.* TO ', user, ' WITH GRANT OPTION'); PREPARE stmt_grant FROM @s; EXECUTE stmt_grant; DEALLOCATE PREPARE stmt_grant; END IF; END // DELIMITER ; call create_db(@DB_NAME); I took the help of how do I use a variable in create database statement for creating this procedure. While running this procedure over mysql i am getting error : ERROR 1046 (3D000): No database selected I have googled it a lot but is unable to fix it. While trying different things i tried to execute the above procedure by first executing: mysql> USE mysql; Using that, error is gone. And mysql> show databases; is displaying all the databases along with the newly created database. Could somebody tell me whether using mysql as default database is correct or not. If somebody has another method please tell it to me. mysql mysql-error-1046 share|improve this question asked Jul 1 '13 at 10:23 user2311046 3418 add a com
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 #1046 - no database selected import Us Learn more about Stack Overflow the company Business Learn more about hiring error code 1046 in mysql workbench developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the no database selected mysql command line 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 Importing using MySQL WorkBench… error http://stackoverflow.com/questions/17402181/create-procedure-error-1046-3d000-no-database-selected ERROR 1046 (3D000) up vote 2 down vote favorite 1 Scenario: building a RoR enviroment locally for development. Production is on EngineYard / GitHub. All now working ok, except DB isn't importing. I have a .sql file that i've taken from my prod EY site. Now i need to import it to my MySQL locally. I'm using Workbench (as i'm new to this), but getting error http://stackoverflow.com/questions/5787130/importing-using-mysql-workbench-error-error-1046-3d000 below. Please help? 08:07:43 Restoring /home/james/Downloads/Futology.sql Running: mysql --defaults-extra-file="/tmp/tmpAVeE58/extraparams.cnf" --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments < "/home/james/Downloads/Futology.sql" ERROR 1046 (3D000) at line 22: No database selected Operation failed with exitcode 1 08:07:43 Import of /home/james/Downloads/Futology.sql has finished with 1 errors mysql mysql-error-1046 share|improve this question edited May 2 '13 at 14:54 fthiella 32.9k114272 asked Apr 26 '11 at 7:13 RedCuber 22125 add a comment| 6 Answers 6 active oldest votes up vote 6 down vote accepted Not used Workbench too much however it's easy enough to do from command line have a look at this (below the phpMyAdmin bit) - http://bit.ly/91e7aD. The command you're after is: mysql -u #username# -p #database# < #dump_file# share|improve this answer answered Apr 26 '11 at 8:01 charliequinn 24019 I don't have a dump file, it's a .sql file which isn't letting me import. The imported DB is called company_production. I assume i need to create a DB somewhere called company_production then import? If so, how!? Thanks –RedCuber Apr 26 '11 at 9:25 A DB dumpfile is just a list of SQL statements used to create your schema and populate data. The .sql file you have should
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 http://stackoverflow.com/questions/17126677/mysql-error-1046-no-database-selected Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community https://bugs.mysql.com/bug.php?id=73590 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 MySQL Error: #1046 - No database selected up vote 1 down vote favorite I ran into an issue using MySQL 5.5 running on xampp (Version 1.8.1). I kept receiving the "#1046 - No database selected" error when trying to add a table to a no database database via the console window. I had made sure the database was selected "USE database_name;", however I was still receiving the same error. I double checked and found all privileges for the user were enabled. Frustrated, I "Uncheck All" then "Check All" global privileges. I logged out, restarted server services, closed the browser, restarted server services, opened browser, and logged in. Now I am able to create tables via the console. It appears to me resetting the privileges fixed the issue. Can anyone tell me no database selected if this is a known bug, if I got lucky, or missed the point completely? Documentation I found concerning this error was mostly for importing a database and using the "Use Database_Name;" to ensure the database was indeed selected. However I don't believe this was the issue. Please Note: While trying to create new databases I am once again receiving the #1046 error. The method I mentioned above was a fluke and is not allowing me to create any new tables inside a new database. However I am still able to work with the first database I created. mysql share|improve this question edited Jun 18 '13 at 2:43 asked Jun 15 '13 at 18:27 user2038001 11125 add a comment| 3 Answers 3 active oldest votes up vote 7 down vote I know this is a very late answer but for the benefit of anyone coming across this error, it might also pop up when the database name includes a dash. If so you need to put backticks around the database name, like so: GRANT ALL ON `database-name`.* TO 'username'@'localhost'; The error message is not very helpful as it suggest you need to select a database in order to grant privileges to a user. share|improve this answer answered Oct 10 '14 at 14:07 rkhff 3861613 This was exactly my issue, thanks! –jeffwtribble Dec 12 '15 at 20:44 add a comment| up vote 4 down vote Another late answer but this can also happen when the table name (.*) is not specified. I r
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 [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 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 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 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