Re: Passwords not working
On Mon, Oct 19, 2009 at 07:45:11PM -0400, Michael Dykman wrote: The type of password instability you are talking about is pretty much unheard of in MySQL.. Yeah, well, I can have a real black thumb for this sort of thing :-) I'm sure I read about at least two different ways to add passwords. I don't know... usually, it works, but on this particular machine... I just tried to connect asa root again, and it's rejecting the password that I KNOW I set... it's written down. I am not mistyping it. I'm copy-and-pasting from the same text that I used to set the password. I just don't know how to get MySQL to tell me exactly what it's unhappy about. I'm going to go and reset the root password again, and it'll work for a while... but tomorrow, it almost certainly will not work again, and I'll have to go back and reset it *again*. however, reverse DNS resolution is always messing up depending on the network setup. From a console on your database host, how easily can you resolve the hostnames that your The web server and database server (both VMs under VMware ESXi) each have two network interfaces... one public, and one private. The private interfaces are connected to a private VLAN on a virtual switch that is only for these two servers. MySQL only listens on 172.16.1.1, and the web server connects to that IP. On each host, I have a hosts entry for the other. -- *** * John Oliver http://www.john-oliver.net/ * * * *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Passwords not working
The type of password instability you are talking about is pretty much unheard of in MySQL.. however, reverse DNS resolution is always messing up depending on the network setup. From a console on your database host, how easily can you resolve the hostnames that your client is presenting? What is your network setup? Not the safest of practices, but for dev accounts, I usually create one for user@'%' and sometimes one one for u...@localhost if needed and that works very well for me.. - michael dykman On Mon, Oct 19, 2009 at 7:30 PM, John Oliver joli...@john-oliver.net 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'@'host.name' 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'@'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. What am I missing? -- *** * John Oliver http://www.john-oliver.net/ * * * *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May you live every day of your life. Jonathan Swift -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Passwords not working
On Mon, 19 Oct 2009 16:30:47 -0700 John Oliver joli...@john-oliver.net 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'@'host.name' 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'@'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. 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: websage.ca || GTalk IM: gmarus http://websage.ca GnuPG-ID: 0x4309323E, http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Passwords not working
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'é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: listm...@websage.ca To: mysql@lists.mysql.com Subject: Re: Passwords not working On Mon, 19 Oct 2009 16:30:47 -0700 John Oliver joli...@john-oliver.net 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'@'host.name' 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'@'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. 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: websage.ca || GTalk IM: gmarus http://websage.ca GnuPG-ID: 0x4309323E, http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com _ Hotmail: Trusted email with Microsoft’s powerful SPAM protection. http://clk.atdmt.com/GBL/go/177141664/direct/01/
