Major MySQL 8 configuration options. The vast majority of options for MySQL 8 don’t need to be set out of the gate. A few, like the above-mentioned client security protocol, ...

The vulnerability affects “all MySQL servers in default configuration in all version branches (5.7, 5.6, and 5.5) including the latest versions,” as well as the MySQL-derived databases MariaDB ...

In earlier versions of Debian and Ubuntu, the MySQL configuration file was located at /etc/mysql/my.cnf. This has changed to a conf.d-style setup as of Ubuntu 18.04 and later; ...

Proper configuration of the MySQL database is extremely important, especially when you have a heavy workload. As an example, a quick test using sysbench demonstrates the impact that proper ...

With that said, let’s get this configuration up and running. ... At this point, MySQL is open for remote connections, but you’ve yet to create a user for access. 2.

The bug, CVE-2016-6662, is a privilege escalation flaw which impacts all version branches of MySQL, including 5.7.15, 5.6.33 and 5.5.52, as well as software linked to MySQL, including MariaDB and ...

This is done with the help of the mysql_config_editor tool. Let’s say we’re going to create a profile for the MySQL server, named mysql1, running on IP address 192.168.1.158, ...

A user now has the option of setting a configuration parameter to use either statement or row-based replication. The primary bottleneck for busy MySQL replication configurations is the single-threaded ...