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: Next Unique Number - Generation

2011-07-22 Thread Prabhat Kumar
Assign each server a number and prefix/append that number to the unique > ID. > I will suggest you above, append -A for first machine and -B for second machine. -Prabhat On Thu, Jul 21, 2011 at 12:13 PM, Daevid Vincent wrote: > I can think of several ways to accomplish this (or close to it)

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