[mythtv-users] Setting up mythtv password did no good

[Robert McNamara]

On Tue, Jan 13, 2009 at 2:31 PM, Igor Chudov <igor at chudov.com> wrote:
> As mentioned in my previous post, resetting root password to blank,
> and granting all privileges on *.* to mythtv at localhost, identified by
> mythtv, did not do squat.
>
> Mythtv-setup is very secretive about what credentials it uses to
> access mysql, really secretive about what it is trying to do, fails to
> create database mythconverg, does not really say so either, and then
> says "could not connect to database mythconverg". (because it is not
> there, duh).
>
> So I am basically reliving al the same BS that I went through the
> first time.
>
> i
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

Why did this bear creating a new thread?  What was wrong with the old one?

Mythtv-setup will use the DB password, DB username, and DB host of the
mysql.txt or config.xml in the ~/.mythtv directory of the user running
it.  Failing that, it will try to find the same files in /etc/mythtv.
If all of the above files have the correct DB login information, it
will connect.  Do keep in mind that mysql considers "localhost" and
"127.0.0.1" and "192.168.x.x", even though they might be all the same
hosts, as different entities.  So if you are able to log in to mysql
with:

mysql -u mythtv -p -h 127.0.0.1 mythconverg

but not

mysql -u mythtv -p -h localhost mythconverg

Then all the files should have dbhost set to 127.0.0.1.

*All* of the above information is in the documentation.  Do not follow
walkthroughs on blogs (which are woefully out of date).  All of that
aside, you are coming across as very disrespectful.  Can you please
tone down the inflammatory language?  We are all here because we
*like* MythTV, and you do nothing to help your case by being rude
about it.

Robert