<br><br><b><i>Steve Searle <steve@stevesearle.com></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Around 07:53am on Sunday, July 29, 2007 (UK time), Barry Yu scrawled:<br><br>> I tried your link to your webpage but getting "Server not found", your <br>> server is down?<br><br>Oops - that was the copy on the local server. Try this:<br>http://www.stevesearle.com/tech/centos5.0.svr.html#mysql<br><br>Steve<br><br>-- <br> <br> Play Champions - my free football predictions game at:<br> http://www.stevesearle.com/champs/about.html<br><br><br>-- <br>fedora-list mailing list<br>fedora-list@redhat.com<br>To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list<br></blockquote>Still can't login as root;<br><br>[root@localhost ~]# service mysqld start<br> Starting MySQL
[OK]<br>[root@localhost ~]# mysql -u root<br>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)<br><br>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.<br><br>I had tried followings;<br>[root@localhost ~]# mysqladmin -u root password -p mypassword123<br>Enter password: <br>mysqladmin: connect to server at 'localhost' failed<br>error: 'Access denied for user 'root'@'localhost' (using password: YES)'<br>[root@localhost ~]# mysql -u root<br>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)<br>[root@localhost ~]# mysql -u root -p<br>Enter password: (I enter blank RETURN key)<br>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)<br><br><br><br><br><br><br><br><br>