Mysql Error 1064 Create Database
Contents |
HCL Search Reviews Search ISOs Go to Page... LinuxQuestions.org > Forums > Linux Forums > Linux - Server [SOLVED] error 1064 mysql 42000 you have an error in your sql syntax mysql error while creating database User Name Remember Me? Password Linux
Error 1064 (42000) At Line 1
- Server This forum is for the discussion of Linux Software used in a server related context. error 1064 mysql 42000 create table Notices Welcome to LinuxQuestions.org, a friendly and active Linux Community. You are currently viewing LQ as a guest. By joining our community you will have the ability to error 1064 mysql 42000 mysql import post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today! Note that registered members see fewer ads, and ContentLink is completely disabled once you log in. Are you new to LinuxQuestions.org? Visit the following links: Site Howto |
Error 1064 Mysql 42000 Insert
Site FAQ | Sitemap | Register Now If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here. Having a problem logging in? Please visit this page to clear all LQ-related cookies. Introduction to Linux - A Hands on Guide This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own. Click Here to receive this Complete Guide
DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR OWN WEBSITE SITE HOSTING TOOLS error 1064 mysql 42000 foreign key MEET US MEET US ABOUT US PARTNERS & AWARDS you have an error in your sql syntax check the manual that corresponds to your mysql server version BLOG WE'RE HIRING CONTACT US AMP LOGIN SUPPORT CENTER Search Support Center Product
Mysql Server Version For The Right Syntax To Use Near '' At Line 1
Guides Dedicated Hosting Reseller Hosting KnowledgeBase Website Email Domain Names Reseller Billing Community Support Browse Questions Ask a Question User Submitted http://www.linuxquestions.org/questions/linux-server-73/mysql-error-while-creating-database-894292/ Articles Education Channels Android BoldGrid cPanel DokuWiki Drupal 7 Drupal 8 Everything Email Joomla 2.5 Joomla 3.1 K2 Magento 1.6 Mambo MediaWiki Moodle Movable Type OpenCart OpenCart 2.0 osCommerce PHP-Fusion PHP-Nuke phpBB phpList Premium Website Builder PrestaShop 1.5 PrestaShop 1.6 SMF Tiki Wiki VirtueMart http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064 3 Web Hosting Manager Website Design WordPress Tools & Resources Email Configuration Blacklist Check Visual DNS Lookup Quick Tagger Icon Sets Favicon Generator Bounce Back Parser What is my IP address? >>Website .htaccess (17)Adobe Flash (2)APIs (2)Backup and Restore (15)Billing (8)Browser Issues (2)Connecting to a Database (5)cPanel (26)cPanel Account Management (16)Cron Jobs (4)Cube Cart (2)Database Setup (5)Database Troubleshooting (6)Domain Management (2)Dreamweaver (12)Drush (2)eCommerce (7)Elasticsearch (4)Fantastico (4)File Management (16)File Manager (6)FTP (10)FTP Client Setup (21)General Server Setup / Management (15)Getting Started Guides (18)Ghost (3)Google Tools (21)How To (23)HTML (2)Image Editing (2)IP Addresses (3)iWeb (1)JavaScript (2)Joomla (10)Joomla 2.5 (36)Koken (11)Linux (27)Logaholic (5)Magento (2)Maintaining Your Website (1)Managing Files (7)Microsoft FrontPage (11)Microsoft Publisher (1)ModSecurity (7) MODx (3)New Customers (7)Open Classifieds (1)PCI Compliance (7)PHP (15)PHP Configuration (7)PHP Troubleshooting (6)phpBB (25)phpMyAdmin (10)Premium Website Buil
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 http://stackoverflow.com/questions/4962904/how-can-i-create-a-mysql-database Us Learn more about Stack Overflow the company Business Learn more about hiring https://ask.openstack.org/en/question/53985/error-1064-when-creat-database-for-openstack/ developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users 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 minute: Sign up How can I create a MySQL-database error 1064 up vote 2 down vote favorite I tried to create a database by the following command: mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,ALTER,INDEX,DROP, -> CREATE TEMPORARY TABLES,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE, -> EXECUTE,CREATE VIEW,EVENT,TRIGGER -> ON {projekti_db}.* -> TO '{asiakas}'@'localhost'; and got the following error message 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 error 1064 mysql use near '{projekti_db}.* TO '{asiakas}'@'localhost'' at line 4 I have MySQL 5.1.37. What am I doing wrong? mysql share|improve this question edited Feb 10 '11 at 21:33 JohnFx 28.5k1479138 asked Feb 10 '11 at 21:28 Jaakko 132 add a comment| 3 Answers 3 active oldest votes up vote -1 down vote accepted # # First create the Database # CREATE DATABASE projekti_db; # # Then Create the User that will access that database # GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,ALTER,INDEX,DROP, CREATE TEMPORARY TABLES,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE, EXECUTE,CREATE VIEW,EVENT,TRIGGER ON projekti_db.* TO 'asiakas'@'localhost'; # # Now verify that the user asiaskas can access the projekti_db only from localhost # SHOW GRANTS FOR 'asiakas'@'localhost'; Give it a Try !!! share|improve this answer edited May 7 '14 at 11:36 answered Feb 10 '11 at 21:42 RolandoMySQLDBA 29.9k105495 add a comment| up vote 0 down vote You are trying to assign roles to a user on a certain database. To create a database, use CREATE DATABASE NAME; share|improve this answer answered Feb 10 '11 at 21:30 Femaref 48.3k391132 Ok, but the same mistake occurs after the query create database projekti_db; –Jaakko Feb 10 '11 at 21:34 don't use curly braces. –Fem
Anonymous updated 2014-11-21 10:06:26 -0500 smaffulli 6896 ●36 ●67 ●100 http://maffulli.net/ im deploying Openstack and have a problem. i installed mysql like that: sudo apt-get install mysql-server python-mysqldb after i want to create a database for Nova as below: Create MySQL databases to be used with nova, glance and keystone. Create a database named nova. sudo mysql -uroot -pmygreatsecret -e ’CREATE DATABASE nova;’ but i get an error ERROR 1064 (42000) at line 1: 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 'CREAT DATABASE nova' at line 1 please help me to resolve it. edit retag flag offensive close merge delete add a comment 2 answers Sort by » oldest newest most voted 0 answered 2014-11-21 10:07:45 -0500 smaffulli 6896 ●36 ●67 ●100 http://maffulli.net/ Check the error message, looks like a typo to me: CREAT DATABASE nova. edit flag offensive delete link more add a comment 1 answered 2014-12-02 03:42:39 -0500 PradeepNaik 1019 ●6 ●12 ●25 http://www.pthinks.in/ HELLO, just type in terminal, mysql -u root -p (provide root password) create database nova; grant all privileges on nova.* to 'nova'@'localhost' identified by 'NOVA DBPASS'; grant all privileges on nova.* to 'nova'@'%' identified by 'NOVA DBPASS'; type: exit (come out of the mysql prompt) then type: su -s /bin/sh -c "nova-manage db_sync" keystone edit flag offensive delete link more add a comment Your Answer Please start posting anonymously - your entry will be published after you log in or create a new account. Add Answer [hide preview] Get to know Ask OpenStack Resources for moderators Question Tools Follow 1 follower subscribe to rss feed Stats Asked: 2014-11-21 01:43:25 -0500 Seen: 330 times Last updated: Dec 02 '14 Related questions Deploying mysql mmm service on grizzly [closed] packstack --allinone error [closed] packstack and remote mysql server [closed] Is grizzly compatible with mysql cluster? Openstack Havana - Ldap / MySQL authentication "You are not authorized for any projects." Error populating neutron database How to quickly purge and recreate Keystone Token DB? Build MySQL HA on openstack What are the w