Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.mysql > #7618 > unrolled thread
| Started by | pinnerite <pinnerite@gmail.com> |
|---|---|
| First post | 2022-01-15 22:56 +0000 |
| Last post | 2022-01-16 22:05 +0000 |
| Articles | 5 — 3 participants |
Back to article view | Back to comp.databases.mysql
Naive User pinnerite <pinnerite@gmail.com> - 2022-01-15 22:56 +0000
Re: Naive User "J.O. Aho" <user@example.net> - 2022-01-16 00:44 +0100
Re: Naive User pinnerite <pinnerite@gmail.com> - 2022-01-16 09:18 +0000
Re: Naive User The Natural Philosopher <tnp@invalid.invalid> - 2022-01-16 09:59 +0000
Re: Naive User pinnerite <pinnerite@gmail.com> - 2022-01-16 22:05 +0000
| From | pinnerite <pinnerite@gmail.com> |
|---|---|
| Date | 2022-01-15 22:56 +0000 |
| Subject | Naive User |
| Message-ID | <20220115225605.ab6d3b6942db5cbec4ee231b@gmail.com> |
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.
[toc] | [next] | [standalone]
| From | "J.O. Aho" <user@example.net> |
|---|---|
| Date | 2022-01-16 00:44 +0100 |
| Message-ID | <j4h4jcFipgaU1@mid.individual.net> |
| In reply to | #7618 |
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
[toc] | [prev] | [next] | [standalone]
| From | pinnerite <pinnerite@gmail.com> |
|---|---|
| Date | 2022-01-16 09:18 +0000 |
| Message-ID | <20220116091802.883e892d7fee8398c28544d9@gmail.com> |
| In reply to | #7619 |
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.
[toc] | [prev] | [next] | [standalone]
| From | The Natural Philosopher <tnp@invalid.invalid> |
|---|---|
| Date | 2022-01-16 09:59 +0000 |
| Message-ID | <ss0qau$96v$1@dont-email.me> |
| In reply to | #7620 |
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.
[toc] | [prev] | [next] | [standalone]
| From | pinnerite <pinnerite@gmail.com> |
|---|---|
| Date | 2022-01-16 22:05 +0000 |
| Message-ID | <20220116220517.af49f8378f2b7a46cf38e251@gmail.com> |
| In reply to | #7621 |
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.
[toc] | [prev] | [standalone]
Back to top | Article view | comp.databases.mysql
csiph-web