Member Avatar for lewashby

Any idea why this is happening?

garrett@bedroom ~ $ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
  • 3 Contributors
  • 4 Replies
  • 224 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by lewashby
Member Avatar for 1stDAN

did you check whether mysqld.sock file exists in /var/run/mysqld ?

If not, you have to locate the correct directory (for example check /var/lib/mysql).
If found, you have to edit your my.cnf usually located in /etc/mysql

my.cnf has a section [client] like mine one:

    [client]
    port        = 3306
    socket      = /var/run/mysqld/mysqld.sock

Here you can update entry socket.

Member Avatar for 1stDAN

Did you already fixed your socket problem?

Member Avatar for rch1231

Hello,

The problem is that you do not ahve the mysql serve running which is called mysqld. You may not have it installed but and the client and server are two different packages.

Member Avatar for lewashby

I think I had the wrong one installed. Fixed now, thanks guys.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.