On Tuesday 18 February 2003 15:36, Harald Fuchs wrote: > In article <[EMAIL PROTECTED]>, > John Taylor <[EMAIL PROTECTED]> writes: > > > I get the error: > > ERROR 1227: Access denied. You need the REPLICATION SLAVE privilege for this >operation > > > I've tried setting the grants again, but it doesn't seem to make any difference: > mysql> GRANT REPLICATION SLAVE,RELOAD,SUPER ON *.* TO myuser@myhost IDENTIFIED BY >'mypass' > > mysql> show grants for myuser@myhost; > > > >+----------------------------------------------------------------------------------------+ > > | Grants for myuser@myhost > | > > >+----------------------------------------------------------------------------------------+ > > | GRANT RELOAD ON *.* TO 'myuser'@'myhost' IDENTIFIED BY PASSWORD >'asdadadasdadasas' | > > >+----------------------------------------------------------------------------------------+ > > 1 row in set (0.00 sec) > > > Whats going on here ? > > Perhaps you forgot to run mysql_fix_privilege_tables? >
That was it - thanks. Replication now seems to be running, but the tables are not being updated on the slave. I can see the updates arriving in the relay log, but they don't get added to the database. There are no errors in the log Processlist looks OK to me ... mysql> show full processlist; +----+-------------+-----------+----------+---------+-------+----------------------------------+-----------------------+ | Id | User | Host | db | Command | Time | State | | Info | +----+-------------+-----------+----------+---------+-------+----------------------------------+-----------------------+ | 1 | system user | none | NULL | Connect | 11609 | Reading master update | | NULL | | 2 | system user | none | NULL | Connect | 11609 | Slave: waiting for |binlog update | NULL | | 5 | root | localhost | vpopmail | Query | 0 | NULL | | show full processlist | +----+-------------+-----------+----------+---------+-------+----------------------------------+-----------------------+ 3 rows in set (0.00 sec) and the slave staus looks OK too ... mysql> show slave status; +-----------------------+-------------+-------------+---------------+-----------------+---------------------+--------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File || Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | |Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | |Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +-----------------------+-------------+-------------+---------------+-----------------+---------------------+--------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+ | mymaster | myuser | 3306 | 60 | mysqld.013 || 516424 | loki-relay-bin.003 | 381962 | mysqld.012 | |Yes | Yes | | | 0 | | | 0 | 516424 | 381966 | +-----------------------+-------------+-------------+---------------+-----------------+---------------------+--------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+ 1 row in set (0.00 sec) The permissions on the database directory and files are rwx------ mysql:mysql Is here anything else that I can check for ? I have only taken a snapshot and copied one of the databases so far - could that be the problem ? Thanks JohnT --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
