[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