Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

((lambda (foo) (bar foo)) (baz))


devel / comp.databases.mysql / Naive User

SubjectAuthor
* Naive Userpinnerite
`* Re: Naive UserJ.O. Aho
 `* Re: Naive Userpinnerite
  `* Re: Naive UserThe Natural Philosopher
   `- Re: Naive Userpinnerite

1
Naive User

<20220115225605.ab6d3b6942db5cbec4ee231b@gmail.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=63&group=comp.databases.mysql#63

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!aioe.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: pinnerite@gmail.com (pinnerite)
Newsgroups: comp.databases.mysql
Subject: Naive User
Date: Sat, 15 Jan 2022 22:56:05 +0000
Organization: A noiseless patient Spider
Lines: 11
Message-ID: <20220115225605.ab6d3b6942db5cbec4ee231b@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: reader02.eternal-september.org; posting-host="3f2bd9f03379852a87a597b9ace31143";
logging-data="8584"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18z+gklbvWqK1GcCIZVbb4Z5qKnbEFduq4="
Cancel-Lock: sha1:5lUx0mhO1iKeBTkFno96KSbAY04=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.32; x86_64-pc-linux-gnu)
 by: pinnerite - Sat, 15 Jan 2022 22:56 UTC

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.

Re: Naive User

<j4h4jcFipgaU1@mid.individual.net>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=64&group=comp.databases.mysql#64

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: user@example.net (J.O. Aho)
Newsgroups: comp.databases.mysql
Subject: Re: Naive User
Date: Sun, 16 Jan 2022 00:44:44 +0100
Lines: 22
Message-ID: <j4h4jcFipgaU1@mid.individual.net>
References: <20220115225605.ab6d3b6942db5cbec4ee231b@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net AaoSy7XzIQo6ofVhphpO/A6lXNEgrUVutV6eIHuPaCAdAywD+3
Cancel-Lock: sha1:Dhm9tXPJWYIDbAZRCB1MrgyhQ2E=
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
Thunderbird/91.4.1
Content-Language: en-US-large
In-Reply-To: <20220115225605.ab6d3b6942db5cbec4ee231b@gmail.com>
 by: J.O. Aho - Sat, 15 Jan 2022 23:44 UTC

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

Re: Naive User

<20220116091802.883e892d7fee8398c28544d9@gmail.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=65&group=comp.databases.mysql#65

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: pinnerite@gmail.com (pinnerite)
Newsgroups: comp.databases.mysql
Subject: Re: Naive User
Date: Sun, 16 Jan 2022 09:18:02 +0000
Organization: A noiseless patient Spider
Lines: 35
Message-ID: <20220116091802.883e892d7fee8398c28544d9@gmail.com>
References: <20220115225605.ab6d3b6942db5cbec4ee231b@gmail.com>
<j4h4jcFipgaU1@mid.individual.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: reader02.eternal-september.org; posting-host="6ca530beb6e11c04bccfbf3ecfdf11fb";
logging-data="28045"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/wGwF7O3qKf6WCS/sFihEnJSHPDvE0bEs="
Cancel-Lock: sha1:lgDZBljA8Qj/P+4EgxzRKOptPNY=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.32; x86_64-pc-linux-gnu)
 by: pinnerite - Sun, 16 Jan 2022 09:18 UTC

On Sun, 16 Jan 2022 00:44:44 +0100
"J.O. Aho" <user@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

--
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.

Re: Naive User

<ss0qau$96v$1@dont-email.me>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=66&group=comp.databases.mysql#66

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: tnp@invalid.invalid (The Natural Philosopher)
Newsgroups: comp.databases.mysql
Subject: Re: Naive User
Date: Sun, 16 Jan 2022 09:59:57 +0000
Organization: A little, after lunch
Lines: 47
Message-ID: <ss0qau$96v$1@dont-email.me>
References: <20220115225605.ab6d3b6942db5cbec4ee231b@gmail.com>
<j4h4jcFipgaU1@mid.individual.net>
<20220116091802.883e892d7fee8398c28544d9@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Sun, 16 Jan 2022 09:59:58 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="a8e7bc5776851aa56222ff592945751a";
logging-data="9439"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18GG736q9rlbv13Vlp57cqjDw1iaw3EzYk="
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
Thunderbird/78.14.0
Cancel-Lock: sha1:0NHJqqg//Fqa6N41XiEUBTevUKQ=
In-Reply-To: <20220116091802.883e892d7fee8398c28544d9@gmail.com>
Content-Language: en-GB
 by: The Natural Philosop - Sun, 16 Jan 2022 09:59 UTC

On 16/01/2022 09:18, pinnerite wrote:
> On Sun, 16 Jan 2022 00:44:44 +0100
> "J.O. Aho" <user@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.

Re: Naive User

<20220116220517.af49f8378f2b7a46cf38e251@gmail.com>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=67&group=comp.databases.mysql#67

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: pinnerite@gmail.com (pinnerite)
Newsgroups: comp.databases.mysql
Subject: Re: Naive User
Date: Sun, 16 Jan 2022 22:05:17 +0000
Organization: A noiseless patient Spider
Lines: 55
Message-ID: <20220116220517.af49f8378f2b7a46cf38e251@gmail.com>
References: <20220115225605.ab6d3b6942db5cbec4ee231b@gmail.com>
<j4h4jcFipgaU1@mid.individual.net>
<20220116091802.883e892d7fee8398c28544d9@gmail.com>
<ss0qau$96v$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: reader02.eternal-september.org; posting-host="6ca530beb6e11c04bccfbf3ecfdf11fb";
logging-data="5138"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+g0gcJtP0tkGhmmS+P+2KYFy5cVVGd0pI="
Cancel-Lock: sha1:VvQw8VlH11pksSjx3MZgnFfjsx8=
X-Newsreader: Sylpheed 3.7.0 (GTK+ 2.24.32; x86_64-pc-linux-gnu)
 by: pinnerite - Sun, 16 Jan 2022 22:05 UTC

On Sun, 16 Jan 2022 09:59:57 +0000
The Natural Philosopher <tnp@invalid.invalid> wrote:

> On 16/01/2022 09:18, pinnerite wrote:
> > On Sun, 16 Jan 2022 00:44:44 +0100
> > "J.O. Aho" <user@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.
>
It does look like it. Thanks.

--
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.

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor