Re: MySQL refusing to accept passwords

2011-07-26 Thread misiaq
Shawn Green (MySQL) shawn.l.gr...@oracle.com 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

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 webmas...@athydro.com 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.

Re: MySQL refusing to accept passwords

2011-07-22 Thread Johan De Meersman
- Original Message - From: Tim Thorburn webmas...@athydro.com 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?

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

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. -

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

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

MySQL refusing to accept passwords

2011-07-21 Thread Tim Thorburn
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 evening, I launched MySQL Workbench