I am running MySQL 5.0.75-0ubuntu10.5 on Ubuntu 9.04 Jaunty. When I try to login as a root to MySQL
# mysql -u root -h localhost -padmin
I get following error
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2)
But if I try using
phpmyadmin http://localhost/phpmyadmin I can login using same credentials.
There are 3 entries for user "root" in mysql.user table with 3 different hosts
- indrik (hostname)
Encrypted Password for all these 3 entries is identical. I tried all 3 hostnames with
-h argument, still no luck.