[mythtv-users] newbie HELP: mysql.

[Ryan Hadley]

I'd check to see if it's configured with the right permissions... mine 
(gentoo package of 0.19) stores the mysql info in:

/etc/mythtv/.mythtv/mysql.txt

As for whether or not the database was created, login with the client:

mysql (enter your auth stuff here... -u root -p, -u mythtv -p, whatever 
user/pass options you need) -e "show databases;"

on my setup I run:

# mysql -u root -p -e "show databases;"
Enter password:
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| mythconverg        |
| test               |
+--------------------+
#

And you can see that the mythconverg db really does exist.

-Ryan

clemens at dwf.com wrote:
> OK, I played with MythTV about a year ago, but am starting over again on a new 
> machine.
>
> Ive got as far as setting up the data base.
>
> For a Redhat/Fedora System the instructions say to use
>
>     mysql -u root < mc.sql
>
> This gave errors for me, but
>
>     mysql --password=<my mythtv password> < mc.sql
>
> did work, so I will assume that I have done whatever this is suposed to do.
>
> HOWEVER, when I get a few pages further, and try
>
>     mythtv-setup
>
> I get rolling errors that say:
>
>     Database not open while trying to save setting: Language
>     Unable to connect to database.
>
> Now mysqld is running on this machine, there are no firewall protections 
> against ports,
> so ANY IDEAS WHAT I AM DOING WRONG?
>
>