[mythtv-users] newbie HELP: mysql.
greg at gregandeva.net
Wed Mar 15 20:20:04 UTC 2006
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
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.
More information about the mythtv-users