How To Fix "Mbind: Operation Not Permitted" In MySQL Error Log?

Adding the CAP_SYS_NICE Capability

CAP_SYS_NICE is a Linux capability that allows a process to change its priority or the priority of other processes. This capability gives MySQL the permissions to perform memory binding operations without restrictions.

By adding CAP_SYS_NICE to your MySQL Docker container, you fix the mbind error by giving MySQL the permissions to manage its memory allocation. This solution lets MySQL work properly without creating "Mbind: Operation Not Permitted" errors in the log files.

docker exec <container_name> capsh --print | grep cap_sys_nice

Implementing the Solution in Docker

To fix the mbind error, you can add the CAP_SYS_NICE capability to your MySQL Docker container. Here are two ways to do this:

Using docker-compose:

1. Open your docker-compose.yml file.
2. Find the MySQL service configuration.
3. Add these lines under the MySQL service:

cap_add:
  - SYS_NICE

Your MySQL service configuration should look like this:

services:
  mysql:
    image: mysql:8.0.15
    # Other configuration options...
    cap_add:
      - SYS_NICE

Another way for Docker run command: If you don't use docker-compose, you can add the CAP_SYS_NICE capability when starting your MySQL container with the Docker run command:

docker run --cap-add=sys_nice -d mysql

This command adds the SYS_NICE capability to your MySQL container, letting it perform memory binding operations without creating "Mbind: Operation Not Permitted" errors.

After using either of these solutions, restart your MySQL container for the changes to work. This should fix the mbind error and let you see actual MySQL errors in your log files.