[mythtv-users] newbie HELP: mysql.

[Greg Woods]

On Wed, 2006-03-15 at 12:36 -0700, clemens at dwf.com wrote:

> For a Redhat/Fedora System the instructions say to use
> 
>     mysql -u root < mc.sql

Should be:

     mysql -u root -p < mc.sql

which would give the "Enter password:" prompt.

> 
> 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.

Yes, that gives the password on the command line instead of prompting
for it. That should work.

The mc.sql file is what grants privileges to access the database. It
does assume that you are running as user "mythtv" and running on the
same host where the database is located; are you? Also make sure that
the database is configured correctly in the mythtv-setup database
screen. The user/password here must match the one on the mc.sql file.

It's also possible that you are running a different version of MySQL
than what Myth is expecting. That can cause a great deal of headaches,
beginning with the possibility that the format of the command to grant
privileges has changed.

--Greg