Error No Database Selected 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 mysql create database About Us Learn more about Stack Overflow the company Business Learn more about
Error 1064 No Database Selected
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join error 1046 3d000 no database selected 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 No database Selected, error 1046 no database selected import 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
1046 No Database Selected Wordpress
help here. sql mysql mysql-error-1046 share|improve this question edited Oct 23 '10 at 18:21 OMG Ponies 199k36356415 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 213 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:
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can change #1046 - no database selected import this preference below. Schließen Ja, ich möchte sie behalten no database selected php Rückgängig machen Schließen Dieses Video ist nicht verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... Wiedergabeliste
No Database Selected Mysql Workbench Import
Warteschlange __count__/__total__ Fix #1046 - No database selected itcs program AbonnierenAbonniertAbo beenden271271 Wird geladen... Wird geladen... Wird verarbeitet... Hinzufügen Möchtest du dieses http://stackoverflow.com/questions/4005409/error-1046-no-database-selected-how-to-resolve Video später noch einmal ansehen? Wenn du bei YouTube 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 23.012 Aufrufe 74 Dieses Video gefällt dir? Melde dich https://www.youtube.com/watch?v=ZciWnmcf7fU bei YouTube an, damit dein Feedback gezählt wird. Anmelden 75 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 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 656.101 Aufrufe 8:50 1046 Error in SQL In phpMyAdmin[Solved] - Dauer: 1:34 Zaroon bin hadi 360 Aufruf
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might http://dba.stackexchange.com/questions/27245/error-1046-mariadb-no-database-selected have Meta Discuss the workings and policies of this site About http://www.tomsguide.com/answers/id-2518591/mysql-error-1046.html 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 no database 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 no database selected 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 108k15138274 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
error 1046 Tags: Localhost MySQL Last response: February 2, 2015 12:26 PM in Apps General Discussion Share mundomundo February 2, 2015 1:29:10 AM Hi everyone! I need to import the file into my local host joomla installation. But I'm receiving the error: SQL query: Table structure for table `bak_banner` DROP TABLE IF EXISTS `bak_banner` ; MySQL said: Documentation #1046 - No database selected Can you help me out? More about : mysql error 1046 Best solution Haavik February 2, 2015 12:26:44 PM Hi mundomundo! For the database import, before you attempt to import the "flat" file data in, you need go to your local DB (MySQL) and create new database After that you can import! If it useless try this tool http://www.repairtoolforsql.fixtoolbox.com/ Fix Toolbox for MySQL I found it here http://www.filerepairforum.com/forum/databases/database... Share Can't find your answer ? Ask ! Publish Ask the community Tags Example: Notebook, Android, SSD hard drive Publish Latest experts Robert Cook Graphics card Master a b U Also expert in: CPUs, Motherboard, AMD maxalge Graphics card Master a b U Also expert in: CPUs, AMD, Motherboard Dynomite54 CPUs Expert a b à Also expert in: Motherboard, Graphics card Scores All badges Forum help Latest Reports Amped Wireless RTA1300M: Solid Performaning Router with Short Range Best Chrome Apps Samsung 55-inch KS9000 SUHD 4K TV Review: Sparkling HDR Picture Samsung 65-inch KS9800 4K Ultra HD TV Review: A Curved Beauty LG 55-Inch B6 4K Ultra HD TV Review: OLED for Less Tom’s guide in the world Germany France Italy Ireland UK About Us | Contact Us | Legal | Terms Of Use and Sale | Privacy | Copyright Policy | Purch Privacy Policy | Advertising | Computing.Net Copyright © 2016 Purch Group, Inc. All Rights Reserved. Ad choices Follow Tom’s guide Subscribe to our newsletter Sign up add to twitter add to facebook ajouter un flux RSS