[mythtv-users] New install, can't restore database with mythconverg_restore.pl - mysql access denied
Kingsley Turner
krt at krt.com.au
Wed Oct 8 05:42:37 UTC 2014
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.
More information about the mythtv-users
mailing list