First, this:
mysql> grant all on confluence_2_6_0 to dmitsuper@’%’ identified by ‘xxx’;
…
[alwold@bug ~]$ gunzip -c confluence_2_3_0.dump.gz | mysql -u dmitsuper -p confluence_2_6_0
Enter password:
ERROR 1044 (42000): Access denied for user ‘dmitsuper’@’%’ to database ‘confluence_2_6_0’
Second, when I go to fix it (change confluence_2_6_0 to confluence_2_6_0.*), I can use the history in the mysql client to recall the grant line containing the password (so the password is stored in a file somewhere).
Al's Blog 