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.
- Strict confinement
- Rootless daemon
- Requires manually set MySQL root password
- Disallows passwordless login via Linux root user
- Support for multiple CPU architectures
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
This snap comes packaged with a number of useful commands:
mysql-strict.mysqlmysql-strict.mysqladminmysql-strict.mysqldumpmysql-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
| 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.