Re: lost mysql root password
On Friday 03 March 2006 02:20 pm, Matt Price wrote:
> Thanks everyone for your help, see below for more:
>
> On 3/3/06, anoop aryal <aaryal@foresightint.com> wrote:
> > On Friday 03 March 2006 09:49 am, Matt Price wrote:
> > > Hi folks,
> > >
> > > a while ago I switched over to mysql-5.0, then forgot about it
> > > entirely. Now I'm back to configuring some programs that use mysql,
> > > and... I can't seem to login as root or any other user.
> >
> > if you installed using apt, you should have a file
> > called /etc/mysql/debian.cnf . you should be able to use that username
> > and password to log in and reset your password.
>
> this seemed the simplest of the options presented to me, and
> fortunately, voila! it owrked. I logged in, and had to use GRSNT
> statements to reset permissions:
>
> mysql> grant all privileges on *.* to 'root'@'localhost' identified by
> 'apassword' with grant option;
>
> that worked fine. THen I was looking around and I notice that the
> user password seemed to have some dublicate rows in it:
> +--------------------------------------------------------------+-----------
>-------+-------------------------------------------+
>
> | host | User
> |
> | Password |
>
> +--------------------------------------------------------------+-----------
>-------+-------------------------------------------+
>
> | localhost | root
> |
> | hast 1
> |
> | anarres | root
> |
> | hash 1
> |
> | localhost | root
> |
> | hash 2
> |
> | % | root
> |
> | hash 2
>
> +--------------------------------------------------------------+-----------
>-------+-------------------------------------------+
>
> [passwords are of course hidden in the above]
> hmm, that's odd I thought. what to do? It got odder when I tried:
>
> select * from user where User='root';
>
> then only the second set of records showed up. on the other hand,
>
> mysql> select User from user where User LIKE 'root%';
do:
select hex(User) from user where User LIKE 'root%';
that should give you the hex values of the characters that are there.
>
> have all four. I guess there must be some white space in the username
> somewhere. Is there an easy way to identify the precise value of a
> mysql field (e.g. by dumping to a CSV file)? I'd like to try to figure
> out what went wrong, and deletethe defective lines.
>
> Thanks again for your help, it's so great to have this working.
>
> Matt
>
> > > I am *not* a cracker, I'm just a little incompetent.
> > >
> > > APpreciate any help you might give.
> > >
> > > Thanks,
> > >
> > > Matt
> > >
> > >
> > > --------------------------
> > > .''`. Matt Price
> > >
> > > : :' : Debian User
> > >
> > > `. `'` & hemi-geek
> > > `-
> > > --------------------------
> >
> > --
> >
> >
> > anoop
> > aaryal@foresightint.com
> >
> >
> > --
> > To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
> > with a subject of "unsubscribe". Trouble? Contact
> > listmaster@lists.debian.org
--
anoop
aaryal@foresightint.com
Reply to: