Add -p to your mysqladmin statement to change password and use 'root' as
you wanted to give extra grants to root but you just set the password for
you don't need to grant anything to root, usually.
On Oct 14, 2009 9:07 PM, "James Dekker" <james.dekker@stripped> wrote:
I have been using MySQL 5 on my OS X Leopard based laptop for quite some
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:
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
"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
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,
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql