Error 1064 Mysql Create Database
Contents |
HCL Search Reviews Search ISOs Go to Page... LinuxQuestions.org > Forums > Linux Forums > Linux - Server [SOLVED] mysql error while creating database User Name Remember Me? Password Linux error 1064 mysql 42000 create database - Server This forum is for the discussion of Linux Software used in a error 1064 mysql import database server related context. Notices Welcome to LinuxQuestions.org, a friendly and active Linux Community. You are currently viewing LQ as a error 1064 mysql 42000 create table guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple
Mysql Error 1064 Create User
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 | 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 error 1064 mysql 42000 mysqldump 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 absolutely free. Search this Thread 07-28-2011, 08:37 AM #1 ramecare Member Registered: Feb 2011 Posts: 179 Rep: mysql error while creating database Dear all, While creating a new database iam facing the below problem,i searched in google to solve but i was not able to solve,can any one help me on this. mysql> create database auto-download-gta; ERROR 1064 (42000): You have a
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 1064 mysql 42000 grant all Learn more about Stack Overflow the company Business Learn more about hiring developers
Error 1064 Mysql Workbench
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
Error 1064 Mysql 42000 Insert
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 1064 (42000): You have an error in http://www.linuxquestions.org/questions/linux-server-73/mysql-error-while-creating-database-894292/ your SQL syntax; up vote 1 down vote favorite 1 I have a MySQL commands: CREATE DATABASE IF NOT EXISTS courses; USE courses CREATE TABLE IF NOT EXISTS teachers( id INT(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT, name VAR_CHAR(50) NOT NULL, addr VAR_CHAR(255) NOT NULL, phone INT NOT NULL, ); When I run it, I get an error: ERROR 1064 (42000): You have an error in your http://stackoverflow.com/questions/18742492/error-1064-42000-you-have-an-error-in-your-sql-syntax SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VAR_CHAR(50) NOT NULL, addr VAR_CHAR(255) NOT NULL, phone INT NOT NULL, )' at line 3 mysql sql share|improve this question edited Mar 5 '15 at 21:58 Adrian Cid Almaguer 6,907122349 asked Sep 11 '13 at 13:24 SkyStar 28129 it's VARCHAR not VAR_CHAR! –John Woo Sep 11 '13 at 13:26 Thank you! Just a simple error ) –SkyStar Sep 11 '13 at 13:27 add a comment| 3 Answers 3 active oldest votes up vote 8 down vote accepted It is varchar and not var_char CREATE DATABASE IF NOT EXISTS courses; USE courses; CREATE TABLE IF NOT EXISTS teachers( id INT(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT, name VARCHAR(50) NOT NULL, addr VARCHAR(255) NOT NULL, phone INT NOT NULL ); You should use a SQL tool to visualize possbile errors like MySQL Workbench. share|improve this answer edited Sep 11 '13 at 13:31 answered Sep 11 '13 at 13:26 juergen d 125k21130196 Won't work, look at phone, you got extra comma there. –N.B. Sep 11 '13 at 13:27 1 What is wrong with "use databasename"? –Born
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 http://dba.stackexchange.com/questions/96161/how-to-solve-error-1064-42000 Stack Overflow the company Business Learn more about hiring developers or posting ads with https://ask.openstack.org/en/question/53985/error-1064-when-creat-database-for-openstack/ 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 error 1064 Anybody can answer The best answers are voted up and rise to the top How to Solve ERROR 1064 (42000)? up vote 0 down vote favorite DROP PROCEDURE IF EXISTS proc_x; DELIMITER # CREATE DEFINER=`root`@`localhost` PROCEDURE proc_x(sequel CHAR) proc_main:BEGIN SET @SQL = CONCAT(@sequel); PREPARE stmt FROM @SQL; EXECUTE stmt; DEALLOCATE PREPARE stmt; END proc_main # Above is a syntax for creating stored procedure in my mysql database. When I execute following error 1064 mysql statement I get error. CALL proc_x("INSERT INTO tbl_rec(id,name,brnachID) values(10,'Krunal',07)"); Error : ERROR 1064 (42000) at line 93: 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 'NULL' at line 1 Can anyone help me to solve it? Currently I'm using Mysql on UNIX. mysql stored-procedures share|improve this question edited Mar 26 '15 at 3:52 ypercubeᵀᴹ 45k775133 asked Mar 25 '15 at 6:54 Krunal Patel 1116 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted (sequel CHAR) CONCAT(@sequel) @variables are totally independent of non-@ variables. Two fixes needed: SET @SQL = CONCAT(@sequel); --> SET @SQL = sequel; (sequel CHAR) --> (sequel VARCHAR(999)) share|improve this answer answered Mar 25 '15 at 17:04 Rick James 17.5k21230 add a comment| up vote -2 down vote Do you get error for every query or while executing this query only? If you are facing problem executing every query,then just go to google,install XAMPP control panel and enable the MySQL button by clicking it. Then find "XAMPP->MySQL->bin" in the parted HDD where you have installed XAMPP and within XAMPP folder. Copy the path go to command prompt go to folder enter the path by
Anonymous updated 2014-11-21 10:06:26 -0500 smaffulli 6886 ●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 6886 ●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: 327 times Last updated: Dec 02 '14 Related questions Deploying mysql mmm service on grizzly [closed] ERROR 1045 (28000): Access denied for user Is grizzly compatible with mysql cluster? keystone HTTP 500 error Any successful trove integration? After installing mariadb-server python-mysqldb. the mysql service does not resta