0

I've just removed and reinstalled mysql on my Amazon EC2 server. When I went to change the root password on the new install:

sudo /usr/bin/mysqladmin -u root password 'MYNEWPASSWORD'

I get an access denied error:

error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Has it held onto the old root account somehow?

I've tried starting mysql skipping the grant tables, but this just removes the command prompt and sits there. Anyone have any ideas why this is happening?

1
Contributor
1
Reply
3
Views
6 Years
Discussion Span
Last Post by benkyma
0

Problem solved. I just started without the grant tables, and opened another shell to reset the password

I've just removed and reinstalled mysql on my Amazon EC2 server. When I went to change the root password on the new install:

sudo /usr/bin/mysqladmin -u root password 'MYNEWPASSWORD'

I get an access denied error:

error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Has it held onto the old root account somehow?

I've tried starting mysql skipping the grant tables, but this just removes the command prompt and sits there. Anyone have any ideas why this is happening?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.