List:General Discussion« Previous MessageNext Message »
From:mos Date:October 14 2009 8:42pm
Subject:Re: Unable to Login to MySQL 5
View as plain text  
At 03:00 PM 10/14/2009, 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! :-(

You should have typed:

mysqladmin -uroot -p

There is no space between the "-u" and "root". There is a space before the 
"-p".

Mike


>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