MySQL and Heatwave Summit Presentation

MySQL and Heatwave Summit Presentation

Last week I had the opportunity to speak at the MySQL and Heatwave Summit in San Francisco.

I discussed the impact of the new MySQL 8.0 default caching_sha2_password authentication, replacing the mysql_native_password authentication that was the default for approximately 20 of the 30 years that MySQL has existed. The new authentication plugin implements multiple strategies to improve on the insecure previous approach including using SHA256, multiple iterations and password salts.

As with any presentation, while you may have solid knowledge on any given topic, it was great for the audience to share .

Thanks Fred for informing me of print_identified_with_as_hex variable . I was unaware of this flag to address the SHOW CREATE USER issue I presented in my slides. I also did not cover in my presentation the impact of TLS versions being deprecated and removed in MySQL 8.0.x versions. Thanks Mark for reminding me. For more information read the documentation on encrypted-connection-protocols-ciphers .

SQL > show global variables like 'print%'; 
+------------------------------+-------+ 
| Variable_name                | Value | 
+------------------------------+-------+ 
| print_identified_with_as_hex | OFF |
+------------------------------+-------+

You can find a copy of my slides on my presentations page.

Tagged with: Authentication MySQL Upgrades

Producing Alternative Means statistics with SQL

Producing Alternative Means statistics with SQL

MySQL’s built-in AVG() computes the arithmetic mean — the sum divided by the count. That is the right default for many questions, but it is not always the right measure of central tendency.

Extending MySQL Capabilities with UDFs, Plugins and Components

Extending MySQL Capabilities with UDFs, Plugins and Components

MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install. These are: User Defined Function (UDF) MySQL Manual MySQL Plugin MySQL Manual MySQL Component MySQL Manual For the purposes of this post I will be using the current LTS version MySQL 8.

Producing One-Sample Z-Test statistics with SQL

Producing One-Sample Z-Test statistics with SQL

The one-sample Z-test determines whether a sample mean differs significantly from a known population mean when the population standard deviation is also known. It is the appropriate test when the population parameters are established — quality control benchmarks, national averages, long-run process measurements — and you want to evaluate whether a new sample is consistent with them.