Database Star: Home

How MySQL AI in 2025 Ends Your Struggle with Late-Night SQL

Wed, 09 Jul 2025 00:00:00 +0000

A guide to the new dbForge AI Assistant.

How to Install MySQL on Windows

Wed, 09 Aug 2023 00:00:00 +0000

In this post, you’ll learn how to install a MySQL database on Windows and connect to it using MySQL Workbench.

How to Install MySQL on Mac using a DMG File

Mon, 10 Jul 2023 00:00:00 +0000

In this article, you'll learn how to install MySQL on a Mac using an installation package, otherwise known as a DMG file.

How to Install MySQL on Mac using Homebrew

Mon, 10 Jul 2023 00:00:00 +0000

In this article, you'll see step-by-step instructions on how to install MySQL using Homebrew.

How to Create a Simple ERD in MySQL Workbench

Fri, 31 Mar 2023 00:00:00 +0000

Learn how to create an ERD in MySQL Workbench.

How to Create a Database in MySQL

Mon, 03 Oct 2022 00:00:00 +0000

If you want to create a new database in MySQL, you can either use an SQL command or follow the steps in an IDE such as MySQL Workbench.

Learn how to do it in both ways in this guide.

MySQL Create Database Command

To create a new database in MySQL, you can use the CREATE DATABASE command.

The simple version looks like this:

1CREATE DATABASE database_name;

The full command has a lot more options you can set:

MySQL Privileges The Ultimate Guide

Wed, 22 Dec 2021 00:00:00 +0000

Learn what MySQL privileges are and how they work.

MySQL ENUM: The Ultimate Guide

Thu, 14 Oct 2021 00:00:00 +0000

Learn all about ENUMs in MySQL.

How to Change User Password in MySQL

Wed, 13 Oct 2021 00:00:00 +0000

Learn how to change the password in MySQL.

Use mysqldump to Backup and Restore a MySQL Database

Thu, 07 Oct 2021 00:00:00 +0000

Learn all about the mysqldump command.

MySQL Pivot: How To Generate a Pivot Table

Mon, 04 Oct 2021 00:00:00 +0000

Learn how to pivot in MySQL.

MySQL Workbench Export and Import Database: How To

Wed, 15 Sep 2021 00:00:00 +0000

Learn how to export a database in MySQL Workbench.

How to Fix MySQL Error: Access Denied for User 'root'@'localhost'

Wed, 09 Jun 2021 00:00:00 +0000

Learn how to fix this access denied error, and see a range of solutions if the suggested fix does not work, in this article.

JSON in MySQL: The Ultimate Guide

Tue, 27 Oct 2020 00:00:00 +0000

Read this complete guide to JSON in MySQL.

How to Save MySQL Query Output to a File

Tue, 29 Sep 2020 00:00:00 +0000

Learn how to save the results of a query to a file in MySQL.

How to Import a CSV using MySQL Workbench

Thu, 17 Sep 2020 00:00:00 +0000

Learn how to import a CSV file in MySQL Workbench.

Dynamic SQL: A Guide for SQL Server, Oracle, MySQL, and PostgreSQL

Sun, 13 Sep 2020 00:00:00 +0000

Dynamic SQL is a handy feature of a database that lets you construct SQL statements in a different way.

MySQL Drop All Tables: How-To With Examples

Sun, 30 Aug 2020 00:00:00 +0000

In this article, you'll learn how to do that easily, both using an SQL command an inside an IDE such as MySQL Workbench.

MySQL Create User and Grant Permissions: How To

Wed, 26 Aug 2020 00:00:00 +0000

Learn how to create a user in MySQL.

MySQL Date Data Types and Date Functions

Thu, 13 Aug 2020 00:00:00 +0000

In this guide, we'll look at the MySQL date data types, the date functions, and see some examples of them.

MySQL Show Users: A How-To Guide with Examples

Wed, 15 Jul 2020 00:00:00 +0000

In this guide, you'll learn how to see a list of users. You'll also be able to see a list of logged-in users as well as the current user.

How to Fix The "Every derived table must have its own alias" Error in MySQL

Sun, 28 Jun 2020 00:00:00 +0000

Learn how to resolve this error.

How to Start MySQL Server on Mac, Windows, and Linux

Sun, 28 Jun 2020 00:00:00 +0000

Do you want to know how to start, stop, and restart the MySQL server? Learn how you can do that on each operating system in this article.

SQL vs MySQL vs SQL Server: What's the Difference?

Sat, 27 Jun 2020 00:00:00 +0000

Learn the difference between SQL and MySQL.

SQL Data Types: Oracle, SQL Server, MySQL, PostgreSQL

Sat, 11 Jan 2020 00:00:00 +0000

Do you want to know what the SQL data types are in different database vendors? Learn all about them and how they compare in this guide.

PostgreSQL vs MySQL: An Analysis

Tue, 07 Jan 2020 00:00:00 +0000

Are you considering using either MySQL or PostgreSQL for your next project? Read this article to find out the differences between these two databases and help decide which one to use.

SQL Stored Procedures: The Complete Guide (Oracle, SQL Server, MySQL, PostgreSQL)

Thu, 12 Jul 2018 00:00:00 +0000

Do you want to know what a stored procedure is, how it can help your SQL, and how to create one? Find out in this guide.