List:General Discussion« Previous MessageNext Message »
From:James Dekker Date:October 14 2009 8:11pm
Subject:Re: Unable to Login to MySQL 5
View as plain text  
Fixed it!

Did the following:

mysql -u root -p

mysql> use mysql;

update user set password=PASSWORD("password") where User='root';

mysql> flush privileges;

mysql> quit

I am now able to login using my SequelPro MySQL client! :-)

Happy programming,

James

On Oct 14, 2009, at 1:00 PM, James Dekker wrote:

> Claudio,
>
> Thank you for the tip... Unfortunately, I tried your suggestion and  
> it still didn't work!
>
> mysqladmin -u root -p root
> Enter password:                          (I entered root here)
> mysqladmin: Unknown command: 'root'
>
> When I tried it again (this time leaving the password as blank):
>
> mysqladmin -u root -p root
> Enter password:
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password:  
> NO)'
>
> Is there anyway to get past this issue? I really wish that I didn't  
> grant the extra privileges! :-(
>
> Happy programming,
>
> James
>
> On Oct 14, 2009, at 12:25 PM, Claudio Nanni wrote:
>
>> Add -p to your mysqladmin statement to change password and use  
>> 'root' as password.
>> you wanted to give extra grants to root but you just set the  
>> password for root@localhost.
>> you don't need to grant anything to root, usually.
>> cheers
>> Claudio
>>
>>
>>> On Oct 14, 2009 9:07 PM, "James Dekker" <james.dekker@stripped>  
>>> wrote:
>>>
>>> Hello there,
>>>
>>> I have been using MySQL 5 on my OS X Leopard based laptop for  
>>> quite some time now...
>>>
>>> Didn't have a password set and my login was "root" on localhost.
>>>
>>> Downloaded just now the Spring distribution was following the  
>>> steps to run the petclinic sample application.
>>>
>>> Ran the following scripts to set up petclinic:
>>>
>>> CREATE DATABASE petclinic;
>>>
>>> GRANT ALL PRIVILEGES ON petclinic.* TO root@localhost IDENTIFIED  
>>> BY 'root';
>>>
>>> Now, when I try to login to MySQL using the SequelPro client:
> http://www.sequelpro.com/
>>>
>>> I am unable to login!
>>>
>>> This is the error Sequel Pro and also the command line states when  
>>> I login as root with no password (which was working before I ran  
>>> the petclinic script):
>>>
>>> "Unable to connect to host  because access was denied.
>>>
>>> Double-check your username and password and ensure that access  
>>> from your current location is permitted.
>>>
>>> MySQL said: Access denied for user 'root'@'localhost' (using  
>>> password: NO)"
>>>
>>> Does anyone know what's wrong? I am not unable to access any of my  
>>> local databases!
>>>
>>> How can I revert this?
>>>
>>> When I tried (from the command line):
>>>
>>> mysqladmin -u root password 'newpassword'
>>>
>>> I got this message:
>>>
>>> mysqladmin: connect to server at 'localhost' failed
>>> error: 'Access denied for user 'root'@'localhost' (using password:  
>>> NO)'
>>>
>>> Would really appreciate it if someone could help me resolve this  
>>> issue...
>>>
>>> Thank you for taking the time to read this,
>>>
>>> James
>>>
>>> -- 
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>>
>>
>


Thread
Unable to Login to MySQL 5James Dekker14 Oct
  • Re: Unable to Login to MySQL 5Claudio Nanni14 Oct
    • Re: Unable to Login to MySQL 5James Dekker14 Oct
      • Re: Unable to Login to MySQL 5James Dekker14 Oct
      • Re: Unable to Login to MySQL 5mos14 Oct
RE: Unable to Login to MySQL 5John Daisley15 Oct