Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Naive User

9 views
Skip to first unread message

pinnerite

unread,
Jan 15, 2022, 5:56:07 PM1/15/22
to
When I try to start MySQL from a Linux Mint 20.3 terminal, it returns this:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock

I cannot find any configuration file that points to that address.

How does MySQL know to look there?

--
Mint 20.3, kernel 5.4.0-95-generic, Cinnamon 5.2.7
running on an AMD Phenom II X4 Black edition processor with 16GB of DRAM.

J.O. Aho

unread,
Jan 15, 2022, 6:44:47 PM1/15/22
to
On 15/01/2022 23.56, pinnerite wrote:
> When I try to start MySQL from a Linux Mint 20.3 terminal, it returns this:
>
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock
>
> I cannot find any configuration file that points to that address.
>
> How does MySQL know to look there?
>

The mysql daemon hasn't been started

sudo systemctl start mysql

if you want it to be automatically started after each reboot, then run this:

sudo systemctl enable mysql


--

//Aho

pinnerite

unread,
Jan 16, 2022, 4:18:05 AM1/16/22
to
That still doesn't answer my question.

What directs MySQL to look to var/run/mysqld to locate the socket file?

Alan

The Natural Philosopher

unread,
Jan 16, 2022, 5:00:00 AM1/16/22
to
On 16/01/2022 09:18, pinnerite wrote:
> On Sun, 16 Jan 2022 00:44:44 +0100
> "J.O. Aho" <us...@example.net> wrote:
>
>> On 15/01/2022 23.56, pinnerite wrote:
>>> When I try to start MySQL from a Linux Mint 20.3 terminal, it returns this:
>>>
>>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock
>>>
>>> I cannot find any configuration file that points to that address.
>>>
>>> How does MySQL know to look there?
>>>
>>
>> The mysql daemon hasn't been started
>>
>> sudo systemctl start mysql
>>
>> if you want it to be automatically started after each reboot, then run this:
>>
>> sudo systemctl enable mysql
>>
>>
>> --
>>
>> //Aho
>
> That still doesn't answer my question.
>
> What directs MySQL to look to var/run/mysqld to locate the socket file?
>
> Alan
>
On my system:

$cd /etc/mysql
$ grep sock *.cnf */*.cnf

mysql.conf.d/mysqld.cnf:# socket = /var/run/mysqld/mysqld.sock

But I think its a compiled in default. That can be changed there.



--
In todays liberal progressive conflict-free education system, everyone
gets full Marx.

pinnerite

unread,
Jan 16, 2022, 5:05:20 PM1/16/22
to
It does look like it. Thanks.
0 new messages