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

[Mike Miller]

I did it, and it said enter password, I just pressed enter and I didn't
get a bad password error, then again nothing happened either (idk what
was supposed to happen), I still get the same error when running ./setup
And im sure is obvious all the linux experience I have is from the last
2 weeks in trying to build a mythtv box.
Not sure what to do now lol


-----Original Message-----
From: Michael J. Sherman [mailto:msherman at dsbox.com] 
Sent: Sunday, July 06, 2003 2:42 PM
To: Mike Miller
Subject: Re: [mythtv-users]Help needed -- cant run setup on Mandrake


No, no, no.  Have you ever set a root password for your MySQL server? 
If not, then there is no root password.  Not the password for your root 
account on your machine, but the root mysql account (they're different).

  By default the root mysql account has a blank password, so you should 
just be able to hit enter at the password prompt.  When mysql said 
"using password yes" that just meant it was using a password, not that 
your password was literally "yes".

Try just typing "mysql -u root -p" and see if you can at least get into 
the MySQL client program.

Also, how must Linux experience do you have, just out of curiosity?

-Mike

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: Michael J. Sherman [mailto:msherman at dsbox.com] 
> Sent: Sunday, July 06, 2003 1:59 PM
> To: miller44 at optonline.net
> Subject: Re: [mythtv-users]Help needed -- cant run setup on Mandrake
> 
> 
>  > I have run the mysql -u root > mc.sql
> 
> Umm, I think you mean
> 
>    mysql -u root -p < mc.sql
> 
> (note the addition of the -p option and the less than sign intead of 
> greater than - you want to redirect the mc.sql INTO the mysql command,

> not the other way around!!!)
> 
> -Mike
> 


-- 
Michael J. Sherman  |  Software Developer  |  Digital Sandbox, Inc.
"There are 10 types of people in the world - those who know binary
and those who don't"