Re: Problem creating root password MySQL in FC6

[Tony Nelson <tonynelson@xxxxxxxxxxxxxxxxx>]

Title: Re: Problem creating root password MySQL in FC6

At 9:19 AM -0700 7/29/07, Barry Yu wrote:

> Steve Searle
> <steve@xxxxxxxxxxxxxxx> 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@xxxxxxxxxx
> > To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
> Still can't login as root;
>
> [root@localhost ~]# service mysqld start
>     Starting
> MySQL                          [OK]
> [root@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@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@localhost ~]# mysql -u root
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
> [root@localhost ~]# mysql -u root -p
> Enter password: (I enter blank RETURN key)
> ERROR 1045 (28000): Access denied for
> user 'root'@'localhost' (using password: NO)

To reset the root password without knowing it, start mysqld without using the grant tables:

    Per Resetting a forgotten MySQL root password:
        http://www.debian-administration.org/articles/442
    []# service mysqld stop         # mysqld must be stopped

    []# /usr/bin/mysqld_safe --skip-grant-tables &

    []# mysql -uroot mysql

    mysql> update user set Password=PASSWORD('new-pw') WHERE User='root';

    mysql> quit

Here my instructions are a bit loopy.  Probably the PID to kill is the one reported above.

    []# ps -ef | grep mysql
    []# kill [the second PID]

    []# fg          # so the shell stops too

    []# service mysqld start

--
____________________________________________________________________
TonyN.:'                       <mailto:tonynelson@xxxxxxxxxxxxxxxxx>
      '                              <http://www.georgeanelson.com/>

-- 
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list