Re: Cannot GRANT REPLICATION SLAVE

2004-12-06 Thread Gleb Paharenko
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 reprodu

Re: Cannot GRANT REPLICATION SLAVE

2004-12-05 Thread Batara Kesuma
Hi Paul, > Generally this happens when you upgrade to a newer version of MySQL > but don't upgrade the grant tables. See bullet 4 on this page: > > http://dev.mysql.com/doc/mysql/en/Upgrade.html Arghh OK!!! Thank you very much. It is ok after I run mysql_fix_previlege_table. --bk -- MySQ

Re: Cannot GRANT REPLICATION SLAVE

2004-12-04 Thread Paul DuBois
At 15:07 +0900 12/4/04, Batara Kesuma 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 t

Re: Cannot GRANT REPLICATION SLAVE

2004-12-03 Thread Batara Kesuma
> 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.u

RE: Cannot GRANT REPLICATION SLAVE

2004-12-03 Thread olivier . maurice
I had the same stuff going on for 4.0.7g on windows. Olivier Hi, I have this weird things happens. kaspia:/var/lib/mysql# mysql --version mysql Ver 12.22 Distrib 4.0.21, for pc-linux-gnu (i386) mysql> show grants for \"root\"@\"localhost\"; +--