Hello.


Looks strange. Have you upgraded from 3.xx to 4.xx? If so, then may be you 
forgot to run mysql_fix_privilege_tables script. Your mysql client

shows 4.0.21 version, but check the exact version: 



  select version();



Send us your my.cnf file, output of show variables. Can you reproduce such

error on latest release?





Batara Kesuma <[EMAIL PROTECTED]> wrote:

>> I can grant another previleges, but not replication slave and

>> replication clients. How do I fix this? Thank you in advance.

> 

> I checked my mysql.user table, and I just found out that it didn't have 

> Repl_slave_priv and Repl_client_priv columns. How is this possible?

> 

> mysql> select * from mysql.user\G

> *************************** 14. row ***************************

>           Host: 192.168.1.32

>           User: backup1

>       Password: 2cd93c3e746362cf

>    Select_priv: N

>    Insert_priv: N

>    Update_priv: N

>    Delete_priv: N

>    Create_priv: N

>      Drop_priv: N

>    Reload_priv: N

>  Shutdown_priv: N

>   Process_priv: N

>      File_priv: N

>     Grant_priv: N

> References_priv: N

>     Index_priv: N

>     Alter_priv: N

> 

> 

> That is all the colums in mysql.user. Please help, and thank you in

> advance.

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [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]

Reply via email to