<p>Didnt you say its a new database? Do you think mysql comes with myth user by default?<br>
</p>
<div class="gmail_quote">On May 21, 2012 6:06 AM, "Damian" <<a href="mailto:myth@surr.co.uk">myth@surr.co.uk</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 20/05/2012 20:19, <a href="mailto:mythtv@hambone.e4ward.com" target="_blank">mythtv@hambone.e4ward.com</a> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On Sun, May 20, 2012 at 2:55 PM, Damian <<a href="mailto:myth@surr.co.uk" target="_blank">myth@surr.co.uk</a><br>
<mailto:<a href="mailto:myth@surr.co.uk" target="_blank">myth@surr.co.uk</a>>> wrote:<br>
<br>
<br>
I'd really appreciate help on the mysql root password issue<br>
Damian,<br>
<br>
<br>
Here's a link on resetting the mysql root password. It happened to me a<br>
couple of years ago.<br>
<br>
<a href="http://www.howtoforge.com/reset-forgotten-mysql-root-password" target="_blank">http://www.howtoforge.com/<u></u>reset-forgotten-mysql-root-<u></u>password</a><br>
<br>
Hope that helps!<br>
Jerry<br>
</blockquote>
<br>
Thanks for that Jerry,<br>
<br>
In the mean time, I found these instructions: <a href="http://ubuntu.flowconsult.at/en/mysql-set-change-reset-root-password/" target="_blank">http://ubuntu.flowconsult.at/<u></u>en/mysql-set-change-reset-<u></u>root-password/</a><br>
and set a new password for mysql.<br>
<br>
I then returned to the guide I followed to backup my database: <a href="http://ubuntuforums.org/showpost.php?p=2298778&postcount=4" target="_blank">http://ubuntuforums.org/<u></u>showpost.php?p=2298778&<u></u>postcount=4</a><br>
<br>
and went to the restore section.<br>
<br>
Here's where I got to ...<br>
<br>
damian@mythbox:/storage/zzz-<u></u>mythbak-manual$ mysql -u root -p<br>
Enter password:<br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 822<br>
Server version: 5.5.22-0ubuntu1 (Ubuntu)<br>
<br>
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.<br>
<br>
Oracle is a registered trademark of Oracle Corporation and/or its<br>
affiliates. Other names may be trademarks of their respective<br>
owners.<br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br>
<br>
mysql> DROP DATABASE mythconverg;<br>
Query OK, 104 rows affected (0.10 sec)<br>
<br>
mysql> create database mythconverg;<br>
Query OK, 1 row affected (0.00 sec)<br>
<br>
mysql> exit<br>
Bye<br>
damian@mythbox:/storage/zzz-<u></u>mythbak-manual$ ls<br>
mythtv_backup.sql<br>
damian@mythbox:/storage/zzz-<u></u>mythbak-manual$ mysql -u mythtv -p mythconverg <mythtv_backup.sql<br>
Enter password:<br>
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)<br>
damian@mythbox:/storage/zzz-<u></u>mythbak-manual$<br>
<br>
What went wrong there, and why?<br>
<br>
Thanks<br>
Damian<br>
______________________________<u></u>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/<u></u>listinfo/mythtv-users</a><br>
</blockquote></div>