Many products use OpenSSL, but for the most part, without choosing to incorporate the OpenSSL FIPS (US Federal Information Processing Standards) module. However it may be that running OpenSSL and using FIPs mode is something you should seriously consider and implement.…
Category Archives: MySQL
Partial Revokes from Database Objects
This is a 3 part blog series:
- Part 1: The SYSTEM_USER Dynamic Privilege
- Part 2 : Partial Revokes from Database Objects
- Part 3 : How to create multiple accounts for an app?
Have you ever encountered situations where you want to grant a user access to all databases except a few databases ? …
The SYSTEM_USER Dynamic Privilege
This is a 3 part blog series:
- Part 1: The SYSTEM_USER Dynamic Privilege
- Part 2 : Partial Revokes from Database Objects
- Part 3 : How to create multiple accounts for an app?
To modify users, you must have the CREATE USER privilege or the UPDATE privilege on the mysql schema.…
How to create multiple accounts for an app?
This is a 3 part blog series:
- Part 1: The SYSTEM_USER Dynamic Privilege
- Part 2 : Partial Revokes from Database Objects
- Part 3 : How to create multiple accounts for an app?
You can now grant CREATE USER so that your web apps would be able to use multiple accounts without you risking the end user hijacking the database by changing your root credentials for example. …
MySQL 8.0.16: mysql_upgrade is going away
As of 8.0.16, the mysql_upgrade binary is deprecated, but its functionality is moved into the server. Let’s call this functionality the “server upgrade”. This is added alongside the Data Dictionary upgrade (DD Upgrade), which is a process to update the data dictionary table definitions.…
MySQL Shell 8.0.16 – What’s New?
The MySQL Development team is proud to announce a new version of the MySQL Shell which includes the following features:
- Addition of a reporting framework:
- API to register custom reports.
- Shell command to display a specific report (\show).
- Shell command to monitor a specific report (\watch).
MySQL InnoDB Cluster – What’s new in the 8.0.16 release
The MySQL Development Team is very happy to announce a new 8.0 GA Maintenance Release of InnoDB Cluster – 8.0.16!
In addition to important bug fixes, 8.0.16 brings very useful new features!
This blog post will cover MySQL Shell and the AdminAPI, for detailed information of what’s new in MySQL Router stay tuned for an upcoming blog post!…
MySQL 8.0.16 Introducing CHECK constraint
MySQL 8.0.16 introduces the SQL CHECK constraint feature. This is one of the most requested and long awaited features for MySQL. This post describes the details of the feature. Let’s get started!
Introduction
The CHECK constraint is a type of integrity constraint in SQL.…
The MySQL 8.0.16 Maintenance Release is Generally Available
The MySQL Development team is very happy to announce that MySQL 8.0.16 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.16 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
Exporting Masked and De-Identified Data from MySQL
In all likelihood your MySQL database contains valuable and sensitive information. Within that database, MySQL protects that data using features such as encryption, access controls, auditing, views, and more. However in many cases you may need to share some of this data, but must at the same time protect that sensitive information. …