No Image

MySQL Router 8.0.16: What’s new

2019-05-16 KENNETH 0

MySQL Router 8.0.16: What’s new MySQL Router 8.0.16 Key features log-rotation via SIGHUP HTTP server plugin flexible support for single/multi-PRIMARY Group Replication Logrotation via SIGHUP Sending a SIGHUP signal to the router process will now close and reopen the logfile. It allows the integration with the logrotate to rotate and compress the Router’s logfiles.… Facebook Twitter Google+ LinkedIn Source: MySQL Router 8.0.16: What’s new

No Image

OpenSSL FIPS support in MySQL 8.0

2019-05-09 KENNETH 0

OpenSSL FIPS support in MySQL 8.0 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.… Facebook Twitter Google+ LinkedIn Source: OpenSSL FIPS support in MySQL 8.0

No Image

Partial Revokes from Database Objects

2019-05-02 KENNETH 0

Partial Revokes from Database Objects Have you ever encountered situations where you want to grant a user access to all databases except a few databases ?  If yes, then this article will interest you.  Starting from MySQL 8.0.16, you can partially revoke database privileges from users, even if they are granted global privileges.… Facebook Twitter Google+ LinkedIn Source: Partial Revokes from Database Objects

No Image

The SYSTEM_USER Dynamic Privilege

2019-05-02 KENNETH 0

The SYSTEM_USER Dynamic Privilege To modify users, you must have the CREATE USER privilege or the UPDATE privilege on the mysql schema. We have added the SYSTEM_USER dynamic privilege to make it possible to protect users against the first case: modification by other users who have the CREATE USER privilege.… Facebook Twitter Google+ LinkedIn Source: The SYSTEM_USER Dynamic Privilege

No Image

How to create multiple accounts for an app?

2019-05-02 KENNETH 0

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.  Wouldn’t it be nice, if you could grant a user privileges to create or modify users except a few users? … Facebook Twitter Google+ LinkedIn Source: How to create multiple accounts for an app?