Re: sql password

yeah if you just installed, root doesn't have a password.. so you need to not specify -p (this tells the server to try and authenticate with an empty password, as opposed to attempting to authenticate with no password.. there is a difference): mysqladmin -u root password mypassword Mike Jeremiah Jester wrote:

Im attempting to install mysql. The service started and everything seems to be going ok except for that I can't set the root password for the mysql server. To reset password i type: /usr/bin/mysqladmin -u root -p mypassword Then I get the following error: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Can anyone help? Thanks, JJ