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

[Kingsley Turner]

On 08/10/14 21:20, Michael T. Dean wrote:
> 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
>


Ah yes, of course!

I must have accidentally restored the .my.cnf when copying on some other stuff.

cheers Mike,

-kt