Re: Reset rights for root@localhost

From	Jens Riedel <JensRie@gmx.de>
Newsgroups	comp.databases.mysql
Subject	Re: Reset rights for root@localhost
Date	2011-04-11 14:35 +0200
Message-ID	<90gat6FuuoU1@mid.individual.net> (permalink)
References	<90g72aFa9U1@mid.individual.net> <inuplv$k62$1@dont-email.me>

Show all headers | View raw

Thank you, that worked.

Jens

Am 11.04.2011 13:46, schrieb Jerry Stuckle:
> On 4/11/2011 7:30 AM, Jens Riedel wrote:
>> Hi,
>>
>> I have an urgent problem:
>>
>> A colleague changed the "root@localhost" in the user management into
>> "root@%"
>>
>> Now we can't access anymore, neither via localhost nor from remote.
>>
>> Any hints how to repair this and enable root@localhost again are very
>> appreciated.
>>
>> Thanks
>> Jens
>
> First step would be to start MySQL without any user authentication - see
> http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html
>
> Then you should be able to get in and correct the tables.
>

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Reset rights for root@localhost Jens Riedel <JensRie@gmx.de> - 2011-04-11 13:30 +0200
  Re: Reset rights for root@localhost Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-11 07:46 -0400
    Re: Reset rights for root@localhost Jens Riedel <JensRie@gmx.de> - 2011-04-11 14:35 +0200
      Re: Reset rights for root@localhost Joe Hesse <JoeHesse@gmail.com> - 2011-04-11 13:34 -0500

csiph-web