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
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
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
] |
+-+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+-+
mysql grant replication slave on *.* to backup@192.168.1.32
\;
+-+
| Grants for [EMAIL PROTECTED] |
+-+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+-+
mysql grant replication slave
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
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
[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
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
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:
12 matches
Mail list logo