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 if this is correct syntax. Use the specific IP

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 combinations of removing the quotes, tried not using a password

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

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 -- MySQL

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

Cannot GRANT REPLICATION SLAVE

2004-12-03 Thread Batara Kesuma
] | +-+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION | +-+ mysql grant replication slave on *.* to backup@192.168.1.32

RE: Cannot GRANT REPLICATION SLAVE

2004-12-03 Thread olivier . maurice
\; +-+ | Grants for [EMAIL PROTECTED] | +-+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION | +-+ mysql grant replication slave

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

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: ERROR 1064: You have an error

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 following message: ERROR 1064

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]# rpm

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: