Skip the -p.
You have no current password .
Jay Paulson wrote:
>I'm trying to change the root password for mysql. This is the first time
>I've tried to change the password and I can't get it to work. Below is the
>error message I get:
>
>[root@localhost bin]# ./mysqladmin -u root -p password 'new-password'
>Enter password:
>./mysqladmin: connect to server at 'localhost' failed
>error: 'Access denied for user: 'root@localhost' (Using password: YES)'
>
>I've looked at the manual and it doesn't say much that I've already done.
>I've also looked up the --skip-grant-tables but the only mysqld file I have
>to run is in the /etc/rc.d/init.d/ directory and it doesn't take
>the --skip-grant-tables flag. So I'm at a lost at what to do next.
>
>thanks.
>
>
>

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.