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 some bytes can be hidden or decoded differently depending of the terminal and font used. […]

During a migration to MySQL HeatWave, it could be interesting to cut & paste user creation statements. In this blog you learn how to achieve this.

Another packed full newsletter coming your way this week in OpenLampTech. So much goodness in this one. Take your time reading, enjoy, and share. Thank you.

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

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.

In OpenLampTech issue #97, there is great content on:

• Developer interview
• MySQL …

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 some bytes can be hidden or decoded differently depending of the terminal and font used.

Let’s have a look:

If we cut the create user statement and paste it into another server what will happen ?

We can see that we get the following error:

ERROR: 1827 (HY000): The password hash doesn't have the expected format.

How could we deal with that ?

The solution to be able to cut & paste the authentication string without having any issue, is to change it as a binary representation (hexadecimal) like this:

And then replace the value in the user create statement:

But there is an easier way. MySQL …

Here comes the success story of Specialized Media Dashboard, a project that comprises an open-source media monitoring system. The specialized media in question encompasses the spheres of journalism, law enforcement, and climate change.

The post Case Study: How the Engineers of SMD Found a Way to Process Millions of Database Records Faster With dbForge Studio for MySQL appeared first on Devart Blog.

If you are deploying MySQL on containers, one of the first tasks is to find the right image. There’s a certain amount of confusion, especially when we’re trying to help someone who’s having problems with their deployment. For example, when people say I’m using the official docker image… what does that really mean? Docker Hub, […]

Find the official MySQL container image in the Oracle Container Registry

If you are deploying MySQL on containers, one of the first tasks is to find the right image.

There’s a certain amount of confusion, especially when we’re trying to help someone who’s having problems with their deployment.

For example, when people say I’m using the official docker image… what does that really mean?

Docker Hub, provides their official image (https://hub.docker.com/_/mysql), but this is not the official MySQL image that we, the MySQL Team at Oracle, support.

Before the mess with Docker Hub ([1], [2], [3]), the real official images for MySQL …

By integrating MySQL database migrations into your testing process, you can not only ensure your testing database is up to date with the most recent changes, but you can also test that the migrations themselves are performing as expected. In this post we will walk you though how to incorporate migrations with Knex and run those migrations on your test database being run in Testcontainers.

Overview MySQL HeatWave is the perfect database service for organizations looking to analyze their data stored in MySQL. It provides a single MySQL database platform for analytic and mixed workloads, accelerates complex and analytic queries on real-time data without the complex and time-consuming ETL process.   A MySQL HeatWave instance is a cluster composed of […]