How to Install and Configure MySQL on a Windows Server


The article provides many images that guide you through each individual step of a MySQL installation on Windows. The elaborate setup is made easy with clear instructions and concise descriptions of each particular option.

Read More

How to Export a Table from MySQL to CSV


This article explores several highly efficient methods that allow you to export a MySQL table as a CSV file. As a CSV file, the data from your tables becomes much more accessible, both to humans and a host of other applications.

Read More

How to Rename a Column in MySQL


This article offers two slick methods to rename a column in a MySQL table. Use ALTER TABLE command combined with the RENAME COLUMN clause for a swift resolution. The CHANGE clause offers more options and allows you to micromanage the renaming…

Read More

How to Allow Remote Connections to MySQL


Keep your database servers separate from your public-facing web servers to improve security, performance, and flexibility. MySQL servers are initially set up to accept local connections. Use this tutorial to change these settings in the MySQL…

Read More

How to Remove Duplicate Rows in MySQL


When adding data to a MySQL database, you may end up with duplicate rows. This article shows you how to find these instances and delete duplicate rows in MySQL. Create a test database, add data to it and practice identifying and removing duplicate…

Read More

How To Find Duplicate Values in MySQL


Learn how to find the duplicate entries in your MySQL databases. The guide shows you how to use the GROUP BY, COUNT() HAVING, and INNER JOIN functions to locate the duplicate entries.

Read More

How to Change MySQL Server Time Zone


Your server's MySQL time zone and your own might be out of sync. Read this article to learn 2 ways of editing your MySQL time zone and make it easier for you to read server logs and data.

Read More

How to Install MySQL on CentOS 8


MySQL, the most widely used relational database management system can be installed on CentOS 8 from the default AppStream repository or from the official MySQL developer's repository. This article details both options and instructs how to secure…

Read More

MySQL Docker Container Tutorial: How to Set Up & Configure


Deploying MySQL in a container is a fast and efficient solution for small and medium-size applications. Instead of setting up a separate MySQL server, you can deploy a MySQL database container instead. These containers are lightweight and fast to…

Read More

How to Create MySQL Database in Workbench


Workbench is a cross-platform, open-source, visual tool for database management. It provides a user-friendly GUI in which you can create and maintain databases. Learn how to create a MySQL database and table in Workbench, as well as how to add data…

Read More