Mysql Create User Error 1064
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 Learn more about Stack Overflow error 1064 mysql 42000 you have an error in your sql syntax the company Business Learn more about hiring developers or posting ads with us Stack
Error 1064 Mysql 42000 Create Table
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of error 1064 (42000) 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Can't seem to create user in MySQL console (ERROR 1064 (42000)) up vote 1 down vote favorite 1
Error 1064 Mysql 42000 Create Database
Now I'm no MySQL pro, but I've been using it for a good 5-6 years and I've never come across this: I log into my server via SSH I log into MySQL via mysql -u root -pSUPER_SECRET_PASSWORD I write: CREATE USER 'magical_username'@'locahost' IDENTIFIED BY 'super_magical_password'; Now this is where it gets weird. I expect the query to work and I can go about granting permissions, but, I get this instead: ERROR 1064 mysql 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 'USER 'magical_username'@'localhost' IDENTIFIED BY 'super_magical_password' at line 1 Any ideas? mysql user share|improve this question edited Jul 20 at 15:27 akshay naidu 95 asked Jan 24 '11 at 12:34 Ahmed Nuaman 4,30053567 add a comment| 3 Answers 3 active oldest votes up vote 3 down vote accepted This isn't really an answer but a solution to the problem: It turns out that the magical sysadmin, in all his wisdom, thought it was a good idea to copy over MySQL's raw DB files rather than doing a dump and import. This, coupled with incorrect permissions and MySQL versions, meant that MySQL had a big issue with users and granting, but serving the data was fine (that's why it seemed really weird). Long story short: rebuilt the box and imported the data the correct way :) share|improve this answer answered Jan 26 '11 at 10:50 Ahmed Nuaman 4,30053567 add a comment| up vote 0 down vote does the equivalent GRANT USAGE ON ... version work? share|improve this answer answered Jan 24 '11 at 12:37 Marc B 273k24233352 add a comment| up vote 0 down vote I've had exactly the same problem
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
Mysql Syntax Checker
Overflow the company Business Learn more about hiring developers or posting ads with us
Error 1372 (hy000): Password Hash Should Be A 41-digit Hexadecimal Number
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community check mysql version of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up unable to create new user in mysql up vote 0 down vote favorite I am trying http://stackoverflow.com/questions/4782002/cant-seem-to-create-user-in-mysql-console-error-1064-42000 to create a new user in mysql 5.6, but while executing the query i am getting an error. please help. mysql> create user dsuser@'%' indentified by 'Passw0rd';
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 'indentified by 'Passw0rd'' at line 1 mysql mysql-workbench mysql-error-1064 share|improve this question edited Feb 9 '15 http://stackoverflow.com/questions/28403806/unable-to-create-new-user-in-mysql at 6:17 Jens 37.5k112848 asked Feb 9 '15 at 6:13 raj 73110 The keyword is spelled IDENTIFIED, not INDENTIFIED. –spencer7593 Feb 9 '15 at 6:32 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote accepted CREATE USER 'dsuser'@'%' IDENTIFIED BY 'Passw0rd'; Don't forget the quotes around your username as well. share|improve this answer answered Feb 9 '15 at 6:20 marcusds 10713 add a comment| up vote 0 down vote create user 'dsuser'@'%' indentified by 'Passw0rd'; share|improve this answer answered Feb 9 '15 at 6:16 StackBox 1786 @Jens - Quotes around the username, because it's needed. –Joel Cox Feb 9 '15 at 6:18 @JoelCox please add the explanation to your answer. –Jens Feb 9 '15 at 6:19 same error for this also. I tried it already. –raj Feb 9 '15 at 6:19 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, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged mysql my
DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR OWN WEBSITE SITE HOSTING TOOLS MEET US MEET US http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064 ABOUT US PARTNERS & AWARDS BLOG WE'RE HIRING CONTACT https://dev.mysql.com/doc/refman/5.5/en/create-user.html US AMP LOGIN SUPPORT CENTER Search Support Center Product Guides Dedicated Hosting Reseller Hosting KnowledgeBase Website Email Domain Names Reseller Billing Community Support Browse Questions Ask a Question User Submitted Articles Education Channels Android BoldGrid cPanel DokuWiki Drupal error 1064 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 3 Web Hosting Manager Website Design WordPress Tools & Resources Email error 1064 mysql 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 Builder (22)Prestashop (1)Protecting Files (5)Publishing Your Site (2)Python (1)Redirects (4)Restricting Bots (5)Search Engine Optimization (1)Secure Socket Layer (SSL) Tutorials (13)Security (12)Sending Email From W
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.5 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax Data Definition Statements ALTER DATABASE Syntax ALTER EVENT Syntax ALTER FUNCTION Syntax ALTER LOGFILE GROUP Syntax ALTER PROCEDURE Syntax ALTER SERVER Syntax ALTER TABLE Syntax ALTER TABLE Partition Operations ALTER TABLE Online Operations in MySQL Cluster ALTER TABLE Examples ALTER TABLESPACE Syntax ALTER VIEW Syntax CREATE DATABASE Syntax CREATE EVENT Syntax CREATE FUNCTION Syntax CREATE INDEX Syntax CREATE LOGFILE GROUP Syntax CREATE PROCEDURE and CREATE FUNCTION Syntax CREATE SERVER Syntax CREATE TABLE Syntax CREATE TABLE ... LIKE Syntax CREATE TABLE ... SELECT Syntax Using FOREIGN KEY Constraints Silent Column Specification Changes CREATE TABLESPACE Syntax CREATE TRIGGER Syntax CREATE VIEW Syntax DROP DATABASE Syntax DROP EVENT Syntax DROP FUNCTION Syntax DROP INDEX Syntax DROP LOGFILE GROUP Syntax DROP PROCEDURE and DROP FUNCTION Syntax DROP SERVER Syntax DROP TABLE Syntax DROP TABLESPACE Syntax DROP TRIGGER Syntax DROP VIEW Syntax RENAME TABLE Syntax TRUNCATE TABLE Syntax Data Manipulation Statements CALL Syntax DELETE Syntax DO Syntax HANDLER Syntax INSERT Syntax INSERT ... SELECT Syntax INSERT DELAYED Syntax INSERT ... ON DUPLICATE KEY UPDATE Syntax LOAD DATA INFILE Syntax LOAD XML Syntax REPLACE Syntax SELECT Syntax SELECT ... INTO Syntax JOIN Syntax UNION Syntax Subquery Syntax The Subquery as Scalar Operand Comparisons Using Subqueries Subqueries with ANY, IN, or SOME Subqueries with ALL Row Subqueries Subqueries with EXISTS or NOT EXISTS Correlated Subqueries Subqueries in the FROM Clause Subquery Errors Optimizing Subqueries Rewriting Subqueries as Joins UPDATE Syntax Transactional and Locking Statements START TRANSACTION, COMMIT, and ROLLBACK Syntax Statements That Cannot Be Rolled Back Statements That Cause an Implicit Commit SAVEPOINT, ROLLBACK TO SAVEPOINT,