<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I've just installed mythtv using the deb
packages,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>when it installs the mythtv-database i get the
following error,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><EM>Setting up mythtv-database (0.11-1)
...<BR>Database 'mythconverg' on host 'localhost' already exists, skipping
database initialization<BR>Failed to execute SQL: GRANT ALL PRIVILEGES ON
mythconverg.* TO </EM><A
href="mailto:mythtv@localhost"><EM>mythtv@localhost</EM></A><EM> IDENTIFIED BY
'r:p<Ad\nYou have an error in your SQL syntax near ''r:p<Ad' at line 1 at
-e line 8, <> line 1.<BR>dpkg: error processing mythtv-database
(--configure):<BR>subprocess post-installation script returned error exit status
255</EM></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>although the DB is already created in the above,
the same error is given after a purge </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>im pretty sure its a problem with my passwords, so
i</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> changed the
</FONT></DIV>
<DIV><FONT face=Arial size=2>
mythtv users password to A</FONT></DIV>
<DIV><FONT face=Arial size=2>
mythtv mysql user password to A</FONT></DIV>
<DIV><FONT face=Arial size=2>
changed /etc/mythtv/mysql.txt > DBpasswd=A</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>still getting an access error when i try and
mythtv-setup</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><EM>Unable to connect to database!<BR>Driver error
was [1/-1]:<BR>QMYSQL3: Unable to connect<BR>Database error was:<BR>Access
denied for user: </EM><A
href="mailto:'mythtv@localhost'"><EM>'mythtv@localhost'</EM></A><EM> (Using
password: YES)</EM></FONT></DIV>
<DIV><EM></EM> </DIV>
<DIV><FONT face=Arial size=2><EM>Unable to open database:<BR>Driver error
was:<BR>QMYSQL3: Unable to connect<BR>Database error was:<BR>Access denied for
user: </EM><A
href="mailto:'mythtv@localhost'"><EM>'mythtv@localhost'</EM></A><EM> (Using
password: YES)</EM> </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Wondering if anyone has had similar
problems or has any idas on how to fix it</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>thanks</FONT></DIV></BODY></HTML>