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
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
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
> 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
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\";
+--