Bug #354 Replication doco says grant perms to "%" which gives perms error

• Submitted: 30 Apr 2003 22:26
• Modified: 2 May 2003 8:56
• Reporter: Zebee Johnstone
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 4.0.12
• OS: Linux (Linux)
• CPU Architecture: Any

[30 Apr 2003 22:26] Zebee Johnstone

Description:
Documenation says to grant the replication user FILE privs using
GRANT FILE ON . TO repl@"%" IDENTIFIED BY 'password'

This gives permission errors, saying 'Access denied for user: 'repl@192.168.1.200' (Using password: YES)'

If I delete the repl user and replace using
GRANT FILE ON . TO repl@192.168.1.200 IDENTIFIED BY 'password'
then replication works.

How to repeat:

[2 May 2003 8:56] Guilhem Bichot

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Hi,

I could reproduce such permission problems in 3.23,
but not in 4.0. This is apparently a bug which we have already fixed in 4.0 :
 grant replication slave on *.* to repl@"%";
worked for me.