Hi
Problem solved.
After adding select permission (now file+select) to the replication user the command
LOAD TABLE x FROM MASTER
works perfectly.
The only question is, why does this command need SELECT permission, whilst the rest
of replication does not ?
Simon
On Tuesday 29 May 2001 10:06, you wrote:
> Hi
>
> Before enabling replication between two live machines, I've been doing some
> tests in the office between two similar machines.
>
> Everything appears to work well, as expected, except the command
>
> LOAD TABLE x FROM MASTER;
>
> This records an error on the screen
>
> ERROR 1188: Error From master: 'Access denied for user : ' ....
>
> and in mysql.err
>
> 010529 092358 fetch_nx_table: failed on create table
>
> Does anyone have an idea what might be causing this error ?
>
> Thanx
>
> Simon
--
Simon Windsor
CricInfo http://www.cricinfo.com/
Tel: +44 (0) 1249 700744
Fax: +44 (0) 1249 700725
Email: mailto:[EMAIL PROTECTED]
This email message is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please contact the
sender by reply email and destroy all copies of the original message. Thank you for
your
cooperation and assistance.
---------------------------------------------------------------------
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
