Problem creating root password MySQL in FC6

[John Pierce]

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.

-- 
John
Registered Linux User 263680, get counted at
http://counter.li.org