Problem creating root password MySQL in FC6

[Barry Yu]

Steve Searle <steve at stevesearle.com> wrote: Around 07:53am on Sunday, July 29, 2007 (UK time), Barry Yu scrawled:

> I tried your link to your webpage but getting "Server not found", your 
> server is down?

Oops - that was the copy on the local server.  Try this:
http://www.stevesearle.com/tech/centos5.0.svr.html#mysql

Steve

-- 
 
 Play Champions - my free football predictions game at:
  http://www.stevesearle.com/champs/about.html


-- 
fedora-list mailing list
fedora-list at redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
Still can't login as root;

[root at localhost ~]# service mysqld start
    Starting MySQL                            [OK]
[root at localhost ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I've been searching with Google and found that I am not alone in this proble but unfortunately there wasn't any solution that I can find helpful to resolve this issue, seems before I set a password for root user (Create one after the initial installation and before using MySQL) there is one existing already and I don't know what it is. I even yum removed MySQL and then yum groupinstall mysql to make sure a fresh installation of MySQL is being used.

I had tried followings;
[root at localhost ~]# mysqladmin -u root password -p mypassword123
Enter password: 
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
[root at localhost ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root at localhost ~]# mysql -u root -p
Enter password: (I enter blank RETURN key)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)








-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20070729/f8637114/attachment-0001.htm>