MySQL usr.sbin.mysqld configuration example for Ubuntu 14.04 LTS (Trusty Tahr)

Get the default configuration file usr.sbin.mysqld for MySQL, optimized for Ubuntu 14.04 LTS (Trusty Tahr). This example configuration ensures optimal compatibility and performance for MySQL, making it easy to set up and adjust to meet your needs.

Find and download the configuration file here: /etc/apparmor.d/usr.sbin.mysqld.

For more configurations and setup guides, visit our related files section to further customize your system.

    # vim:syntax=apparmor
# Last Modified: Tue Jun 19 17:37:30 2007
#include <tunables/global>

/usr/sbin/mysqld {
  #include <abstractions/base>
  #include <abstractions/nameservice>
  #include <abstractions/user-tmp>
  #include <abstractions/mysql>
  #include <abstractions/winbind>

  capability dac_override,
  capability sys_resource,
  capability setgid,
  capability setuid,

  network tcp,

  /etc/hosts.allow r,
  /etc/hosts.deny r,

  /etc/mysql/*.pem r,
  /etc/mysql/conf.d/ r,
  /etc/mysql/conf.d/* r,
  /etc/mysql/*.cnf r,
  /usr/lib/mysql/plugin/ r,
  /usr/lib/mysql/plugin/*.so* mr,
  /usr/sbin/mysqld mr,
  /usr/share/mysql/** r,
  /var/log/mysql.log rw,
  /var/log/mysql.err rw,
  /var/lib/mysql/ r,
  /var/lib/mysql/** rwk,
  /var/lib/mysql-files/ r,
  /var/lib/mysql-files/** rwk,
  /var/log/mysql/ r,
  /var/log/mysql/* rw,
  /var/run/mysqld/mysqld.pid rw,
  /var/run/mysqld/mysqld.sock w,
  /run/mysqld/mysqld.pid rw,
  /run/mysqld/mysqld.sock w,

  /sys/devices/system/cpu/ r,

  # Site-specific additions and overrides. See local/README for details.
  #include <local/usr.sbin.mysqld>
}

    
  

Config Details

Location
/etc/apparmor.d/usr.sbin.mysqld
Operating system
Ubuntu 14.04 LTS (Trusty Tahr)
Length
47 lines
MD5 checksum
7f9e4d9fab919ade956f9454010d8073

Usage

Download the raw file with wget or curl

Wget

wget -O usr.sbin.mysqld.example https://exampleconfig.com/static/raw/mysql/ubuntu14.04/etc/apparmor.d/usr.sbin.mysqld

cURL

curl https://exampleconfig.com/static/raw/mysql/ubuntu14.04/etc/apparmor.d/usr.sbin.mysqld > usr.sbin.mysqld.example