Thanks, but it was just a typo. And I tried it again, but with the same result. It's
really a strange installation.
mysql> GRANT ALL PRIVILEGES ON *.* TO root@localhost
-> IDENTIFIED BY 'salach01' WITH GRANT OPTION;
ERROR 1047: Unknown command
JoacHim
> -----Ursprüngliche Nachricht-----
> Von: Diego, Emil [SMTP:[EMAIL PROTECTED]]
> Gesendet am: Donnerstag, 7. Februar 2002 22:00
> An: '[EMAIL PROTECTED]'
> Betreff: RE: GRANT command (ERROR 1047)
>
> Try this
>
> GRANT ALL PRIVILEGES ON *.* TO root@localhost
> IDENTIFIED BY 'password'
> WITH GRANT OPTION
>
> Emil
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 07, 2002 4:19 AM
> To: [EMAIL PROTECTED]
> Subject: GRANT command (ERROR 1047)
>
>
> I am using the following versions of mysql on suse linux 7.2:
> frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
> server: version 3.23.47
>
> If I try to use the GRANT command I get
> #mysql -u root mysql
> mysql> GRANT ALL ON *.* TO root@localhost
> -> IDENTIFIED BY 'password' WITH GRANT OPTION;
> ERROR 1047: Unknown command
>
> Any idea? Thanks!
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
