We have been talking about different MySQL operators in their guises for quite a while now: along with WHERE condition or SELECT statement, you name it. Now, the time to shine has come for the LIKE conditional operator used to search for patterns in strings with the help of wildcard characters. In this article, we will provide the basic syntax for using LIKE, along with illustrated examples of how to apply it in queries using one of the best MySQL IDEs on the market — dbForge Studio for MySQL.

The post MySQL LIKE Operator: 7 Examples and Best Practices appeared first on Devart Blog.

Quick Tour of MySQL HeatWave on AWS   MySQL HeatWave on AWS is a fully managed MySQL database service running on Amazon Web Services (AWS). It is built on the Enterprise Edition of the MySQL Database and is the only MySQL service with a scalable, integrated, real-time query accelerator with machine learning-based automation (MySQL Autopilot), […]

Quick Tour of MySQL HeatWave on AWS

On April 18 2023, MySQL Server 8.0.33 was released. It is the latest release of our MySQL 8.0 General Availability Release. The new release introduces a few new features alongside with some deprecations, as well as bugfixes and security fixes. New MySQL Enterprise Edition Data Masking Component MySQL Enterprise Edition now provides data masking and de-identification capabilities […]

Announcing MySQL Server 8.0.33

Announcing MySQL InnoDB ReplicaSet/Cluster/ClusterSet & MySQL Shell 8.0.33

When you provision a MySQL HeatWave database instance, you can only connect to the database from services inside of OCI. Using an OpenVPN running on an OCI Compute instance we can connect to a MySQL HeatWave instance from clients outside of OCI. In this post, we'll show you how to do this.

MySQL HeatWave Database is a fully managed service on Oracle Cloud Infrastructure (OCI) that is developed, managed, and supported by the MySQL team at Oracle. When you provision a new MySQL instance under OCI, you can only connect to the database from inside the OCI network. While this is a great security feature for production services hosted in […]

In this blog post, we will see how to persist the password inside the ProxySQL mysql_users table in hashed format only. Also, even if someone stored the password in cleartext, we see how to change those into the hashed format easily.

Here we are just highlighting one of the scenarios during work on the client environment where we noticed that the ProxySQL mysql_users table had more than 100 user entries, but some of them were available/inserted into the clear text password, whereas some were inserted properly into hashed entries.

Before just explaining those simple commands that were used to fix those clear text entries into the hashed entry quickly, let’s see some more information about the ProxySQL mysql_users table and the password formats.

Password formats inside ProxySQL

ProxySQL is capable of storing passwords in two different formats within the mysql_users.password …

I’m learning so much each week from just running the OpenLampTech developer newsletter to reading the great content shared within. There is always something to learn and I am thankful for your reading each week.

Custom WooCommerce and Shopify Solutions

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

Learn More

If you are not yet subscribed, head on over and grab a free subscription and get the weekly OpenLampTech publication delivered straight to your inbox.

In OpenLampTech issue #75, we are looking at …