error 1046 no database selected sql statement use
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 no database selected mysql error this site About Us Learn more about Stack Overflow the company Business Learn
#1046 - No Database Selected Import
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question no database selected php x Dismiss Join the 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 (3d000) no database selected grant Error #1046 - No database selected SQL import on XAMPP up vote 15 down vote favorite 2 I am trying to import the SQL database from my Drupal production site into a sandbox testing site on my local machine. I currently use XAMPP on my machine here at work. I have downloaded my db aipiadxxm_if9DHdr.sql and then I go to the phpMyAdmin onNo Database Selected Mysql Workbench Import
http://localhost/phpmyadmin/index.php then to -> Import. After I import the db I get this Error: SQL query: -- -- Database: `aipiadxxm_if9DHdr.sql` -- -- -------------------------------------------------------- -- -- Table structure for table `if9d_access` -- CREATE TABLE IF NOT EXISTS `if9d_access` ( `aid` int( 11 ) NOT NULL AUTO_INCREMENT , `mask` varchar( 255 ) NOT NULL default '', `type` varchar( 255 ) NOT NULL default '', `status` tinyint( 4 ) NOT NULL default '0', PRIMARY KEY ( `aid` ) ) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1; MySQL said: Documentation #1046 - No database selected What is causing this error message: #1046 - No database selected ? mysql sql drupal phpmyadmin xampp share|improve this question edited Aug 12 '13 at 1:33 Eric Leschinski 46.3k23221190 asked Jul 11 '12 at 17:46 accraze 54341034 1 It looks like the .sql file is just the table. Try creating the database in phpmyadmin, then importing the file as a table. –PeaBucket Jul 11 '12 at 18:14 add a comment| 1 Answer 1 active oldest votes up vote 37 down vote accepted You need to create and/or select the database on your sandbox mDu siehst YouTube auf Deutsch. Du kannst 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. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird no database selected mysql command line geladen... Wiedergabeliste Warteschlange __count__/__total__ Fix #1046 - No database selected itcs program AbonnierenAbonniertAbo no database selected mysqli beenden269269 Wird geladen... Wird geladen... Wird verarbeitet... Hinzufügen Möchtest du dieses Video später noch einmal ansehen? Wenn du bei YouTube
Error Code 1046 In Mysql Workbench
angemeldet bist, kannst du dieses Video zu einer Playlist hinzufügen. Anmelden Teilen Mehr Melden Möchtest du dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. Anmelden 22.746 Aufrufe 73 Dieses Video gefällt http://stackoverflow.com/questions/11438427/error-1046-no-database-selected-sql-import-on-xampp dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 74 7 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 8 Wird geladen... Wird geladen... Wird geladen... Die Bewertungsfunktion ist nach Ausleihen des Videos verfügbar. Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es später erneut. Veröffentlicht am 24.04.2015how to fix ERROR : #1046 - No database https://www.youtube.com/watch?v=ZciWnmcf7fU selected MySQL said: Documentation#1046 - No database selected Kategorie Gaming Lizenz Standard-YouTube-Lizenz Mehr anzeigen Weniger anzeigen Wird geladen... Anzeige Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video MySQL Tutorial for Beginners - 1 - Creating a Database and Adding Tables to it - Dauer: 8:50 primetubervideos 652.205 Aufrufe 8:50 1046 Error in SQL In phpMyAdmin[Solved] - Dauer: 1:34 Zaroon bin hadi 254 Aufrufe 1:34 IMPORTAR EXPORTAR BASE DATOS SQL PHPMYADMIN - Dauer: 8:00 APRENDIZ WEBMASTER 7.940 Aufrufe 8:00 How to Fix No Database Selected Problem in MySQL - Dauer: 1:54 Codescoder Program 758 Aufrufe 1:54 SERVIDOR WEB CON XAMPP CONFIGURACION DEL PUERTO 80 - Dauer: 15:12 Jose Muñoz 17.600 Aufrufe 15:12 PHP and MySQL with MySQLi: Getting results (Part 4/9) - Dauer: 16:09 Codecourse 78.615 Aufrufe 16:09 how to import and export data base in sql 2015 - Dauer: 10:52 indian highway 260 Aufrufe 10:52 "No Database Selected" Error During The SQL File Import - Dauer: 1:44 TemplateMonsterCo 3.022 Aufrufe 1:44 Connect to MySQL with PHP in XAMPP / Create a new database - Dauer: 6:41 Ken Swartwout 308.745 Aufrufe 6:41 What is Database & SQL? - Dauer: 6:20 Guru"#1046: No database selected" error when trying to import a .sql file in phpMyAdmin. Solution #1: Before importing In phpMyAdmin, click on the Export tab from the home page of phpMyAdmin, http://wisercoder.com/how-to-fix-the-1046-no-database-selected-error-in-phpmyadmin/ without selecting any database. phpMyAdmin will then include instructions to create and select the database when you import it. This solution does not apply to most shared hosts, since they won't allow you to create a http://dba.stackexchange.com/questions/27245/error-1046-mariadb-no-database-selected database from phpMyAdmin. Solution #2: The alternative fix Unlike solution #1, this one also works on shared hosts. Create the new database on your server, then write down the name. Open your .sql file with no database a text editor Insert the following line right before the first CREATE TABLE instruction in your .sql file: USE your_database_name_here; Save your file, then import it in phpMyAdmin. SQL Tagged database, errors, mysql, phpmyadmin, sql ← How to get an Integer from a Java resultset How to properly validate email addresses in Java → 21 comments on “How to fix the "#1046: No database selected" error in phpMyAdmin” carle November 13, no database selected 2013 at 11:34 pm many thanks! save my life! Reply Sam June 3, 2014 at 2:08 pm What i get when i export my database is a notepad file format showing mywebname.sql instead of the normal sql file for upload to liveserver….please help as i dont know what could be wrong. Reply Nicolas Bouliane June 3, 2014 at 3:05 pm Upload that file in the import form Reply Manish Atri November 19, 2013 at 7:43 am Thanks a lot Buddy Reply Juanita Alcachofa December 5, 2013 at 6:32 pm Muy bueno, me sirvió. Reply Ivan January 3, 2014 at 11:07 pm Thank you! Solution #2 worked for me! Reply Pizo January 13, 2014 at 10:41 pm Thank you! Reply Mr January 21, 2014 at 11:54 pm Just wanted to add, since your solution led me to the answer : It's all because there is an existing database of the hosting company and they won't allow you to open one yourself, but rather suit yours into theirs. The solution therefore is to 1.export your database in sql format from phpmyadmin localhost 2.open that file with notepad++ 3.edit the first lines to this CREATE DATABASE IF NOT EXISTS hosting_db01 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE hosting_db01
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 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, y