List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:March 24 2004 10:23am
Subject:Re: Please help with this: ERROR 1047: Unknown command
View as plain text  
"Hiep Ho" <hiep@stripped> 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
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




Thread
Please help with this: ERROR 1047: Unknown commandHiep Ho24 Mar
  • Re: Please help with this: ERROR 1047: Unknown commandVictoria Reznichenko24 Mar