From: Martin Gainty Date: October 20 2009 12:34am Subject: RE: Passwords not working List-Archive: http://lists.mysql.com/mysql/219102 Message-Id: Content-Type: multipart/alternative; boundary="_1271fd8e-0551-4e4b-b215-c92f837cc014_" --_1271fd8e-0551-4e4b-b215-c92f837cc014_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable someone probably installed mysql for DHCP address e.g 192.168.fu.bar 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'=E9tat du ch=F4mage Martin Gainty=20 ______________________________________________=20 Note de d=E9ni et de confidentialit=E9 Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes= pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat= isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e= ou la copie de ceci est interdite. Ce message sert =E0 l'information seule= ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d= onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation= =2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni= . > Date: Mon=2C 19 Oct 2009 16:48:36 -0700 > From: listmail@stripped > To: mysql@stripped > Subject: Re: Passwords not working >=20 > On Mon=2C 19 Oct 2009 16:30:47 -0700 > John Oliver wrote: >=20 > > I have a problem with MySQL passwords... I set them=2C write them > > down... and they stop working. I have to go in and manually reset > > them. > >=20 > > Right now=2C I have a database that=2C even after resetting the passwor= d=2C > > I still cannot access it. > >=20 > > /var/log/mysql.log doesn't give me any useful information. How can I > > get MySQL to tell me what it's unhappy about=2C or get more information > > from the client other than it just didn't work? > >=20 > > I also have problems with MySQL resolving names=2C or not resolving > > names=2C or ??? I usually add 'user'@'ip.address' and > > 'user'@'host.name' But=2C more and more often=2C I've had to put > > skip-name-resolve in my.cnf=2C but with my current problem=2C I'm still > > seeing that 'user'@'host-name' is being rejected=2C even when I use -h > > ip.address on the command line > >=20 > > And when I add those two users=2C and go to reset passwords=2C it doesn= 't > > want to let me specify 'user'@'ip.address' or 'user'@'host.name' but > > just 'user' I *think* it's resetting the password for both... the > > hashes are always the same. But I just don't know. > >=20 > > What am I missing? > >=20 >=20 >=20 > Are you accessing MySQL from the same host? If so=2C 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'). >=20 > 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: >=20 > GRANT ALL on .* to 'user'@'localhost' identified by > 'foobar'=3B >=20 > The username=2C 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. >=20 >=20 > --=20 > =20 > Greg Maruszeczka >=20 > Office: 250.412.9651 || Mobile: 250.886.4577 > Skype: websage.ca || GTalk IM: gmarus >=20 > http://websage.ca >=20 > GnuPG-ID: 0x4309323E=2C http://pgp.mit.edu >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped= om >=20 =20 _________________________________________________________________ Hotmail: Trusted email with Microsoft=92s powerful SPAM protection. http://clk.atdmt.com/GBL/go/177141664/direct/01/= --_1271fd8e-0551-4e4b-b215-c92f837cc014_--