error 1064 mysql

Tredo · 12-02-2004, 01:34 PM

Error 1064: You have an error in your SQL syntax near 'password for' snort'@'localhost'=password ('')' at line 1

That problem comes up when im trying to set password for snort at mysql,

im typing mysql> set password for 'snort'@'localhost'=password('');

How can i solve this?

Tanx!

sigsegv · 12-02-2004, 03:56 PM

Try this instead (You must have ALTER to mysql.users (i.e. root))

Code:

GRANT <perms> ON dbname.* TO snort@localhost identified by 'PASSWORD';

Tredo · 12-02-2004, 04:26 PM

I will try It out!

Tanx!

Capt_Caveman · 12-02-2004, 04:57 PM

I think the syntax you were going for was (using "foo" as the snort password):

mysql> SET PASSWORD FOR snort@localhost=PASSWORD('foo');

Tredo · 12-02-2004, 05:24 PM

LOL right!