Problem creating root password MySQL in FC6

[Barry Yu]

John Pierce wrote:
> Hands down the fastest way to set a root password for a newly
> initialized mysql db:
>
> $ mysql -u root
> set password for root at localhost = password('CHANGEME');
> flush privileges;
> quit;
>
> Now, log on as:
>
> mysql -u root -p
>
> And you will be prompted for the password that you just set.
>
>   
My thanks to all that had been helping
Barry