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

Hi,

  1. I have downloaded openembedded-(core) source code form the below link
    High performance, low power Embedded Computing Systems | Toradex Developer Center

  2. I have added mysql by adding below config settings to conf/local.conf

    IMAGE_INSTALL_append = " mysql5"

  3. After flashing the images to the target when i am trying to run mysql i am getting below error:

    root@apalis-t30:~# mysql
    ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
    root@apalis-t30:~#

  4. “mysql.sock” file is not available inside “/var/lib/mysql/”

    root@apalis-t30:~# ls -l /var/lib/mysql/mysql.sock
    ls: cannot access ‘/var/lib/mysql/mysql.sock’: No such file or directory
    root@apalis-t30:~#

  5. below are files listed inside “/var/lib/mysql/” directory

    root@apalis-t30:~# ls -l /var/lib/mysql/
    total 32
    -rw-rw---- 1 mysql mysql 16384 Jun 13 07:16 aria_log.00000001
    -rw-rw---- 1 mysql mysql 52 Jun 13 07:16 aria_log_control
    drwx------ 2 mysql root 4096 Jun 13 07:16 mysql
    drwx------ 2 mysql mysql 4096 Jun 13 07:16 performance_schema
    drwx------ 2 mysql root 4096 Jun 13 07:16 test
    root@apalis-t30:~#

  6. root@apalis-t30:~# ls -l /var/lib/mysql/mysql

    total 1008
    -rw-rw---- 1 mysql mysql 8820 Jun 13 07:16 columns_priv.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 columns_priv.MYD
    -rw-rw---- 1 mysql mysql 4096 Jun 13 07:16 columns_priv.MYI
    -rw-rw---- 1 mysql mysql 9582 Jun 13 07:16 db.frm
    -rw-rw---- 1 mysql mysql 880 Jun 13 07:16 db.MYD
    -rw-rw---- 1 mysql mysql 5120 Jun 13 07:16 db.MYI
    -rw-rw---- 1 mysql mysql 10239 Jun 13 07:16 event.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 event.MYD
    -rw-rw---- 1 mysql mysql 2048 Jun 13 07:16 event.MYI
    -rw-rw---- 1 mysql mysql 8665 Jun 13 07:16 func.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 func.MYD
    -rw-rw---- 1 mysql mysql 1024 Jun 13 07:16 func.MYI
    -rw-rw---- 1 mysql mysql 35 Jun 13 07:16 general_log.CSM
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 general_log.CSV
    -rw-rw---- 1 mysql mysql 8776 Jun 13 07:16 general_log.frm
    -rw-rw---- 1 mysql mysql 8700 Jun 13 07:16 help_category.frm
    -rw-rw---- 1 mysql mysql 1092 Jun 13 07:16 help_category.MYD
    -rw-rw---- 1 mysql mysql 3072 Jun 13 07:16 help_category.MYI
    -rw-rw---- 1 mysql mysql 8612 Jun 13 07:16 help_keyword.frm
    -rw-rw---- 1 mysql mysql 91408 Jun 13 07:16 help_keyword.MYD
    -rw-rw---- 1 mysql mysql 16384 Jun 13 07:16 help_keyword.MYI
    -rw-rw---- 1 mysql mysql 8630 Jun 13 07:16 help_relation.frm
    -rw-rw---- 1 mysql mysql 9252 Jun 13 07:16 help_relation.MYD
    -rw-rw---- 1 mysql mysql 19456 Jun 13 07:16 help_relation.MYI
    -rw-rw---- 1 mysql mysql 8770 Jun 13 07:16 help_topic.frm
    -rw-rw---- 1 mysql mysql 450388 Jun 13 07:16 help_topic.MYD
    -rw-rw---- 1 mysql mysql 20480 Jun 13 07:16 help_topic.MYI
    -rw-rw---- 1 mysql mysql 9510 Jun 13 07:16 host.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 host.MYD
    -rw-rw---- 1 mysql mysql 2048 Jun 13 07:16 host.MYI
    -rw-rw---- 1 mysql mysql 8778 Jun 13 07:16 ndb_binlog_index.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 ndb_binlog_index.MYD
    -rw-rw---- 1 mysql mysql 1024 Jun 13 07:16 ndb_binlog_index.MYI
    -rw-rw---- 1 mysql mysql 8586 Jun 13 07:16 plugin.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 plugin.MYD
    -rw-rw---- 1 mysql mysql 1024 Jun 13 07:16 plugin.MYI
    -rw-rw---- 1 mysql mysql 10012 Jun 13 07:16 proc.frm
    -rw-rw---- 1 mysql mysql 292 Jun 13 07:16 proc.MYD
    -rw-rw---- 1 mysql mysql 4096 Jun 13 07:16 proc.MYI
    -rw-rw---- 1 mysql mysql 8875 Jun 13 07:16 procs_priv.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 procs_priv.MYD
    -rw-rw---- 1 mysql mysql 4096 Jun 13 07:16 procs_priv.MYI
    -rw-rw---- 1 mysql mysql 8800 Jun 13 07:16 proxies_priv.frm
    -rw-rw---- 1 mysql mysql 1386 Jun 13 07:16 proxies_priv.MYD
    -rw-rw---- 1 mysql mysql 5120 Jun 13 07:16 proxies_priv.MYI
    -rw-rw---- 1 mysql mysql 8838 Jun 13 07:16 servers.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 servers.MYD
    -rw-rw---- 1 mysql mysql 1024 Jun 13 07:16 servers.MYI
    -rw-rw---- 1 mysql mysql 35 Jun 13 07:16 slow_log.CSM
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 slow_log.CSV
    -rw-rw---- 1 mysql mysql 8976 Jun 13 07:16 slow_log.frm
    -rw-rw---- 1 mysql mysql 8955 Jun 13 07:16 tables_priv.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 tables_priv.MYD
    -rw-rw---- 1 mysql mysql 4096 Jun 13 07:16 tables_priv.MYI
    -rw-rw---- 1 mysql mysql 8636 Jun 13 07:16 time_zone.frm
    -rw-rw---- 1 mysql mysql 8624 Jun 13 07:16 time_zone_leap_second.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 time_zone_leap_second.MYD
    -rw-rw---- 1 mysql mysql 1024 Jun 13 07:16 time_zone_leap_second.MYI
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 time_zone.MYD
    -rw-rw---- 1 mysql mysql 1024 Jun 13 07:16 time_zone.MYI
    -rw-rw---- 1 mysql mysql 8606 Jun 13 07:16 time_zone_name.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 time_zone_name.MYD
    -rw-rw---- 1 mysql mysql 1024 Jun 13 07:16 time_zone_name.MYI
    -rw-rw---- 1 mysql mysql 8686 Jun 13 07:16 time_zone_transition.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 time_zone_transition.MYD
    -rw-rw---- 1 mysql mysql 1024 Jun 13 07:16 time_zone_transition.MYI
    -rw-rw---- 1 mysql mysql 8748 Jun 13 07:16 time_zone_transition_type.frm
    -rw-rw---- 1 mysql mysql 0 Jun 13 07:16 time_zone_transition_type.MYD
    -rw-rw---- 1 mysql mysql 1024 Jun 13 07:16 time_zone_transition_type.MYI
    -rw-rw---- 1 mysql mysql 10630 Jun 13 07:16 user.frm
    -rw-rw---- 1 mysql mysql 308 Jun 13 07:16 user.MYD
    -rw-rw---- 1 mysql mysql 2048 Jun 13 07:16 user.MYI
    root@apalis-t30:~#
    So how to resolve this issue?

Hi

Do you start the mysql server before trying to access it from the mysql client program?

I guess you have a systemd service file to accomplish this:

e.g. starting it manually until shutdown:

systemctl start mysqld

or to start the service at each of the following boots:

systemctl enable mysqld

Max

Hi Max,

Thank you for the info. After starting manually working fine.