can not change password for root-user
Posted by:
lists
Date: March 28, 2005 12:35AM
Hello,
I can't seem to change the password for my root-user in MySQL.
When I go into mysql and type;
UPDATE mysql.user SET Password=PASSWORD('mypassword') WHERE User='root' AND Host='localhost';
I get the following error;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
How can I change my root-password in the best way?
Subject
Written By
Posted
can not change password for root-user
March 28, 2005 12:35AM
Sorry, you can't reply to this topic. It has been closed.
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.