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

[Kingsley Turner]

Hi-yas,

I had so much trouble after a mythbuntu 12.04->14.04 update I've re-installed.

However I can't seem to get my database restored:

    # mythconverg_restore.pl --drop_database --create_database --directory . 
--filename mythconverg-1317-20141008051044.sql.gz
    ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using 
password: YES)
    ERROR: Cannot write to mysql, stopped at 
/home/kingsley/Bin/mythconverg_restore.pl line 1720, <BACKUP> line 793.

Huh?

It's just using the password out of /home/mythtv/.mythtv/config.xml AFAIK.
(this is the same as the default user .mythtv/config.xml)

any help much appreciated.

ta,
-kt



PS> Verbose log follows:








# mythconverg_restore.pl --drop_database --create_database --directory . 
--filename mythconverg-1317-20141008051044.sql.gz
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using 
password: YES)

ERROR: Cannot write to mysql, stopped at 
/home/kingsley/Bin/mythconverg_restore.pl line 1720, <BACKUP> line 793.
kingsley at mediabox:~$ mythconverg_restore.pl --verbose --drop_database 
--create_database --directory . --filename 
mythconverg-1317-20141008051044.sql.gz

Configuring environment:
   -    username: kingsley
   -        HOME: /home/kingsley
   - MYTHCONFDIR: /home/kingsley/.mythtv

Parsing configuration files:
   - checking: /home/kingsley/.mythtv/config.xml
      parsing: /home/kingsley/.mythtv/config.xml
   - checking: /home/kingsley/.mythtv/backuprc

Applying command-line arguments.

Checking configuration.

Database Information:
          DBHostName: localhost
              DBPort: 3306
          DBUserName: mythtv
          DBPassword: XXX
              DBName: mythconverg
         DBSchemaVer:
   DBBackupDirectory: .
    DBBackupFilename: mythconverg-1317-20141008051044.sql.gz
       drop_database: yes
     create_database: yes

Executables:
        mysql_client: mysql
          uncompress: gzip -d

Miscellaneous:
     partial_restore: no
    restore_xmltvids: no
     change_hostname: no

Checking database.

Preparing initial database.
Dropping database.
Creating database.
Setting database character set.

Found 0 tables in the database.

Backup file is compressed.
  - Uncompressing backup file with IO::Uncompress::Gunzip.

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

Executing command:
'mysql' --defaults-extra-file='/tmp/s4VJCxmsai' --host='localhost' 
--port='3306' --user='mythtv' 'mythconverg'
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using 
password: YES)

ERROR: Cannot write to mysql, stopped at 
/home/kingsley/Bin/mythconverg_restore.pl line 1720, <BACKUP> line 793.