Re: Please help with this: ERROR 1047: Unknown command

2004-03-24 Thread Victoria Reznichenko 
Hiep Ho [EMAIL PROTECTED] wrote:
 i have problem adding user to mysql. I can create a database and there is no
 problem however I got this ERROR 1047: Unknown command when I tried to add
 new user. I don't think I have this problem before. 

 I run this command 

  
 GRANT ALL ON *.* TO usename IDENTIFIED BY 'password' ;
   

 All I got is this ERROR 1047: Unknown command

Execute FLUSH PRIVILEGES and then GRANT command.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Please help with this: ERROR 1047: Unknown command

2004-03-23 Thread Hiep Ho 
Hello

 

Any help would be appreciated.

 

i have problem adding user to mysql. I can create a database and there is no
problem however I got this ERROR 1047: Unknown command when I tried to add
new user. I don't think I have this problem before. 

 

I run this command 

 

GRANT ALL ON *.* TO usename IDENTIFIED BY 'password' ;

 

All I got is this ERROR 1047: Unknown command

 

Thanks,

 

Hiep