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 r...@localhost.
you don't need to grant anything to root, usually.
cheers
Claudio
On Oct 14, 2009 9:07 PM, "James Dekker" <james.dek...@gmail.com>
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 r...@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=claudio.na...@gmail.com
