I would like to highlight a less known MySQL SQL command, analyze how it works and understand some of the decisions that need to be made when using it.
Let’s start with the basics: The Reference Manual.
It does have a lot to say about LOAD DATA.…
All posts by Georgi Kodinov
Password reuse policy in MySQL 8.0
MySQL has various kinds of password policy enforcement tools: a password can expire (even automatically), can be forced to be of a certain length, contain amounts of various types of characters and be checked against a dictionary of common passwords or the user account name itself.…
Track and Optimize Server Connection Methods
The MySQL server supports a variety of client connection methods. To summarize: you have TCP/IP (v4 and v6) on all OSes (with or without TLS/SSL encryption), Unix Domain Sockets on Unix/Linux, and Named Pipes and/or Shared Memory on Windows.
Each of these connection methods has its own set of pros and cons: speed, security, portability, and ease-of-use.…
What Makes the MySQL Audit Plugin API Special?
Why Should I Be Reading This?
To better understand how the MySQL Server functions, how to monitor the relevant server events, and find out what’s new in MySQL 5.7.8.
What’s Special About the Audit Plugin API?
Picking the right API for your new plugin is probably the most important design decision a plugin author will need to make.…
Initialize Your MySQL 5.7 Instances with Ease
MySQL 5.7.6 brings in a simplification that solves the very first problem that I encountered back in the days when I first started using MySQL 5.0. Namely…
How do I create a new database instance?
I know it sounds like a very basic question.…
Everything about MySQL Users and Logins You Didn’t Know and Were Afraid to Ask
Logging into a MySQL server is generally dead simple—supply a username, a password, and you’re all set!
There are, however, more complex use cases such as when making use of our Enterprise Authentication plugins. It’s also sometimes helpful to have a more detailed understanding of what happens “under the hood”.…
Understand and satisfy your AES encryption needs with 5.6.17
MySQL, starting from 4.0.2, had AES encryption and decryption functions. They are compiled with support for pure independent block by block encryption mode (ECB), using a 128 bit key.
128 bits is plenty enough! And sufficient for everybody! And who would even want to go to the trouble of dealing with initialization vectors?…