I was trying to give remote access to MySQL, as MySQL was only working locally.
I used command like this from tutorial:
mysql> update user set Host='126.96.36.199' where user='root';
I think this messed up the local mysql.
Now I cannot login with:
$ mysql -u root -p
i get this error:
Access denied for user 'root'@'localhost' (using password: Yes)
Now I know the password is right, as it used to work before. but I accidentally locked myself out..
I don't know what to do anymore.
The os used by the server is Ubuntu.