1. Forum
  2. Usenet
  3. COMP.DATABASES.MYSQL

  • Naive User

    From pinnerite@21:1/5 to All on Sat Jan 15 22:56:05 2022
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From J.O. Aho@21:1/5 to pinnerite on Sun Jan 16 00:44:44 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From The Natural Philosopher@21:1/5 to pinnerite on Sun Jan 16 09:59:57 2022
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From pinnerite@21:1/5 to J.O. Aho on Sun Jan 16 09:18:02 2022
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From pinnerite@21:1/5 to The Natural Philosopher on Sun Jan 16 22:05:17 2022
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)