Re: MySQL refusing to accept passwords

2011-07-26 Thread misiaq
"Shawn Green (MySQL)" pisze: (...) > You can be the correct > user, using the correct password but you may not be allowed (by the host > pattern) to login from the machine from which you are attempting to login. > It could be the case you got your account setup as username@localhost and it

Re: MySQL refusing to accept passwords

2011-07-25 Thread Shawn Green (MySQL)
On 7/22/2011 18:48, Tim Thorburn wrote: On 7/22/2011 5:02 PM, Shawn Green (MySQL) wrote: On 7/21/2011 22:45, Tim Thorburn wrote: Hello, For those keeping score, this will be the second time in the past few months I've come upon this problem. To recap, this is happening on a development laptop

Re: MySQL refusing to accept passwords

2011-07-23 Thread Johan De Meersman
- Original Message - > From: "Tim Thorburn" > > Before this, I did try to simply reset the root password by once > again stopping the MySQL service, starting it with --skip-grant-tables; > however regardless of what I changed the password to, I received the > same error. This error was p

Re: MySQL refusing to accept passwords

2011-07-22 Thread Tim Thorburn
On 7/22/2011 5:02 PM, Shawn Green (MySQL) wrote: On 7/21/2011 22:45, Tim Thorburn wrote: Hello, For those keeping score, this will be the second time in the past few months I've come upon this problem. To recap, this is happening on a development laptop running Win7 64-bit Ultimate and MySQL 5.

Re: MySQL refusing to accept passwords

2011-07-22 Thread Claudio Nanni
Hi, I dont remember the details of the past 'experience' but, did you try a simple: mysql -uroot -p -h127.0.0.1 -P3306? and also an anomymous login: mysql also make sure you remove the anonymous account if present, sometimes it introduces strange behaviours as the one you described. and as su

Re: MySQL refusing to accept passwords

2011-07-22 Thread Shawn Green (MySQL)
On 7/22/2011 17:02, Shawn Green (MySQL) wrote: ... quick correction ... * ...the account 'root' for a new installation is* created without a password. ... I originally said 'is not'. Sorry for the confusion -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware

Re: MySQL refusing to accept passwords

2011-07-22 Thread Shawn Green (MySQL)
On 7/21/2011 22:45, Tim Thorburn wrote: Hello, For those keeping score, this will be the second time in the past few months I've come upon this problem. To recap, this is happening on a development laptop running Win7 64-bit Ultimate and MySQL 5.5.13. This morning, all was working well. This eve

Re: MySQL refusing to accept passwords

2011-07-22 Thread Johan De Meersman
- Original Message - > From: "Tim Thorburn" > > For those keeping score, this will be the second time in the past few Yes, I remember that. You wouldn't happen to have a known-good backup around, to verify if the password has indeed changed in the authentication tables? -- Bier met gr