ERROR 1064 (42000) at line 1

Problems with the Windows version of XAMPP, questions, comments, and anything related.

ERROR 1064 (42000) at line 1

Postby ebermed » 02. April 2010 18:11

Is this information top secret? I have been searching now for 2days for the "rprper syntax" I am UPDATE mysql.user SET Password = PASSWORD<'newpassword'> WHERE user = 'root';
After I hit enter I get this 1604 (4600) syntax error check manual for version you are using for correct syntax. I am using this mysql XAMPP package for a BEGINNERS online course for MSQL at lynda.com I think I found the manual but it sdoes not make any sense to me I AM A BEGINNER!!!!! So who do I have to pay homage too in order to be enlightened to the proper syntax? So far this MySQL has been on GIANT PAIN IN THE ASS!!!!!

FRUSTRATED in Middle burg Fl

Mike E :cry: :evil: 8) [img/img]
ebermed
 
Posts: 7
Joined: 02. April 2010 17:01

Re: ERROR 1064 (42000) at line 1

Postby ebermed » 03. April 2010 17:25

I did check google and bing and Yahoo and other forum like this one. I do not think that it was as much that I could not find the answer but that I could not understand and thus process the information that I was viewing. I have BTW received from one of the instructors at lynda.com the information about the syntax a matter of "( )" vs "< > ". Your comment was quite helpful in contributing to the "Mysql GREAT Big Pain in the ASS" issue.

Yes ur,

Mike E
ebermed
 
Posts: 7
Joined: 02. April 2010 17:01

Re: ERROR 1064 (42000) at line 1

Postby ebermed » 14. April 2010 06:06

I was using <> instead of ()

That simple for such a huge PITA

Cheres
MIke
ebermed
 
Posts: 7
Joined: 02. April 2010 17:01


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 107 guests