mysqladmin: unable to change password
Hello!
mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.49, for pc-linux-gnu on i686
Server version 3.23.49-log
I can't change nor the root password, nor the anonymous password for
mysql.
sudo safe_mysqld --skip-grant-tables &
sudo mysqladmin -u root password "newpwd"
mysqladmin: unable to change password
mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
ERROR 1132: You must have privileges to update tables in the mysql
database to be able to change passwords for others
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('');
ERROR 1131: You are using MySQL as an anonymous users and anonymous users
are not allowed to change passwords
How can I be an anonymous user, when I logged as root user?
What is the problem? How can I solve this problem?
--
Regards,
Paul (Sorry for my English!)
->->-> Debian Junior Project :-) :-) :-) :-) :-) :-) :-) :-) :-)
Reply to: