This blog post is an excerpt from premium MySQL Beginner content I am creating to help anyone learn how to use MySQL. Thank you for reading and please do provide feedback.
Image by Willi Heidelbach from Pixabay
You may also be interested in the blog post, MySQL Beginners Series — The SELECT statement, which is a primer for this article.
Limit …
[Read more]In keeping with my MySQL 8 user administration and security theme, I’d like to discuss the password verification-required policy introduced in MySQL 8.0.13. With this feature, it is possible to require that attempts to change an account password be verified by specifying the existing current password to be replaced.
Introduction
The password verification-required policy enables DBAs to prevent users from changing a password without proving that they know the current password. When would this happen? Such changes could occur if a user walked away from a terminal session without logging out, and a malicious user uses the open session to change the original user’s MySQL password. As you can imagine, this could have disastrous consequences:
When MySQL client connects to the server it uses one of the authentication plugins. On the server-side, plugins are located in the directory, specified by the option plugin-dir that defaults to
BASEDIR/lib/plugin
where
BASEDIR
is the base directory of your MySQL installation. This perfectly works whenever you install MySQL using package manager, or from the Linux tarball.
However, authentication plugins should be also loaded on the client-side. If you installed MySQL into the custom location, you may end up with an error when trying to connect using any plugin requiring a separate client library.
For example, let’s set the …
[Read more]I am so pleased to announce that I have published my very first mini eBook, “10 MySQL Tips For Everyone”. Continue reading to find out what it’s about, and how to get your copy.
What is the 10 MySQL Tips For Everyone eBook about?
In this eBook, I share 10 useful tips for anyone working with the MySQL database. These tips are a mix of the relatively common, and a couple of my personal own that I have realized or discovered as I continue to learn MySQL.
Here are a couple of my favorites.
So you’re (hopefully) wondering how you can get your own free copy of “10 MySQL Tips For Everyone”.
Super easy…
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
That’s it.
…[Read more]Get ready for another jam-packed full OpenLampTech newsletter issue this week. If you are a PHP/MySQL developer, this is the newsletter for you. Let’s see what this latest issue has in store…
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Just like always, we have some great curated and original content in this week’s issue:
Is MySQL performance about “more” or “less”? From the title, you can tell that I’m going to argue that it’s about “less”. Here’s the punchline: zero is maximum performance. Let’s see where this philosophical blog post leads us.
Is MySQL performance about “more” or “less”? From the title, you can tell that I’m going to argue that it’s about “less”. Here’s the punchline: zero is maximum performance. Let’s see where this philosophical blog post leads us.
Is MySQL performance about “more” or “less”? From the title, you can tell that I’m going to argue that it’s about “less”. Here’s the punchline: zero is maximum performance. Let’s see where this philosophical blog post leads us.
If you are like me, you enjoy your newsletter reading time. If you are a PHP/MySQL developer or a blogging developer yourself, then this post is definitely for you. Continue reading for additional details…
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Image by Gerd Altmann from …
[Read more]Oracle released MySQL 8.0.28 on January 18th with little fanfare, as part of their four times a year release cycle. So what is included in the new release? Over the past few years, there have been some cool new features included in these ‘dot’ releases that some in the community say would have been better off being labeled as a major release. But what is in .28? Below are the more interesting changes in the database server and the shell, as there was not a whole lot changed in the other products such as router or MEM… I put my asides in italics and my views probably do not reflect the views of anyone else.
And remember, 8.0.29 is due in April.
The TL;DR
The TL;DR synopsis is that a lot of excellent work went into MySQL Server & shell 8.0.28 but the pressing question is do you really need to install it right away? On the scale from ‘you probably should wait to upgrade’ to ‘update ASAP’ it …
[Read more]
