PHP and MySQL 9
As you can read in my previous post related to MySQL 9 and authentication, the old mysql_native_password plugin has been removed. In that post, I showed an example using PHP 7.2, the default version in OL8. If you are using…
Search Results for caching_sha2_password
MySQL 9.0 – it’s time to abandon the weak authentication method
With the latest MySQL Innovation Release, we decided that it was time to remove the remaining weak authentication plugin: mysql_native_password. We previously deprecated it and made it not default loaded in MySQL 8.4 LTS and, now, in 9.0 it’s gone!…
Perl DBD MySQL for MySQL 8.0 and 8.4 LTS
Some years ago, I wrote an article on connecting to MySQL 8.0 using the default authentication plugin (caching_sha2_password) with Perl. I also provided Perl-DBD-MySQL packages for EL7. Somebody recently left a comment as he was looking for a perl-DBD-MySQL driver…
Deploying WordPress and MySQL on OKE using MySQL Operator for Kubernetes
Let’s see how to deploy WordPress and MySQL on a Kubernetes Cluster. The Kubernets cluster we are using is OKE (Oracle Kubernetes Engine) in OCI (Oracle Cloud Infrastructure): OKE Cluster We start by creating a Kubernetes Cluster on OCI using…
Cut & Paste a User Creation Statement with MySQL 8
Sometimes it’s convenient to retrieve the user creation statement and to copy it to another server. However, with the new authentication method used as default since MySQL 8.0, caching_sha2_password, this can become a nightmare as the output is binary and…
