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 the company Business Learn mysql error 1064 create user more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags error 1064 mysql 42000 create table Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you,
Error 1064 Mysqldump
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 Now I'm no MySQL pro, but I've been
Sql Error 1064
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 (42000): You have an error in your SQL syntax; check the manual error 1064 sqlstate 42000 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,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
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
Error 1064 Sqlstate 42000 (er_parse_error)
Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu error 1064 you have an error in your sql syntax Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu error 1064 mysql workbench Forum Community Ubuntu Specialised Support 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 http://stackoverflow.com/questions/4782002/cant-seem-to-create-user-in-mysql-console-error-1064-42000 debug the posting issues ? < is the 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 https://ubuntuforums.org/showthread.php?t=2238624 Beans 25 DistroUbuntu 14.04 Trusty Tahr MySQL error while attempting to 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 gav
reply 6 posts by porky996t » Sun Nov 01, 2015 5:55 pm Hi,I'm just getting familiar with the commands used to manipulate and populate MySQL database tables.I have set https://www.raspberrypi.org/forums/viewtopic.php?t=124870&p=837738 up a Database called 'times' and wish to create a user called 'timequery'. I have tried:-Code: Select allmysql> CREATE USER ‘timequery’@’localhost’ IDENTIFIED BY ‘password';However, I keep getting the following :-Code: Select allERROR 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 'IDENTIFIED BY 'password' at line 1I have Googled several error 1064 MySQL and Raspi articles and each one show that this is how a new user is created. Am I being a bit dumb and missing something obvious here? BTW, I have a Raspi 2, Model B+ with Debian installed and have the latest version of MySQL installed too.Thanking you in advance of any help that can be given.Cheers,Porky. Posts: 4Joined: Sun Nov 01, 2015 11:42 amLocation: Bolton, error 1064 mysql Lancashire, England by emgi » Sun Nov 01, 2015 6:30 pm Had to check this because I don't use MySQL that often but it appears you are using the wrong quote-symbol.In your post they look like ` which are next to the 1-key on the left-hand top of the keyboard. You should use ' which is (on my US-International keyboard) next to the Enter-key. However, instead of using the still rather bulky MySQL you may want to have a look at SQLite ( https://www.sqlite.org/) which is THE lightweight SQL database. Even on a Pi2 where you may think it's not such a big deal it will give you better performance without sacrificing too much functionality. /emgi Posts: 320Joined: Thu Nov 07, 2013 4:08 pmLocation: NL by porky996t » Sun Nov 01, 2015 7:17 pm @emgiThanks for the quick response. I have tried again using both the ` (to the immediate left of the 1 key) and also ' (to the immediate left of the Enter key) and neither is successful. I still get the same error code about syntax.Cheers,Porky. Posts: 4Joined: Sun Nov 01, 2015 11:42 amLocation: Bolton, Lancashire, England by rpdom » Sun Nov 01, 2015 7:23 pm It works