Results 1 to 2 of 2

Thread: Mysqldump cannot connect “permission denied”

  1. #1
    Join Date
    Jul 2020
    Beans
    2

    Mysqldump cannot connect “permission denied”

    Ubuntu 18.04
    10.1.44-MariaDB-0ubuntu0.18.04.1

    I’m trying to backup one of DBs:
    Code:
    mysqldump --single-transaction -h localhost -u root -p DBname > ./nxc-lv_20200727.bak
    Enter password:
    mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13 "Permission denied")" when trying to connect
    dmesg:
    Code:
    [66791.515094] audit: type=1400 audit(1595830991.140:283): apparmor="ALLOWED" operation="open" profile="/usr/bin/mysqldump" name="/etc/mysql/mariadb.cnf" pid=11886 comm="mysqldump" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
    [66791.515121] audit: type=1400 audit(1595830991.140:284): apparmor="ALLOWED" operation="open" profile="/usr/bin/mysqldump" name="/etc/mysql/conf.d/" pid=11886 comm="mysqldump" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
    [66791.515228] audit: type=1400 audit(1595830991.140:285): apparmor="ALLOWED" operation="open" profile="/usr/bin/mysqldump" name="/etc/mysql/conf.d/mysql.cnf" pid=11886 comm="mysqldump" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
    [66791.515273] audit: type=1400 audit(1595830991.144:286): apparmor="ALLOWED" operation="open" profile="/usr/bin/mysqldump" name="/etc/mysql/conf.d/mysqldump.cnf" pid=11886 comm="mysqldump" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
    [66791.515315] audit: type=1400 audit(1595830991.144:287): apparmor="ALLOWED" operation="open" profile="/usr/bin/mysqldump" name="/etc/mysql/mariadb.conf.d/" pid=11886 comm="mysqldump" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
    [66791.515375] audit: type=1400 audit(1595830991.144:288): apparmor="ALLOWED" operation="open" profile="/usr/bin/mysqldump" name="/etc/mysql/mariadb.conf.d/50-client.cnf" pid=11886 comm="mysqldump" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
    [66791.515423] audit: type=1400 audit(1595830991.144:289): apparmor="ALLOWED" operation="open" profile="/usr/bin/mysqldump" name="/etc/mysql/mariadb.conf.d/50-mysql-clients.cnf" pid=11886 comm="mysqldump" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
    [66791.515461] audit: type=1400 audit(1595830991.144:290): apparmor="ALLOWED" operation="open" profile="/usr/bin/mysqldump" name="/etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf" pid=11886 comm="mysqldump" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
    [66791.515498] audit: type=1400 audit(1595830991.144:291): apparmor="ALLOWED" operation="open" profile="/usr/bin/mysqldump" name="/etc/mysql/mariadb.conf.d/50-server.cnf" pid=11886 comm="mysqldump" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
    [66791.516170] audit: type=1400 audit(1595830991.144:292): apparmor="ALLOWED" operation="open" profile="/usr/bin/mysqldump" name="/usr/share/mysql/charsets/Index.xml" pid=11886 comm="mysqldump" requested_mask="r" denied_mask="r" fsuid=1000 ouid=0
    ls -l /var/run/mysqld/:
    Code:
    total 4
    -rw-rw---- 1 mysql mysql 6 июл 27 09:23 mysqld.pid
    srwxrwxrwx 1 mysql mysql 0 июл 27 09:23 mysqld.sock
    DB is work well. I can login with ‘mysql -u root -p’ and via phpmyadmin. But it doesn’t work with mysqldump.
    Please help.

  2. #2
    Join Date
    Jul 2020
    Beans
    2

    Re: Mysqldump cannot connect “permission denied”

    Figured out.
    "sudo -u mysql mariabackup" has made DB backup.
    "sudo -u mysql mysqdump" doesn't work.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •