Error 1064 Mysql Create User
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
Error 1064 Mysql 42000 Create Table
Us Learn more about Stack Overflow the company Business Learn more about hiring error 1064 mysql 42000 create database developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the error 1064 mysql 42000 mysqldump Stack 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 Can't seem to create user
Error 1064 Mysql 42000 Grant All
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 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
Error 1064 Mysql Workbench
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 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,29053567 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,29053567 add a comment| up vote
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu Wiki Community error 1064 mysql 42000 insert Wiki Other Support Launchpad Answers Ubuntu IRC Support AskUbuntu Official Documentation User
Error 1064 Mysql 42000 You Have An Error In Your Sql Syntax
Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu error 1064 mysql 42000 foreign key Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Specialised Support Ubuntu Servers, Cloud and Juju Server Platforms [SOLVED] MySQL error http://stackoverflow.com/questions/4782002/cant-seem-to-create-user-in-mysql-console-error-1064-42000 while attempting to create a new user Having an Issue With Posting ? Do you want to help us 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 https://ubuntuforums.org/showthread.php?t=2238624 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 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.
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 up a Database called 'times' and wish to https://www.raspberrypi.org/forums/viewtopic.php?t=124870&p=837738 create a user called 'timequery'. I have tried:-Code: Select allmysql> CREATE USER ‘timequery’@’localhost’ IDENTIFIED http://www.inmotionhosting.com/support/website/database-troubleshooting/error-1064 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 MySQL and Raspi articles and each one show that this is how a new error 1064 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, Lancashire, England by emgi » Sun Nov 01, 2015 6:30 pm Had to check this because I don't use MySQL that often error 1064 mysql 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 for me, with the quotes corrected:Code: Select allmysql> CREATE USER 'timequery'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)
Posts: 9529Joined: Sun May 06, 2012 5:17 amLocation: Essex, UK by DougieLawson » Sun Nov 01, 2015 7:35 pm sudo a
DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR OWN WEBSITE SITE HOSTING TOOLS MEET US MEET US ABOUT US PARTNERS & AWARDS BLOG WE'RE HIRING CONTACT 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 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 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)Pu