[mythtv-users]Help needed -- cant run setup on Mandrake 9.1, getting qt-MySQL error

[Adam Biskobing]

Have you changed the password for the mysql user: root?  If you haven't 
then you do not need the -p.  That switch will cause mysql to prompt you 
for a password.  If running mysql -uroot < mc.sql does not return any 
errors, then it is probably working.

To do a quick check do the following:

mysql -uroot mythconverg
show tables\g

This should print out a list of tables such as settings, recorded, and 
other such myth tv necessary database tables.  If you are seeing those, 
then most likely the mc.sql script was run successfully.


On Sun, 6 Jul 2003, Mike Miller wrote:

> I did mean it the other way around, however I did not run it w/ -p, the
> intallation how to says 
> Mandrake 9.0 and Red Hat Linux
> 
> $ mysql -u root < mc.sql
> 
> I extracted that file from the tar, tried again, mysql -u root -p <
> mc.sql and it said enter password, so I typed in my root pass and then
> it said ERROR 1045: Access denied for user: 'root at localhost' (Using
> password: YES) Im rather confused Would changing my root password to YES
> solve this b/c if so ill just do that its not a big deal to me. Thanks
> again
> 
> -----Original Message-----
> From: mythtv-users-bounces at snowman.net
> [mailto:mythtv-users-bounces at snowman.net] On Behalf Of Igor Izyumin
> Sent: Sunday, July 06, 2003 12:24 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users]Help needed -- cant run setup on Mandrake
> 9.1,getting qt-MySQL error
> 
> John Madill wrote:
> 
> >
> > On Sunday, July 6, 2003, at 01:30  AM, Mike Miller wrote:
> >
> >> I have run the mysql -u root > mc.sql
> >
> >
> > Try: mysql -u root -p > mc.sql
> >
> > Should prompt for the password.
> 
> The problem here is that the '>' is going the wrong way.  Thus, the file
> 
> might already be erased.  The proper command is mysql -u root -p < 
> mc.sql.  Restore the file from the archive though.
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
> 
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at snowman.net
> http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users
>