WampServer
Apache, PHP, MySQL
on Windows
mysql configuration syntax(creating password)
Posted by:
CrossOverBen
(---.bb.sky.com)
Date: May 01, 2008 08:49PM
hello can somebody help me with the configuration syntax, i was trying to configure mysql with a password
and tells me that there's an error with the syntax WHERE
the code i used was
mysql> UPDATE user
-> SET Password=PASSWORD<'***PHP*'>
->WHERE user='root';
it has to do with my version 5.0.51a
the exact error message is like this
ERROR 1064 <42000>: You have an in your sql syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE.
Please i will be gratefull for anybodies help. thank you
and tells me that there's an error with the syntax WHERE
the code i used was
mysql> UPDATE user
-> SET Password=PASSWORD<'***PHP*'>
->WHERE user='root';
it has to do with my version 5.0.51a
the exact error message is like this
ERROR 1064 <42000>: You have an in your sql syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE.
Please i will be gratefull for anybodies help. thank you
Re: mysql configuration syntax(creating password)
Posted by:
yfastud
(Moderator)
Date: May 01, 2008 09:40PM
update user set password=PASSWORD("NEWPASSWORD"
where user='root'
it should be all in 1 line, not 3 lines like yours or you can follow my guide to setup password[guides.jlbn.net]
Have fun,
FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides
Edited 1 time(s). Last edit at 05/01/2008 09:41PM by yfastud.
Sorry, only registered users may post in this forum.
