[mythtv-users] New install, can't restore database with mythconverg_restore.pl - mysql access denied

[Michael T. Dean]

On 10/08/2014 05:10 AM, Kingsley Turner wrote:
> The restore script eventually executes:
>
>     'mysql' --defaults-extra-file='/tmp/bvNAj5Df0K' --host='localhost' 
> --port='3306' --user='mythtv' 'mythconverg'
>
> I modified the restore script so that it no longer nuked it's tmpfile 
> on exit.
> I checked the content of this, and it indeed has the correct password.
>
> So I again modified the restore script so instead of adding 
> --defaults-extra-file='/tmp/bvNAj5Df0K' it added --password=2xCsPIsh 
> and it worked.
>
> I can't explain why mysql does not work with the defaults file, but 
> I'm happy to have my database restored.

Because you have a MySQL options file that gives a different (and 
incorrect) password, exactly as described in the output of the restore 
script:

> Attempting to use supplied password for mysql command-line client.
> Any [client] or [mysql] password specified in the MySQL options file will
> take precedence.

http://dev.mysql.com/doc/refman/5.0/en/option-files.html

Mike