create user error 1064
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 mysql error 1064 create user us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
Error 1064 Mysql 42000 Create TableOverflow 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 error 1064 mysqldump up Can't seem to create user in MySQL console (ERROR 1064 (42000)) up vote 1 down vote favorite 1 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
Sql Error 1064into 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 (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 error 1064 sqlstate 42000 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,26553567 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,26553567 add a comment| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Subscribed! Success! Please click the link in the confirmation email to activate your subscription. 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 272k23229350 add a comment| up vote 0 down vote I've had exactly the same problem. For me it was because I was using a much older MySQL installation - version 4.1.20. The CREATE USER syntax was only introduced in version 5.x. For o
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu Wiki Community Wiki Other Support Launchpad Answers Ubuntu IRC Support AskUbuntu Official Documentation User Documentation
Error 1064 Sqlstate 42000 (er_parse_error)Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG!
Error 1064 You Have An Error In Your Sql SyntaxUbuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Specialised Support error 1064 mysql workbench Ubuntu Servers, Cloud and Juju Server Platforms [SOLVED] MySQL error while attempting to create a new user Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the http://stackoverflow.com/questions/4782002/cant-seem-to-create-user-in-mysql-console-error-1064-42000 place to report it, thanks ! Results 1 to 10 of 10 Thread: MySQL error while attempting to create a new user Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode August 9th, 2014 #1 Melnik_Hoogland View Profile View Forum Posts Private Message 5 Cups of Ubuntu Join Date Apr 2014 Beans 25 DistroUbuntu 14.04 Trusty Tahr MySQL error while attempting to https://ubuntuforums.org/showthread.php?t=2238624 create a new user Hi, I have a problem with the tutorial at https://www.digitalocean.com/communi...n-ubuntu-12-10. I am up to the point when I am supposed to enter "mysql -Bse "create user 'phpBB'@'localhost' identified by 'PassWord';"" (don't think this is relevant, but due to something in my password, I had to use "\ " instead of double quotes and didn't put single quotes around my password, and I had to put "-u root -p" before the "-Bse"), but I kept getting this error: Code: 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 '(mypassword)' at line 1 (real password replaced with "(mypassword)") After some searching, I found out that this is sometimes caused by the ";" delimiter. So I tried using "--delimiter=//", before and after the "-Bse", with and without backslashes before the slashes, and replacing the ";" with the same thing, but it still gave that error. Finally, I tried using just "mysql -u root -p" and then, at the MySQL prompt, entering: Code: DELIMITER // create user phpBB@localhost identified by (mypassword)// ...but it still gave that error. I tried searching the internet, but didn't find any solution. "mysql --version" outputs "mysql Ver 14.14 Distrib 5.5.38, for debi