Version: Ubuntu Ubuntu 16.04.1 LTS
How do I configure mysql-server?
dpkg-reconfigure mysql-server only lets you change the password - nothing else.
I need to configure things like:
- Choose Transactional Database Only to ensure that your MySQL database will use InnoDB as its default storage engine.
- Set the InnoDB Tablespace settings to your requirements. (The default settings are acceptable.)
- Set the approximate number of concurrent connections permitted to suit your Confluence usage requirements. You can use one of the presets or enter a number manually. Refer to the MySQL documentation for further information.
- For the networking options, ensure the Enable TCP/IP Networking and Enable Strict Mode options are selected (default). Refer to the MySQL documentation on setting the networking and server SQL modes for further information.
Etc. How can I configure this?
EDIT: NB: These are examples, which I need to configure. But the question is meant to be general.