[mythtv-users] can't login in to sql
owen.townend at gmail.com
Mon Dec 22 02:13:48 UTC 2008
2008/12/22 the mad doctor kaeding <the.mad.doctor.kaeding at gmail.com>:
> echo 'show databases;' | mysql --user=root --password
> echo 'show tables;' | mysql --user=mythtv --password=mythtv
> gives a blank line
> creating /etc/mythtv/mysql.txt with the right stuff in it
> had no effect.
The blank line from the 'show tables' command shows that the database
exists but is empty.
Your password/credentials all worked fine though which is a good start
though they may not have the right to alter the table.
Try this to double check that the user and database are set up correctly.
(First check that mc.sql exists there, it may be elsewhere depending
on your distro)
`mysql --user=root --password < /usr/share/mythtv/sql/mc.sql`
then try mythtv-setup again.
More information about the mythtv-users