/mysql-snap

MySQL packaged as a snap, offering improved security over the deb version

Primary LanguageShellGNU General Public License v3.0GPL-3.0

MySQL Snap

mysql-strict

Introduction

This is a community-developed MySQL snap, made with the goal to have the ability to run with minimal privileges, while maintaining the ability to run as a stable, full-fledged MySQL server.

Features

  • Strict confinement
  • Rootless daemon
  • Requires manually set MySQL root password
  • Disallows passwordless login via Linux root user
  • Support for multiple CPU architectures

Installation

Get it from the Snap Store

This snap can be installed from the Snap Store using the following command:

sudo snap install mysql-strict

Note

During installation, a randomly generated password is created for the MySQL root user. To retrieve it, issue the following command:

sudo mysql-strict.rootpass

Commands

This snap comes packaged with a number of useful commands:

  • mysql-strict.mysql
  • mysql-strict.mysqladmin
  • mysql-strict.mysqldump
  • mysql-strict.mysqlimport

Tip

For convenience, you can create an an alias for any of these commands using snapd's alias feature. For example:

sudo snap alias mysql-strict.mysql mysql

This way, you can now simply log into the MySQL server with just:

mysql -u root -p

Data

Type Location
Databases /var/snap/mysql-strict/common/data
Logs /var/snap/mysql-strict/current/log
Settings /var/snap/mysql-strict/current/etc
Sockets /var/snap/mysql-strict/current/run

Tip

For creating backups, it is recommended to use snapd's snapshot feature. See here for more details.