[ale] mysqldump error

[Brian Whigham]

Christopher Fowler wrote:
> I'm trying to use mysqldump from version 5.X of mysql to dump a 4.1.18
> mysql database.
>
> mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need the
> RELOAD privilege for this operation (1227)
>
>
> I'm trying to enabled replication.  Do i need to turn on something in
> the 4.1.8 database?
>
> Chris
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
>   
Have you looked at the GRANT syntax of 5.0?  Are you sure you have the 
RELOAD priv for your particular user?

> The |FILE|, |PROCESS|, |RELOAD|, |REPLICATION CLIENT|, |REPLICATION 
> SLAVE|, |SHOW DATABASES|, |SHUTDOWN|, |SUPER|, and |CREATE USER| 
> privileges are administrative privileges that can only be granted 
> globally (using |ON *.*| syntax).

http://dev.mysql.com/doc/refman/5.0/en/grant.html

bw