[mythtv-users] Orphaned files

[Mitch Gore]

On 6/14/07, David Watkins <watkinshome at gmail.com> wrote:
>
> > Well i figured out how to drop the password.  but now i get this
> error...
> >
> > [root at mythtv contrib]# perl myth.find_orphans.pl
> > DBI
> > connect('database=mythconverg:host=mythtv','mythtv',...)
> > failed: Unknown MySQL server host 'mythtv' (1) at myth.find_orphans.plline
> > 99
> > Cannot connect to database mythconverg on host mythtv:
> > [root at mythtv contrib]#
> >
>
> Looks like you dropped a more than just the password.
>
> You could have a look here
>
> http://www.mythtv.org/docs/mythtv-HOWTO-6.html
>
> at the bit about the 'grant all' command.
> _______________________________________________



ok, i redid the passwords and everything but still it doesnt work...


mysql> UPDATE user SET Password="" WHERE user='mythtv';
Query OK, 2 rows affected (0.05 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> select host, user, password from user;
+-------------+--------+------------------+
| host        | user   | password         |
+-------------+--------+------------------+
| localhost   | root   | 43e881156edcc165 |
| Mitchell_MC | root   | 43e881156edcc165 |
| localhost   | mythtv |                  |
| %           | mythtv |                  |
+-------------+--------+------------------+
4 rows in set (0.00 sec)

mysql> exit
Bye
[root at mythtv contrib]# perl myth.find_or*
DBI connect('database=mythconverg:host=mythtv','mythtv',...) failed: Unknown
MySQL server host 'mythtv' (1) at myth.find_orphans.pl line 99
Cannot connect to database mythconverg on host mythtv:
[root at mythtv contrib]#

The password is definately not there but i still get the same error.  Does
this script for sure with with atrpms-bleeding .21?



Mitchell
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070614/0c07e766/attachment.htm