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