SingleStore DB

ISSUE: memsqlctl is configured to require that users be in the memsql group for read access
memsqlctl is configured to require that users be in the 'memsql' group for read access. Please rerun the command as a user in this group or the root user.

This message appears during any memsqlctl command if the current user is not in the configured management group.

The memsqlctl config file can be configured to restrict access to a single Linux user and that user’s primary group. When using singlestoredb-server Debian and RPM packages, this is set to memsql, which is the system user created by the package to run SingleStore DB.

There are multiple options for resolving this issue:

  • Run the command again as the configured user (memsql in this example).

  • Run the command again as root or with sudo.

  • Change the management user by editing the memsqlctl config file and changing the owner of all SingleStore DB-related files and directories.