[mythtv-users] can't login in to sql
the mad doctor kaeding
the.mad.doctor.kaeding at gmail.com
Mon Dec 22 02:21:11 UTC 2008
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.
> 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.
> mythtv-users mailing list
> mythtv-users at mythtv.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users