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 this possible?
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
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.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]