List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:October 20 2009 12:34am
Subject:RE: Passwords not working
View as plain text  
someone probably installed mysql for DHCP address e.g
then as luck would have it the IP address changed

if you pull all network connections everyone on that box should be able to access mysql

Salutations de l'état du chômage
Martin Gainty 
Note de déni et de confidentialité

Ce message est confidentiel et peut être privilégié. Si vous
n'êtes pas le destinataire prévu, nous te demandons avec bonté que
pour satisfaire informez l'expéditeur. N'importe quelle diffusion non
autorisée ou la copie de ceci est interdite. Ce message sert à l'information
seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant
donné que les email peuvent facilement être sujets à la manipulation,
nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

> Date: Mon, 19 Oct 2009 16:48:36 -0700
> From: listmail@stripped
> To: mysql@stripped
> Subject: Re: Passwords not working
> On Mon, 19 Oct 2009 16:30:47 -0700
> John Oliver <joliver@stripped> wrote:
> > I have a problem with MySQL passwords... I set them, write them
> > down... and they stop working.  I have to go in and manually reset
> > them.
> > 
> > Right now, I have a database that, even after resetting the password,
> > I still cannot access it.
> > 
> > /var/log/mysql.log doesn't give me any useful information.  How can I
> > get MySQL to tell me what it's unhappy about, or get more information
> > from the client other than it just didn't work?
> > 
> > I also have problems with MySQL resolving names, or not resolving
> > names, or ???  I usually add 'user'@'ip.address' and
> > 'user'@''  But, more and more often, I've had to put
> > skip-name-resolve in my.cnf, but with my current problem, I'm still
> > seeing that 'user'@'host-name' is being rejected, even when I use -h
> > ip.address on the command line
> > 
> > And when I add those two users, and go to reset passwords, it doesn't
> > want to let me specify 'user'@'ip.address' or 'user'@'' but
> > just 'user'  I *think* it's resetting the password for both... the
> > hashes are always the same.  But I just don't know.
> > 
> > What am I missing?
> > 
> Are you accessing MySQL from the same host? If so, you don't need the
> -h option unless that's the only entry in your grant table under that
> username (i.e. 'user'@'ip-address').
> Can you give us an example of how you're setting the username and their
> permissions? Here's a typical example that gives access to an entire
> database to a single user provided they're accessing it on the same
> host:
> GRANT ALL on <database-name>.* to 'user'@'localhost' identified by
> 'foobar';
> The username, password AND hostname have to match up for
> authentication to be successful: 'user'@'localhost' may be different
> than 'user'@'ip-address' even if they're intended to be the same person.
> -- 
> Greg Maruszeczka
> Office:	250.412.9651  ||  Mobile: 250.886.4577
> Skype:     ||  GTalk IM: gmarus
> GnuPG-ID: 0x4309323E,
> -- 
> MySQL General Mailing List
> For list archives:
> To unsubscribe:
Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
Passwords not workingJohn Oliver20 Oct
  • Re: Passwords not workingMichael Dykman20 Oct
    • Re: Passwords not workingJohn Oliver22 Oct
  • Re: Passwords not workinglistmail20 Oct
    • RE: Passwords not workingMartin Gainty20 Oct