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
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
--
MySQL
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
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;
+-+
| Grants for [EMAIL PROTECTED]
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\;
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