[mythtv-users] Trouble logging in to mysql

[Cyber Source]

you need to set a password for root, you can do this like so
"mysqladmin -uroot password whatever" without the quotes and with 
"whatever" being the password of your choice. If it already has a 
password it would be "mysqladmin -uroot -pwhatever password whatever" 
with -pwhatever being the old password, minus the "p" and the quotes.

Bruce Markey wrote:

> Josh Evnin wrote:
>
>> Hey, i'm having trouble logging into mysql at all.  I'm new at this,
>> and it's getting a bit frustrating!  Here's what I see:
>>
>> [mythtv at localhost sbin]$ mysql -u root -p
>> Enter password:
>> ERROR 1045: Access denied for user:'root at localhost'(Using password: YES)
>>
>> If I leave off the -p, I get a similar error:
>>
>> [mythtv at localhost sbin]$ mysql -u root
>> ERROR 1045: Accesas denied for user::'root at localhost'(Using password: 
>> NO)
>>
>> I've tryed doing this after I 'su', and it still doesn't work.  I also
>> get the same errors when I log in to root.  I'm sure the password I
>> type is correct, but it starts with ')', which may be causing a
>> problem...
>>
>> Any suggestions?  Thanks!  I really wanna get MythTV up and
>> running...i'm excited!
>
>
> http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
>
> --  bjm
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>

-- 

                         115 Richfield Road
               Williamsville, New York 14221
                            716-553-8525