Mysql on Ubuntu 10.04 LTS - access denied for user at localhost

[Chris Green]

On Wed, Mar 06, 2013 at 08:49:45PM +0000, Andrew wrote:
> I've installed the mysql-server 5.1 and mysqladmin (on ubuntu 10.04 LTS)
> but when I try to access the mysql-server get the error message "ERROR
> 1045 (28000): Access denied for user 'andrew'@'localhost' (using
> password: YES)"
> 
> Can anybody throw any light on this please - I've used mysql before, but
> admittedly on a CentOS system with no problems!
> 
I always find that mysql is *very* fussy about permissions and host
names.

So try 'andrew'@'127.0.0.1' and also the actual host name.

-- 
Chris Green