[mythtv-users] Installation database problems

[John Doll]

the "host" field in the user table of mysql dictates where a user is allowed
to connect form.

If you want to be able to connect from any machine put a '%' in the host
field for the users that you want to connect as.

When you run a mysql command you can specify on the command line what
user/pass to connect to the DB as. You don't actually have to run the
command AS root.

mysql -U root -P <your pass> .........

-John

> -----Original Message-----
> From: mythtv-users-bounces at snowman.net
> [mailto:mythtv-users-bounces at snowman.net]On Behalf Of Ben Bucksch
> Sent: Wednesday, May 14, 2003 1:34 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] Installation database problems
>
>
> Ray Olszewski wrote:
>
> > For example, Ben's explanation below omits any indication of whether
> > to execute those commands as root, as mythtv, or as someone else.
>
> As root, although any user having administration access within MySQL
> should work.
>
> > I apologize for simply asking someone else to do some work. Plain
> > truth is, I don't understand mysql well enough to do this for the
> > docs. But I think it is badly needed. MythTV users shouldn't have to
> > become mysql experts (or do people disagree with that view?) just to
> > record TV.
>
> I agree. I had to look up the MySQL docs as well, and I don't understand
> MySQL well enough to describe the steps in a 'systematic way'. In fact,
> for example, I can't get access to MySQL from my notebook (different
> subnet, but it should have access) and I don't know why.
>
> Ben
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
>