Re: Unable to grant replication slave/client to class c

2006-07-21 Thread Dominik Klein
Michael M. schrieb: I'm attempting to take a brand new mysql server build on gentoo and set up replication. I'm using GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@"192.168.1.0/255.255.255.0" IDENTIFIED BY 'secret'; I'm not sure i

Unable to grant replication slave/client to class c

2006-07-20 Thread Michael M.
I'm attempting to take a brand new mysql server build on gentoo and set up replication. I'm using GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@"192.168.1.0/255.255.255.0" IDENTIFIED BY 'secret'; I've tried various combinati

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
;@\"localhost\"; +-+ | Grants for [EMAIL PROTECTED] | +-+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION | +-----

Cannot GRANT REPLICATION SLAVE

2004-12-03 Thread Batara Kesuma
ts for [EMAIL PROTECTED] | +-+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION | +---------+ mysql

Re: grant replication slave ...

2004-06-14 Thread Hans-Peter Grimm
[EMAIL PROTECTED] wrote: I am running MySQL 3.23 and want to setup replication. I execute the following command(copied from MySQL document) on the master server: GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com' IDENTIFIED BY 'slavepass'; And it return the

grant replication slave ...

2004-06-14 Thread jschung
I am running MySQL 3.23 and want to setup replication. I execute the following command(copied from MySQL document) on the master server: GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com' IDENTIFIED BY 'slavepass'; And it return the following message: ER

Re: 4.0.9 grant replication slave ... fails.

2003-03-04 Thread Mark Swanson
OK. I solved it. In a last ditch effort I tried the /usr/bin/mysql_fix_privilege_tables script. That fixed it up. Replication seems to be working fine. Cheers. -- Schedule your world with ScheduleWorld.com http://www.ScheduleWorld.com/ Java Web Start: http://www.ScheduleWorld.com/sw/ScheduleWorl

4.0.9 grant replication slave ... fails.

2003-03-04 Thread Mark Swanson
I'm using 4.0.9 and I can not grant replication slave. [EMAIL PROTECTED] root]# rpm -qf /usr/bin/mysql MySQL-client-4.0.9-0 [EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysql mysqld mysqld-max [EMAIL PROTECTED] root]# rpm -qf /usr/sbin/mysqld-max MySQL-Max-4.0.9-0 [EMAIL PROTECTED] root]