Skip to content

Find out how moving to Kinsta could save you $2,400+ a year on site costs.

MySQL Database

Sitting at a laptop figuring out how to mysql delete table

How To Use MySQL to Delete a Table (2 Methods)

This guide will show you how to easily use MySQL to delete a table using two methods via your hosting control panel.
Reading time
8 min read
Publish date
May 24, 2022

All Articles

PostgreSQL vs MySQL: Explore Their 12 Critical Differences

Choosing between PostgreSQL vs MySQL can be challenging. There are plenty of things that set them apart. Learn more in this in-depth guide.
Reading time
22 min read
Publish date
May 16, 2022

The Best in Open Source Database Software: Top 10 Picks

A dynamic website needs to store data. In this post, we'll round up ten of the best open source database software around!
Reading time
17 min read
Publish date
January 20, 2022

How To Create and Manage a MySQL User (4 Key Processes)

Need to add more users to your MySQL database? Learn how to create and manage MySQL users using this simple-to-follow guide.
Reading time
11 min read
Publish date
December 9, 2021

How to Complete a MySQL Performance Tune (4 Key Tips)

Use any of these four tips to complete a MySQL performance tune to optimize your database so the software can respond to queries faster.
Reading time
9 min read
Publish date
November 1, 2021

How to Set Up a MySQL Community Server on Your Machine

Setting up a MySQL community server doesn't have to be a headache. Here, we walk you through it, step-by-step.
Reading time
10 min read
Publish date
June 18, 2021

How to Change Your MySQL Password in XAMPP (3 Methods)

Learn how to change your MySQL root password in the XAMPP local web development tool.
Reading time
6 min read
Publish date
April 22, 2021

What Is the Default MySQL Port Number?

The number of ports used by MySQL depends on several factors but the default MySQL port is 3306. Learn more about it & how to connect to a MySQL da…
Reading time
3 min read
Publish date
August 4, 2020

What Is MySQL Hostname and How to Find It?

What is MySQL hostname? In this article, we'll explain what it is and show you how to find MySQL hostname in MyKinsta, WordPress, cPanel, and more.
Reading time
4 min read
Publish date
March 19, 2020

How to Fix the MySQL 1064 Error (5 Methods)

Learn how to fix "the MySQL 1064 error" message once and for all. This is a syntax error, which means MySQL isn't able to understand your command.
Reading time
6 min read
Publish date
November 7, 2019

What Is MySQL? A Beginner-Friendly Explanation

Wondering "What is MySQL?" In this post, we give you a beginner-friendly explanation and show you how MySQL works in relation to WordPress.
Reading time
7 min read
Publish date
April 15, 2019

How to Backup MySQL Database (2 Incredibly Easy Methods)

Perhaps you want a 2nd backup or need to migrate WordPress hosts. In this tutorial we share with you two incredibly easy ways to backup your MySQL…
Reading time
4 min read
Publish date
January 18, 2017

MySQL Storage Engine – How to Convert MyISAM to InnoDB

The MySQL InnoDB storage engine has been shown to perform faster and be more reliable. Follow this quick tutorial on how to convert MyISAM to InnoDB.
Reading time
2 min read
Publish date
December 8, 2016