How to Create a MySQL User via Command Line

Reading Time: 2 minutes Previous Series:MySQL via Command Line 101: Basic Database Interaction In this article, we will be discussing how to create a MySQL user on Linux via the command line. We will be working on a Liquid Web core-managed server running CentOS version 6.5 as the root user. The commands used should work on later versions of [ Read More ]

How to Install MySQL on Windows

Reading Time: 2 minutes If you’re using a Windows-based server to host your content, you may using Microsoft’s database server product, MSSQL. However, licensing restrictions can make using MSSQL difficult, especially for small businesses. Microsoft offers a free version of MSSQL called MSSQL Express that will be suitable for many users, but this version does have limitations on database [ Read More ]

Grant Permissions to a MySQL User on Linux via Command Line

Reading Time: 2 minutes Previous Series:MySQL via Command Line 101: Basic Database Interaction Preflight Check These instructions are intended for granting a MySQL user permissions on Linux via the command line I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.

MySQL Performance: MySQL/MariaDB Indexes

Reading Time: 6 minutes Data in a MySQL/MariaDB database is stored in tables. A simple way of thinking about indexes is to imagine an extensive spreadsheet. This type of system is not always conducive to quick searching; that’s where an index becomes essential. If there is no index, then the database engine has to start at row one and [ Read More ]

MySQL Performance: Intro to JOINS in SQL

Reading Time: 5 minutes In this article, we will learn the basics of joining tables in SQL. We will learn about Left, Right, Inner, and Outer joins and give examples of how to use them. Data in an RDBMS (Relational Database Management System) is grouped into tables. These tables have a rigid definition of the type of data that [ Read More ]

3 Tips For Working With a MySQL Database!

Reading Time: 2 minutes Next Series: MySQL via Command Line 102: Basic User Interaction Pre-Flight Check These instructions are intended for deleting a MySQL database on Linux via the command line. I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.

How to Back Up And Restore MySQL Databases From The Command Line

Reading Time: 2 minutes Next Series: MySQL via Command Line 102: Basic User Interaction While automated backups are important, sometimes you just want to take a MySQL dump of the database prior to making a change to your site. When modifying files in Linux, you can simply copy a file to another name in order to make a new [ Read More ]

Troubleshooting: MySQL/MariaDB Error #1044 & #1045 Access Denied for User

Reading Time: < 1 minute When using PhpMyAdmin, it’s essential to have the correct user permissions to create edits/writes to the database.  Otherwise, insufficient permissions can lead to  errors like the ones pictured below “#1044 – Access denied for user …[using password: YES]” and “#1045 – Access denied for user…[using password: YES]”.  In our tutorial, we’ll show you how to [ Read More ]