<!doctype html public "-//W3C//DTD W3 HTML//EN">
<html><head><style type="text/css"><!--
blockquote, dl, ul, ol, li { margin-top: 0 ; margin-bottom: 0 }
--></style><title>Re: Problem creating root password MySQL in
FC6</title></head><body>
<div>At 9:19 AM -0700 7/29/07, Barry Yu wrote:</div>
<blockquote type="cite" cite><i><b>Steve Searle
<steve@stevesearle.com></b></i> wrote:<br>
<blockquote>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<span
></span>.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.h<span
></span>tml<br>
<br>
<br>
--<br>
fedora-list mailing list<br>
fedora-list@redhat.com<br>
To unsubscribe: https://www.redhat.com/mailman/listinfo/<span
></span>fedora-list<br>
</blockquote>
</blockquote>
<blockquote type="cite" cite>Still can't login as root;<br>
<br>
[root@localhost ~]# service mysqld start<br>
Starting
MySQL <span
></span
> <span
></span> [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)</blockquote>
<blockquote type="cite" cite>ERROR 1045 (28000): Access denied for
user 'root'@'localhost' (using password: NO)</blockquote>
<div><br></div>
<div>To reset the root password without knowing it, start mysqld
without using the grant tables:</div>
<div><br>
Per Resetting a forgotten MySQL root password:<br>
http://www.debian-administration.org/art<span
></span>icles/442<br>
[]# service mysqld
stop # mysqld must be
stopped</div>
<div> []# /usr/bin/mysqld_safe --skip-grant-tables
&</div>
<div> []# mysql -uroot mysql</div>
<div> mysql> update user set
Password=PASSWORD('new-pw') WHERE User='root';</div>
<div> mysql> quit</div>
<div><br></div>
<div>Here my instructions are a bit loopy. Probably the PID to
kill is the one reported above.</div>
<div><br></div>
<div> []# ps -ef | grep mysql<br>
[]# kill [the second PID]</div>
<div> []#
fg # so the
shell stops too</div>
<div> []# service mysqld start</div>
<div>-- <br>
_________________________________________<span
></span>___________________________<br>
TonyN.:' <span
></span
> <span
></span>
<mailto:tonynelson@georgeanelson.com><br>
' <span
></span
> <span
></span>
<http://www.georgeanelson.com/></div>
</body>
</html>