I have a mysql database installed on my computer running Ubuntu 10.04. Whenever i try to login to it using the following command it gives me an error.
mysql --user=username --password=password ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES)
If i use phpmyadmin, i still can't login to the database.I installed the GUI thingy, mysql admin and i can use that to login and run queries. Also if i write a php/python script to connect to the DB, they do connect and make the required changes. What might be the problem and how do i go about fixing it ? My earlier installation of karmic didn't give me any such problems.