1. Forum
  2. USENET
  3. comp.databases.mysql

  • Naive User

    From pinnerite@pinnerite@gmail.com to comp.databases.mysql on Sat Jan 15 22:56:05 2022
    From Newsgroup: comp.databases.mysql

    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.
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From J.O. Aho@user@example.net to comp.databases.mysql on Sun Jan 16 00:44:44 2022
    From Newsgroup: comp.databases.mysql

    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
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From pinnerite@pinnerite@gmail.com to comp.databases.mysql on Sun Jan 16 09:18:02 2022
    From Newsgroup: comp.databases.mysql

    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.
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From The Natural Philosopher@tnp@invalid.invalid to comp.databases.mysql on Sun Jan 16 09:59:57 2022
    From Newsgroup: comp.databases.mysql

    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.
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From pinnerite@pinnerite@gmail.com to comp.databases.mysql on Sun Jan 16 22:05:17 2022
    From Newsgroup: comp.databases.mysql

    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.
    --- Synchronet 3.21d-Linux NewsLink 1.2