Showing entries 366 to 375 of 44041
« 10 Newer Entries | 10 Older Entries »
Use OCI GenAI, and MySQL HeatWave to interact with your WordPress content

MySQL HeatWave 9.0 was released under the banner of artificial intelligence. It includes a VECTOR datatype and can easily process and analyze vast amounts of proprietary unstructured documents in object storage, using HeatWave GenAI and Lakehouse. Oracle Cloud Infrastructure also provides a wonderful GenAI Service, and in this post, we will see how to use […]

MyLoader Is Now Importing at Full Speed

For a long time, I’ve been thinking about the possibility of importing a single file with multiple connections. Why? Simply because we have scenarios where we end up importing a big file with a single loader thread. Well, I have good news: since the release of 0.16.3-1, we are able to do it. There are […]

MySQL Shell CLI Integration

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how to use MySQL Shell as part of system command-line integration or as party of a scripted process.

PHP and MySQL 9

Which PHP versions are compatible with MySQL 9.0?

MySQL 9.0 – it’s time to abandon the weak authentication method

The old mysql_native_password authentication method using SHA-1 is now gone with MySQL 9.

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 PHP and you want to use MySQL 9, you must be using a more recent […]

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! Reasons Oracle places significant attention on the security of all its products, and MySQL is […]

MySQL: Plugin 'mysql_native_password' is not loaded

In libera:#mysql a user has been running MySQL in a docker container with mysql:latest. This container got automatically upgraded to MySQL 9.0.0, an innovation release.

Part of the 9.0 release is the removal of the mysql_native_password plugin, which has been deprecated since 8.0. The user now can no longer login to their database. They have no backup and no replica.

We recreate the problem from scratch, using docker, and then recover the instance.

Creating a test setup

On my system, I am using LVM2, and I am routinely using the XFS file system. I am creating a 10 GB sized test filesystem, which I mount to /a. In that, we create a mysql and a conf directory.

The official …

[Read more]
Advanced Data Load with MySQL Shell

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss some of the options available to use when loading database dumps.

MySQL 9.0 is out! Thank you for your contributions!

MySQL is Open Source and accept contributions from the Community. This is the list of contributions accepted in the last releases.

Showing entries 366 to 375 of 44041
« 10 Newer Entries | 10 Older Entries »