Home / server / Questions / 171823
Accepted
Abhishek A
Asked: 2010-08-19 05:08:17 +0800 CST

Not able to login as a root in mysql from localhost through commandline

  • 772

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

  • localhost
  • 127.0.0.1
  • indrik (hostname)

Encrypted Password for all these 3 entries is identical. I tried all 3 hostnames with -h argument, still no luck.

Any pointers?

linux mysql login

1 Answers

  1. Best Answer

    Try connecting to localhost using TCP instead with the following additional command line argument:

    --protocol=TCP

    You can also make sure you have the correct socket file my checking /etc/my.cnf : 

    [mysqld]
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock

    If that states a different socket than the one in your error you can specify it on the command line with --socket=path, i.e. --socket=/var/lib/mysql/mysql.sock.

    • 3