Re: [Cooker] mysql default password

[Frank Griffin]

John Keller wrote:
> Austin Acton wrote:
>   
>> Does mysql suddenly ship with a default password?  It never did before.
>>
>> [austin@blackbox ~]$
>> cat /usr/share/doc/mythtv-backend/README.install.urpmi 
>> You can import the initial database by running:
>> mysql -u root -p < /usr/share/mythtv/initialdb/mc.sql
>> (you can omit -p if you do not have the password set)
>>
>> [austin@blackbox ~]$ mysql -u root < /usr/share/mythtv/initialdb/mc.sql 
>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>> password: NO)
>>
>> Austin
>>     
>
> Try:
>   mysql -h 127.0.0.1 -u root < /usr/share/mythtv/initialdb/mc.sql
>
> That's what I usually do instead of trying to figure out the real cause
> config when I'm working on one one of my shared web host accounts.
>
> Though knowing why mysql doesn't "like" localhost would be better... :-)
>
> - John
>   

It could be, as you suggest, that mysql is failing to resolve localhost
to 127.0.0.1, but it could also be that the failure is caused by leaving
off the "-p", which implies that no password has been set for the "root"
ID.  If one has been set, you'd get the same failure.