[mythtv-users] MySQL-Password problem - Access denied for user 'mythtv'@'localhost'

Al Bogner mythtv-users at ml061.pinguin.uni.cc
Sun Mar 12 19:29:47 UTC 2006


I use SuSE Linux 10 and tried to install rpms from Olsen.

apt-cache policy mythtv
mythtv:
  Installed: 0.19-19
  Candidate: 0.19-19
  Version Table:
 *** 0.19-19 0
        500 http://folk.uio.no 10.0-olsen/Olsen pkglist
        100 RPM Database

IMHO the installation is broken, so I tried to get it work manually by cloning 
a Debian-mythtv-installation.

Since on the debian-system the mysql-db is used for mythtv only, I did:

mysql -u root -p... < mysqldump40_sid.sql

Afterwards I could watch live-tv and eveything seemed to be ok. But when I try 
"mythfilldatabase --update" I get the errors below.

I had no /etc/mythtv/-directory on the SuSE-system after the installation, so 
I copied this from the debian-system too. Maybe that ist the problem, since 
the PW is stored there and the SuSE-system looks at another place.

ls -1 /etc/mythtv/
mysql.txt
mythweb
mythweb-htaccess.conf
mythweb-settings.php

cat /etc/mythtv/mysql.txt
DBHostName=192.168.1.104
DBUserName=mythtv
DBName=mythconverg
DBPassword=...

One difference between the Debian and the Suse Installation is the 
mysql-version.

apt-cache policy mysql
mysql:
  Installed: 4.1.13-3.2
  Candidate: 4.1.13-3.2
  Version Table:
 *** 4.1.13-3.2 0
        500 ftp://ftp.gwdg.de SuSE/10.0-i386/update pkglist
        100 RPM Database
     4.1.13-3 0
        500 ftp://ftp.gwdg.de SuSE/10.0-i386/base pkglist


With Sid I use:
apt-cache policy mysql-server
mysql-server:
  Installiert:5.0.18-8
  Mögliche Pakete:5.0.18-8
  Versions-Tabelle:
     5.0.18-9 0
        500 ftp://ftp.at.debian.org sid/main Packages
 *** 5.0.18-8 0
        900 ftp://ftp.at.debian.org etch/main Packages
        900 ftp://ftp.freenet.de etch/main Packages
        500 ftp://ftp.freenet.de sid/main Packages
        100 /var/lib/dpkg/status


But the dump was stored with
mysqldump --compatible=mysql40 -u root -p$MYSQLPW --opt --all-databases >  
mysqldump40_sid.sql

mythfilldatabase --update
2006-03-12 20:16:02.747 Using runtime prefix = /usr
2006-03-12 20:16:02.779 New DB connection, total: 1
2006-03-12 20:16:02.786 Unable to connect to database!
2006-03-12 20:16:02.786 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'localhost' (using password: YES)

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-03-12 20:16:02.844 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-03-12 20:16:02.900 Failed to init MythContext, exiting.

Al


More information about the mythtv-users mailing list