MySQL (Strict)

MySQL is the world's most popular open-source relational database management system, powering many of the world's most accessed applications. MySQL delivers a multi-threaded, multi-user, and robust SQL database server. It is designed to be used for mission-critical, heavy-load production systems. MySQL is fast, reliable, and powerful.

For enhanced security, this snap uses strict confinement, paired with a rootless daemon. It also requires you to set a password for the MySQL root user, as passwordless login via the Linux root user is not allowed (unlike the apt version, hence the strict suffix).

Note: During installation, a randomly generated password will be created for the MySQL root user. You can retrieve it using the following command:

 sudo mysql-strict.rootpass

Commands:

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

Tip: For convenience, you can create command aliases using snapd's alias feature.

 sudo snap alias mysql-strict.mysql mysql

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

 mysql -u root -p