[mythtv-users] MySQL mythconverg permissions.... i give up.

[Ed Gradek]

Thanks for the quick replies!

In my eagerness to get this email out, I think I might have copied/pasted 
some incorrect info.  Sorry about that!

Both systems are running FC4, Kernel - 2.6.15-1.1833_FC4

mysql only has one account right now, and that's root.

to connecto to mysql locally, i do need to enter in the password (the 
original post below was copied and pasted from the mythtv HOW-TO section).  
Command I have run on mysql on the backend system is:

-=-=-=-=-=-=-=-=-=-
$ mysql -u root -p mythconverg
Password: *************
mysql> grant all on mythconverg.* to root@"%" identified by "frontend";
mysql> flush privileges;
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

i've tried every way i can think of to modify the "grant all" command 
including
grant all on mythconverg.* to "%"@"%" identified by "%";

Additionally, when i run "mythfrontend" on the frontend system, the errors 
scroll by regarding not being able to connect to the database, and it 
launches the database configuration menus (which is expected).  From the 
"Database Configuration 1/2" page I have:

Host name:  172.30.2.50  (i've also tried using the host name, backend, as 
well as backend.domain.com)

Database:  mythconverg

User:  root

Password:   (the correct root password for mysql, tested over and over and 
over again)

Database type:  MySQL

The "Database Configuration 2/2" page is left as defaults, no options 
checked for "custom identifier" or "wake-on-LAN"

Ideas?

:\
>From: Brad DerManouelian <myth at dermanouelian.com>
>Reply-To: Discussion about mythtv <mythtv-users at mythtv.org>
>To: Discussion about mythtv <mythtv-users at mythtv.org>
>Subject: Re: [mythtv-users] MySQL mythconverg permissions.... i give up.
>Date: Sat, 18 Mar 2006 15:13:12 -0500
>
>On Mar 18, 2006, at 3:00 PM, Ed Gradek wrote:
>
> > Hi All,
> >
> > I've spent the last few days trying to figure this out on my own,
> > searching
> > the net, asking friends, and I'm all out of options.
> >
> > Access denied for user 'root'@'frontend.domain.com' (using
> > password: YES)
>
>You're trying to connect to mysql as root at frontend.domain.com instead
>of mythtv at backend.domain.com. You need to change this in the frontend
>setup.
>
> >
> > I've tried all combinations of the permissions section from the
> > myth-howto....:
> > $ mysql -u root mythconverg
> > mysql> grant all on mythconverg.* to mythtv@"%" identified by
> > "mythtv";
> > mysql> flush privileges;
>
>As an aside.. according to your mysql command here, you have no
>password for mysql's root account. You should probably protect your
>db with a password... just in case.
>
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users