I was trying to move the MySQL tables so them were in another folder, so I messed out the plugins table or something like that and I ended up reinstalling the whole thing.
sudo aptitude purge mysql-server then I removed the MySQL data
rm -rf /var/lib/mysql/mysql and also I removed the data from the other directory I was trying to move the tables.
After reinstallation I supposed I would be able to login using
mysql -u root but it said the user was wrong. I tried with the old password and the same thing. Then I searched for a way to reset the root password.
So I did
mysqld_safe --skip-grant-tables then I logged in
mysql -u root succefully adn then I tried
UPDATE user SET Password=PASSWORD('new-password') where User='root'; with no luck,
0 rows affected. Then I did
SELECT * FROM User and all I got was
debian-sys-maint, nothing more, no root or any other user.
Any little help will be appreciated =/