<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 08/10/14 09:59, Kingsley Turner
wrote:<br>
</div>
<blockquote cite="mid:5434FCFE.9060801@krt.com.au" type="cite">On
08/10/14 18:09, Mark Perkins wrote:
<br>
<blockquote type="cite" style="font-size: small; color: #000000;">
<br>
<blockquote type="cite" style="font-size: small; color:
#000000;">On 8 Oct 2014, at 4:13 pm, "Kingsley Turner" <a
moz-do-not-send="true" class="moz-txt-link-rfc2396E"
href="mailto:krt@krt.com.au"><krt@krt.com.au></a>
wrote:
<br>
<br>
Hi-yas,
<br>
<br>
I had so much trouble after a mythbuntu 12.04->14.04 update
I've re-installed.
<br>
<br>
However I can't seem to get my database restored:
<br>
<br>
# mythconverg_restore.pl --drop_database --create_database
--directory . --filename
mythconverg-1317-20141008051044.sql.gz
<br>
ERROR 1045 (28000): Access denied for user
'mythtv'@'localhost' (using password: YES)
<br>
ERROR: Cannot write to mysql, stopped at
/home/kingsley/Bin/mythconverg_restore.pl line 1720,
<BACKUP> line 793.
<br>
<br>
Huh?
<br>
<br>
It's just using the password out of <i class="moz-txt-slash"><span
class="moz-txt-tag">/</span>home/mythtv<span
class="moz-txt-tag">/</span></i>.mythtv/config.xml AFAIK.
<br>
(this is the same as the default user .mythtv/config.xml)
<br>
</blockquote>
The verbose log says <i class="moz-txt-slash"><span
class="moz-txt-tag">/</span>home/kingsley<span
class="moz-txt-tag">/</span></i>.mythtv/config.xml
<br>
<br>
</blockquote>
<br>
Yeah, but the <Database> entry is the same in each ~
<br>
<br>
<Database>
<br>
<PingHost>1</PingHost>
<br>
<Host>localhost</Host>
<br>
<UserName>mythtv</UserName>
<br>
<Password>2xCsPIsh</Password>
<br>
<DatabaseName>mythconverg</DatabaseName>
<br>
<Port>3306</Port>
<br>
</Database>
<br>
</blockquote>
Can you connect to mysql?<br>
<br>
mysql -umythtv -p2xCsPIsh<br>
<br>
<pre class="moz-signature" cols="72">--
'ooroo
Stinga...(:)-)
---------------------------------------------------
Email: <a class="moz-txt-link-abbreviated" href="mailto:stinga+mythtv@wolf-rock.com">stinga+mythtv@wolf-rock.com</a> o
You need only two tools. o /////
A hammer and duct tape. If it /@ `\ /) ~
doesn't move and it should use > (O) X< ~ Fish!!
the hammer. If it moves and `\___/' \) ~
shouldn't, use the tape. \\\
---------------------------------------------------</pre>
</body>
</html>