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
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
"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:
Does anyone know what's wrong? I am not unable to access any of my
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
Thank you for taking the time to read this,