List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:August 26 2009 5:10am
Subject:R: Re: recovery help needed
View as plain text  
When you are in without the flag , issue the following:

Select current_user();

It should return root.
Then do this:
Grant all privileges on *.* 'root'@'%' identified by 'letmein'

It should work If you did not mess too much with grant tables.

Claudio

Il giorno 26 ago, 2009 4:36 m., "Todd Lyons" <tlyons@stripped> ha scritto:

>> On Wed, Aug 26, 2009 at 02:12, Joe<mysql.com@stripped> > wrote:
> >> >
We have an inaccessible...
So connect to it from somewhere other than localhost. :-)
Specifically from the bogus IP you set it to.

Let's say you used the bogus IP of 10.200.100.20.
1. Give the mysql server the IP 10.200.100.10 and a netmask 255.255.255.0.
2. On some other machine on the same LAN, give it the bogus IP with
the same netmask.
3. No need to worry about routes, it's on the same LAN.
4. On the other machine, connect using 'mysql -h10.200.100.10 -uroot
-p'.  When you enter the correct password, it should let you in.

* I don't know if you'll need to restart mysql for it to bind to the
new IP.  I don't think so, but then again I have not tested it.

--
Regards...      Todd

-- MySQL General Mailing List For list archives:
http://lists.mysql.com/mysql To unsubscribe: h...

Thread
R: Re: recovery help neededClaudio Nanni26 Aug