Reset rights for root@localhost

#1

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

#2

On 4/11/2011 7:30 AM, Jens Riedel wrote:

Quote:

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/...rmissions.html

Then you should be able to get in and correct the tables.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#3

Thank you, that worked.

Jens

Am 11.04.2011 13:46, schrieb Jerry Stuckle:

Quote:

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/...rmissions.html

Then you should be able to get in and correct the tables.

#4

On Mon, 11 Apr 2011 14:35:50 +0200, Jens Riedel wrote:

Quote:

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/...rmissions.html

Then you should be able to get in and correct the tables.

Why didn't "root@%" work? It works on my computer when I access the
server from the same computer the server is running on.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Reset rights for root@localhost

comp.databases.mysql comp.databases.mysql

Reset rights for root@localhost - 04-11-2011 , 06:30 AM

Re: Reset rights for root@localhost - 04-11-2011 , 06:46 AM

Re: Reset rights for root@localhost - 04-11-2011 , 07:35 AM

Re: Reset rights for root@localhost - 04-11-2011 , 01:34 PM