Showing entries 1 to 10 of 126
10 Older Entries »
Displaying posts with tag: mysql tools (reset)
How to Connect to a MySQL Database on a DigitalOcean Droplet Using dbForge Studio

Today, accessing and managing databases remotely is a fundamental skill for developers, system administrators, and anyone working with data-driven applications. In this article, we will demonstrate how to establish an SSH connection to a MySQL database on a DigitalOcean Droplet—a virtual private server that can host various applications and databases.

The post How to Connect to a MySQL Database on a DigitalOcean Droplet Using dbForge Studio appeared first on Devart Blog.

How to Remove Duplicate Rows in MySQL

Duplicates pose an ongoing risk to the data consistency and the overall database efficiency. This article will explore the issue of duplicate records, including their origins, the effects they have on databases, and strategies for swiftly detecting and permanently removing duplicates.

The post How to Remove Duplicate Rows in MySQL appeared first on Devart Blog.

Champs Recap: Devart’s Award-Winning Products in Q1 2024

Last season was quite fruitful in terms of awards scored by our products on independent review platforms. And today, we've got a lot more of those to share. Without further ado, let's get started!

The post Champs Recap: Devart’s Award-Winning Products in Q1 2024 appeared first on Devart Blog.

What’s New in MySQL 8.3: Feature Overview

The latest version of MySQL Server, 8.3, has been available as a General Availability (GA) release for a while. In case you have missed it, here is a brief recap of the newly available features and enhancements.

The post What’s New in MySQL 8.3: Feature Overview appeared first on Devart Blog.

How to Change a Column Type in MySQL

This article will walk you through the essentials of MySQL, shedding light on the intricacies of column types, and explore scenarios where altering column types becomes a necessity, exemplified through the lens of dbForge Studio for MySQL.

The post How to Change a Column Type in MySQL appeared first on Devart Blog.

How to avoid data loss in MySQL Primary Key change

Learn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key.

The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable.

How to Easily Convert Your MS Access Data to MySQL

Microsoft Access is a relational system for managing databases that is used to create small-scale databases for a single user or small teams. MySQL is a robust open-source relational database management system for more extensive data volumes and web applications.

The post How to Easily Convert Your MS Access Data to MySQL appeared first on Devart Blog.

The Future of Databases: Exploring Serverless MySQL With PlanetScale

Serverless databases are a modern approach to database technology. Unlike traditional databases, where users have to manage server infrastructure and capacity planning, serverless databases remove those complexities. Users can focus solely on their data and applications, leaving the database infrastructure provisioning, scaling, and maintenance to the service provider.

The post The Future of Databases: Exploring Serverless MySQL With PlanetScale appeared first on Devart Blog.

How to filter MySQL slow queries using pt-query-digest

The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance. In this blog post, I’m going to highlight the…

The post How to filter MySQL slow queries using pt-query-digest first appeared on Change Is Inevitable.

What Is AWS IAM? How to Connect to Amazon RDS Using IAM Database Authentication

Navigating the security landscape of cloud services can be complex, but AWS IAM provides a robust framework for secure access management. In this article, we'll explore what AWS Identity and Access Management (IAM) is and how it enhances security.

The post What Is AWS IAM? How to Connect to Amazon RDS Using IAM Database Authentication appeared first on Devart Blog.

Showing entries 1 to 10 of 126
10 Older Entries »