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]Adminer is a full-featured database management tool written in PHP. In this tutorial, I will explain how to install Adminer on Alma Linux 8.
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]
