Prev: smbmount and smbclient in sarge
Next: Printer Setup Using CUPS-KDE
From: Csányi Pál on 11 Feb 2005 17:20
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 :-) :-) :-) :-) :-) :-) :-) :-) :-)


--
To UNSUBSCRIBE, email to debian-user-REQUEST(a)lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster(a)lists.debian.org
 | 
Pages: 1
Prev: smbmount and smbclient in sarge
Next: Printer Setup Using CUPS-KDE