[mythtv-users] can't login in to sql

[the mad doctor kaeding]

Did that before I started complaining, from the file
in the mythtv source tree, as instructed by the manual.

mysql --user=root < database/mc.sql

On Sun, Dec 21, 2008 at 9:13 PM, Owen Townend <owen.townend at gmail.com>wrote:

> 2008/12/22 the mad doctor kaeding <the.mad.doctor.kaeding at gmail.com>:
> > echo 'show databases;' | mysql --user=root --password
> > gives
> > ....
> > mysql
> > mythconverg
> > .....
> >
> > echo 'show tables;' | mysql --user=mythtv --password=mythtv
> > --database=mythconverg
> > gives a blank line
> >
> > creating /etc/mythtv/mysql.txt with the right stuff in it
> > had no effect.
> >
>
> Hey,
>
> 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.
>
> cheers,
> Owen.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20081221/fdba8fdd/attachment.htm